I'm trying to get more than 2.000 records into PowerApps and I'm trying to decrease the number of every screen using let's say Projects and users (user()) on a filter. Then we're all good because no one Seller has more than 100-150 records to retrieve in real life.
I'm using an SQL Table and I receive the message of delegation warning when I'm trying to get the number of rows in advance when I'm trying to get data from the source. That's fine!!
I'll decrease/kill the number of active records (open cases that need to be retrieved) every day from the SQL using agent and Store Procedures e.g the completed cases. Still, if a seller will have more than 500 open cases (of course I will not fire him for postponing to-does) I should be happy to get the latest regarding the date 500 records and not to let SQL mechanism and gateway to choose the top or whatever 500 or 2000 records to Power Apps.
Question A: Can I control what "delegated" data will be eligible to be imported/linked at PowerApps? Let's say from biggest recID to smaller or with "where" functions
Question B: Can I use multiple small tables for every user() and then determine for user A --> use the TableA for userB-->use the tableB something like @dbo.tableXXX wildcard? (this is silly because no one can handle 200 tables at once and then even 200 union all )