If I have a list that contains, for example,
If I apply the following settings in the
Get items action:
Top Count: `5000` Settings > Pagination > Threshold: `100000` Odata filter: `ExpiryDate ne null and ExpiryDate eq '2022-09-08'` (this filters the list to entries where the ExpiryDate column value is not null AND is equal to todays date)
Which of the following behaviours will occur:
A) Get items will search the whole list of 3,000,000 items and return a maximum of 100,000 results
B) Get items will only search 100,000 items out of the 3,000,000 items in the list?
(and therefore not do a full search of the list)
C) Something else?
What I am really trying to clarify is:
Does the Pagination Threshold setting in the
Get items action relate to how many items can be returned or how many items can be searched?
It would also be good to know:
If I set Pagination > Threshold to
100,000, what should I set the
Top Count value to and why?
I don't understand the relationship between
Top Count and
To specify the number of items to be returned, expand the Advanced options, and specify the number in the
Top Countaction property.
However, the following test proves that statement to be wrong:
List Items: 3,600 Pagination Threshold: 5,000 Top Count: 500
Get items action with the above configuration will return ALL items in the list (i.e. 3,600).
In-depth analysis into Get items and Get files SharePoint actions for flows in Power Automate
How to get more than 5000 items from SharePoint Online in Flow
More action settings and four new connectors
Limits for automated, scheduled, and instant flows
Working with Large Data in Power Automate through Pagination (Video)