The placeholder text in the Top Count
field in the Get Items action says:
Total number of entries to retrieve (default-all)
That placeholder text communicates to me that, by default, it gets ALL items in the list.
This official article from Microsoft, however, states that it only retrieves 100 items
by default with a maximum of 5,000
if that number is entered in the Top Count
field:
In-depth analysis into Get items and Get files SharePoint actions for flows in Power Automate
Can anyone please confirm:
- What is the default number of items that are retrieved by the
Get Items
action? - What is the maximum number of items that can be retrieved by the
Get Items
action? - What is the difference between the
Top Count
field and thePagination Threshold
setting? - Do all these item limitations relate to how many items can be searched OR how many items can be returned?
- What options are there for getting more than 5,000 items from lists which can technically store up to 30 million items?
This article suggests that the Send an HTTP request to SharePoint action can retrieve all items in a list, thus overcoming a maximum limit of 5,000 - is that true?
Edit:
After comments, if I set Pagination
> Threshold
in Get Items
settings to 100000
, when I save the flow, I get this error:
Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'Get_items_-_*******_list' of type 'OpenApiConnection' at line '1' and column '1047' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'.'.
There is possibly other reports of this error here and here.
Related Reading:
How to get more than 5000 items from SharePoint Online in Flow
More action settings and four new connectors
Working with the SharePoint Send HTTP Request flow action in Power Automate
While using
Get items
on lists with more than 5000 items with a filter query, you may observe that no records are returned if there are no items matching the filter query in the first 5000 items. To fix this, enable Pagination on Get items from the action settings menu when working with lists with more than 5000 items.