Frustrated with Delegation

[astrontelstar]

I have a PowerApp with my db table in Dataverse.

I am approaching the 2000 limit (currently 1950) of purchase orders in my db table.

My users need to be able to search the entire database for all the orders of any given client and I display these PO's in a gallery for them to interact with.  I've been testing what happens if I have more than 2000 with my search and it appears I am going to have an issue with the search tool not returning some PO's from clients on anything over the first 2000. 

I built a test table with 3000 records of name, ponumber and have tried searching all records that just contained "PO" as the first part of the text to see if I could build a collection for a gallery that showed all 3000 records and it stops at 2000 every time which tells me my logic isn't delegable.

What are people doing that have larger numbers of records?  I can't fathom any good business that wouldn't need to run a query to search thousands of records, not limited to 500 or 2000.  I can't seem to get a logic that is delegable on this recordset to work to let me have my collection of all 3000 records (or any number I wish).  

[Pstork1 · Accepted solution]

Unless you use multiple requests to pull the records into a collection, you are correct you can't access more than 2,000 records at a time. But Users can't really interact with 2,000 records all at once and trying to pull that many records will hurt the performance of the app, which will also lead to poor user adoption. The key is to pull the records you want to work on. For example, all the records for a client from last month. 

for the case of the ForAll() you are correct. That is better done with Power Automate. Power Apps is a declarative language so the ForAll isn't actually a loop. It applies a formula to all the records covered by the criteria simultaneously. If you want an actual loop use a flow.