Yes it applies to any data source. However you can use delegation for huge databases. What you have to keep in mind is that you can at most bring 500 records from your database to your app.
That means if you have SQL server with 15000 records of users, you can go through them all in PowerApps, but you have to setup your filtering that at most you return 500 rows at any given time. For example filtering your users by their first name.
You can read about delegation here:
There are some workarounds with which you can bring in more data to your App at once, by using collections.
Collection is a local data source for the app, there is nothing to be delegated to as the data is already loaded into app memory. Collections have no limit on how large they can be, but huge collections will impact performance, I believe.
"but you have to setup your filtering that at most you return 500 rows at any given time."
How can one possibly *guarantee* and know for sure that a given filter will never attempt to return > 500 rows - when your recordcount is in the thousands?
Seems like you would always be wondering ... "Am I seeing all the records" ?
Nope, even collection cannot store rows above 500 rows if the data is from Excel and this is too annoying as we cannot use powerapps for such kind of data limitation.
Is there any way to use filter function to view desired rows from the excel containing above 500 rows?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.