Power Automate · SharePoint connector
Exceeds the list view threshold
Short answer
This Power Automate error means a SharePoint Get Items action is returning more than 5,000 items. Add an OData filter on an indexed column, or use $top=5000 with pagination.
VerifiedLast verified
01Error text
The requested operation is prohibited because it exceeds the list view threshold.02Likely causes
- SharePoint Get Items is returning more than 5,000 items.
03How to fix it
- Add a filter query or OData filter to the Get Items action so it returns fewer than 5,000 items.
- Use
$topwith pagination, and filter on an indexed column.
iNotes
The connection guide quotes the same error as "The attempted operation is prohibited because it exceeds the list view threshold".
04Official documentation
→Related errors
- WorkflowRunActionRepetitionQuotaExceededWorkflowRunActionRepetitionQuotaExceeded in a Power Automate cloud flow: An Apply to Each loop exceeded the maximum number of iterations (default: 100,000 for premium, 5,000 for performance profiles). The most likely fix is to filter data before looping.
- BadRequest (400)BadRequest (400) in a Power Automate cloud flow: The connector API rejected the request because the input data is malformed or invalid. The most likely fix is to validate input data format.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Power Automate work:Open Power Automate jobs