Not Getting Your Items from SharePoint List via Power Automate?

DoufuDoufu
1 min read

Typically, one would expect the "Get Items" action for SharePoint in Power Automate to retrieve all the records in the list. However, that is not the case. Apparently the action retrieves only 100 items by default. To pull the entire list of items from the SharePoint list, you would need to set the "Top Count" filter to a maximum of 5000 items (without pagination).

To get more than 5000 items, you can enable "Pagination" via the settings of the action. The maximum items that can be retrieved is 100000.

0
Subscribe to my newsletter

Read articles from Doufu directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Doufu
Doufu

Current project developments on Microsoft platforms such as Business Central, Dynamics 365 Sales, Power Platform and occasionally Python. Used to get my paws dirty on Android and Web development.