Forum Discussion

AjayM's avatar
AjayM
Copper Contributor
Feb 23, 2026

SharePoint List View Threshold Error while Fetching 5000+ Records in list.

I am fetching data from a SharePoint list that contains more than 5000 records inside my function. While retrieving the data, I am getting the following error:

“Flow Reminders→ The attempted operation is prohibited because it exceeds the list view threshold.”

 

Scenario:

  • The SharePoint list has 5000+ items.
  • Data is being fetched programmatically.
  • The error occurs during query execution.

    What I need help with
    What is the recommended and best-practice approach to retrieve large datasets from a SharePoint list without hitting the list view threshold?
    Questions:
  1. What is the recommended approach to fetch large data from a SharePoint list without hitting the list view threshold?

    Any suggestions, examples, or documentation references would be greatly appreciated.

Thanks.

No RepliesBe the first to reply