By default, Power Automate’s “Get Items” action in SharePoint returns a maximum of 5000 items. However, you can increase this limit by using the “Filter Query” option.
Here are the steps to follow:
Note that retrieving large amounts of data can affect performance and cause timeouts. It’s recommended to filter your data as much as possible and to test your flow thoroughly before running it in production.
The 5000 limit on SharePoint refers to the default threshold for the maximum number of items that can be displayed in a list or library view before SharePoint uses paging to display the remaining items. This limit is in place to prevent performance issues, such as slow loading times or timeouts, that can occur when working with large lists or libraries.
When a list or library contains more than 5000 items, SharePoint automatically enables server-side paging to display only a subset of the items at a time. This means that when a user navigates to a view that exceeds the 5000 limit, they will only see the first 5000 items and will need to use pagination or filtering to view the remaining items.
It is possible to increase the threshold beyond the default limit of 5000, but doing so can impact performance and should only be done after careful consideration and testing. Additionally, certain features such as lookup columns, indexing, and certain types of queries may be impacted by the threshold limit.