cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iowakrz
Regular Visitor

500 row limit

Does it apply if your data is on an Azure sql server?

5 REPLIES 5
Anonymous
Not applicable

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:

https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

 

There are some workarounds with which you can bring in more data to your App at once, by using collections.

iowakrz
Regular Visitor

Thank you. The article says collections are not delegated. Is that still the case?
Anonymous
Not applicable

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.

 

RE:

"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" ?

 

DatabaseMX ('mx')
Microsoft Access MVP

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?

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,540)