Flow template for a very fast & customizable way to read, filter, & search on large SharePoint lists.
At a high level, it gets the highest & lowest ID numbers from the list, & uses those to calculate how many batches it needs to read in from SP. Then concurrently reads those batches in using the SP HTTP action. If there is a search term, it uses a filter array contains method that works on many cases where substringof filters do not work.
Then it does some reformatting of all the batches of data so it can get everything into a single combined JSON array, like what you would normally get out of a SP Get items with pagination turned on.
Once it has the single combined JSON array, it applies the sort on the given column in the given order.
Original No Delegation Power App the flow was built for: No Delegation Limit - SharePoint List Power App - Power Platform Community (microsoft.com)
(Contains explanation of how to import the solution package)
Once in the solution package, the relevant flow is “Large SP List Query”
