I've had to workaround this issue and use multiple Collect() functions.
We have like 5k+ records, so I've done:
Really long winded but only way I could get it to collect all records.
If you use this put the collect on page visible as it does take a good 5-10 seconds to collect everything.
Thanks for th reply - That's a good idea and I'll have a play with it, but I've got users with a very low tolerance for loading times and filtering alphebetically might not suit our purposes.
Know exactly what you mean.
I've currently put it on HomeScreen OnVisible, that way by the time a user gets to where they need to be most of the records have already loaded in.
Just a matter of adapting it & trying to get each load close(ish) to say 400 record mark, that way it doesn't take too long to load (as you have less Collect()'s running) & you wont have to change your code if you get more records.
I've only put the Name as an example, if you have a standard ID field or something you could load ID 1-400, 401-800 etc... or whatever means you can use to break down your records.
Just a suggestion until they implement delegation for this, or another way to load in more than 500 records.
You can opt for Azure database to solve the limit issue. It is really lifesaver for this kinds of limitation to delegables like Filter, sort.
OK, So I've spent a bit of time learning the basics of SQL for Azure and set up a data table only to discover that it's not a solution at all, since Distinct still doesn't work as a delegable function. I am seriously at the point of giving up. I need to be able to filter a column of 5k+ lines down to unique values only and, as far as I can see, thre is literally no way to do that here?
I would suggest you to use 'Filter' to narrow down to required records and then implement Distinct function on the filtered results.
And someone has already posted an idea to get Distinct function delegable:
Share me your formula/requirement to understand the problem better to find solution.
You can change the 500 limit in app settings.
It's a shame that it can be changed only up to 2000. I think in some cases Delegation is impossible. Here is more info: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#delegable-data-sour...
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021