Power Platform Community Forum Thread Details

So I have a Sharepoint list that has passed 500 stored items and the list filter has simply stopped showing the new items. After some brainstorming I found out about the Data line limit which has a maximum number of 2000. I want to know: when my list passes 2,000 records, will I no longer be able to get this new data? Or is there some way of storing the new data? Through a collection for example?

Categories:

Building Power Apps

@Pizzolati - regarding row limits, Power Apps will never return more than 2000 records at a time. However, you can certainly view more than 2000 records. For example, add your data source into the Items property of a Gallery control, and then add the following onto a separate Label control:

'Your Gallery Name'.AllItemsCount

Select your Gallery and start scrolling down. You will see the Label control generating a count of items on display. Eventually, you will see the Gallery has been populated with more than 2000 records and those records will be loaded into memory during the app session (which can impact performance).

Regarding the Data Row Limit setting, specific server side operations can be "delegated" to the server to undertake instead of Power Apps; with the result returned back to your app. However, not all operations can be delegated back to the server and instead must be handled by Power Apps. Power Apps will perform the operation, but only against the first 500 records (up to a maximum of 2000).

What is delegable and not delegable is also dependant on your data source, and the data type.

For example, no functions are delegable with Excel, but functions like the Filter and LookUp functions are delegable with SharePoint and Dataverse. However, the In function, while delegable with a Single Line Text data type with with Dataverse, is not delegable whatsoever with SharePoint.

Further reading:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview