0

The placeholder text in the Top Count field in the Get Items action says:

Total number of entries to retrieve (default-all)

enter image description here

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 the Pagination 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'.'.

enter image description here

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.

Source

1 Answer 1

3

By default the Get items action retrieves only 100 items from a SharePoint list.

If you want to retrieve more items from a SharePoint list, you can enable Pagination via the settings of the Get items action.

You can retrieve a maximum of 100,000 list items:

enter image description here


Update from comments:

Here's the hint by Power automate flow related to 100000 limit

The threshold should be a number greater than 0 and less than or equal to 100000.

enter image description here

5
  • Thank you again. 1) What is the relationship between the Top Count field and this Pagination threshold? Just so I understand correctly, say that I have a list of 500,000 items - and I wanted to use Get Items to iterate over all items in the list, what would I set Top Count and Pagination to? 2) Is there official docs somewhere that say 100,000 is the max number allowed in Threshold field? 3) Any clarification on whether this 100 and 5,000 item limit refers to how much is returned OR how much can be searched would be appreciated! Sep 8, 2022 at 8:23
  • 1
    If you mention Top Count = 5000 and Pagination = 100000, Get Items action will fetch list items in batches of 5000 items and it will retrieve total of 100000 list items. Sep 8, 2022 at 8:24
  • So it can return a maximum of 100,000 items, can it still search a list of 500,000 items? Sep 8, 2022 at 8:26
  • 1
    check updated answer for limitation about 100000 items. Sep 8, 2022 at 8:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.