Hello Community,
We have a flow where we use Get Items or Get files (properties only) actions. In both cases we also use Filter Query within a control.
Filter Query - FileOwner eq null and ExpiryDate eq null
We have Large 10k plus data records in a Document Library
Unfortunately, when we have large data (more than 5000 items, in some cases we have 200000 items) these flows run but not doing anything. The idea was that they will go through the large collection of items doing 5000 records at the time.
For now we turned on pagination in the Settings of Get Items or Get files and it helps with the threshold set to 10,000.
But even if I turn on the pagination - the flow sequentially/serially checks the 10,000th Record and STOPS! - it does not check 10,001th Record
Is there a work around? Your help will be really appreciated.