For each Get Items request, the flow should pass the last ID from the previous batch. The logic is simple: the flow should be designed to get the items in batches of 5000 items each, using a filter query. If you don't have a Premium plan or if you want to get more than 100,000 items, you can use a Do Until control to loop through all items in the SPO list.
The maximum threshold you can set today is 100,000. Note that you will need a Flow Premium Plan ( Plan 1 or Plan 2) in order to set the Pagination threshold to more than 5000 items, as documented here. The flow will take longer to run, but the action will return all the results, as expected: Turn ON the Pagination feature and set the threshold to 100,000: To get more than 5000 items, you can turn ON the Pagination feature. Using the same Compose action and expression as above, you can see that the result is 5000: Getting more than 5000 items Using the Pagination method More specifically, when you add a Top Count to the Get Items action, a $top parameter is added to the query that's sent to SharePoint Online and thus more than 100 items are retrieved. The maximum top count you can enter is 5000, which changes the way Flow sends the Get Items request to SPO. If you want to increase the limit, you can enter a Top Count value. To count the items from any array, you can add a Compose action with this expression: length(body('Get_items')?)Īnd the result looks like this: 5000 items limit Given that the Get Items request is designed to get 100 items max, then if you don't put anything in the Top Count field, the action will retrieve 100 items. The hint text mentions that the action will retrieve all items by default (default = all), which is technically correct, because all refers to how many items can be pulled by the request.
This limitation is not very obvious, even if you show the advanced options on the action and read the hint text on the Top Count field. You have a large SharePoint list and you need to get all those items in Flow.īy default, each request you send from Flow to SharePoint Online will return a response limited to 100 items.
0 kommentar(er)
