SharePoint lists have a 5000-item view limit. So, to work with lists having over five thousand items in Power Automate Flows, we put all the list items into an array instead of using SharePoint’s Get Items action.
For ease of maintenance and efficiency we put the solution that places all the list items into an array into a Child Flow. The Child Flow loops through the SharePoint list grabbing five thousand records each time then places those records to an array. After retrieving all list items, the Flow returns the array to the Parent Flow.
The Parent Flow, which needs the data, must now reference the data in an array instead of the JSON returned by the Get Items action. We use a Filter Array action to get only certain items from the array. Finally, we loop through the array using Apply to Each and the output of the Filter Array.
Type: Power Automate
Date: 2023
