@bdc604 you can now increase the limit beyond 500 records (upto 2000 I believe). I can understand your frustration, but not the sentiment you express. With a little exploration and help from the great community here, it's amazing what one can achieve with PowerApps, there's no shortage of amazing Apps that have been built by members of the communiy here.
If you're just trolling, then I suggest you do it elsewhere. The PowerApps community has by far the best and most helpful members I've come across anywhere.
The EXPERIMENTAL 2000 row limit is equally arbitrary and almost as prohibitive as 500. I have not been able to get the feature to perform correctly (but there are no guaranties with experimental features).
I think the frustration is more than fair. @bdc604 is not attacking the PowerApps community. He or she is holding up a mirror to the flaws in a badly formed (or at the very least prematurely released) product that has developers writing work arounds to accomplish basic tasks.
Heres a question; has SharePoint delegation been resolved yet? That is, having SharePoint perform any filtering requirements on the backend and returning only the result? I'm finding conflicting answers online; yes it has, no it hasn't.
If I have a list with 5000 items and only need to return 1 based on a filter condition, will PowerApps (or Flow for that matter) give up after looking at the first 500 (or first 2000) and say 'meh, I tried, couldn't find it', even though it is actually there?
I am looking for a similar solution. I have two tables. Table A has one email and one phone number column. I need to perform a lookup in another table, Table B. Table B has 4 different phone number columns (home, work, cell, other) and two different email (home and work). I need table A to run essentially a conditional lookup on table B, for 4 different columns on the phone and then 2 columns for the email and then return a boolean value. Thoughts?.
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