Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
7 views
ago in Power Apps by 21 25 32
I'm building a gallery in Power Apps that pulls data from a SharePoint list. The list contains over 5,000 items, but I noticed that only a portion of the data is loaded into my app. Is there a default limit on the number of items Power Apps can retrieve? If so, can this limit be extended, and what are the implications of increasing it?

1 Answer

0 like 0 dislike
ago by 164 225 450

Number of items Limits Power Apps can retrieve in SharePoint

By default, Power Apps can retrieve up to 500 items from a data source. This limit can be extended to a maximum of 2,000 items by adjusting the app settings. However, increasing this limit might impact performance, especially with larger datasets.

PowerApps Data Row Limit Settings

Power Apps has a delegation limit of 2,000 items for SharePoint Online by default. Delegation techniques must be used to handle larger datasets efficiently, such as filtering or sorting data at the source instead of loading it entirely into Power Apps.

  • Open App Settings
  • General > Data row limit.
  • Set the value from 1 to Max 2000.

Data row limit in Power Apps

See also, How to overcome PowerApps Delegation limit?

If you don’t ask, the answer is always NO!
...