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

Power Automate error
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

  1. Add a filter query or OData filter to the Get Items action so it returns fewer than 5,000 items.
  2. Use $top with 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

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.