Limitations and delegation
When working with SharePoint lists and libraries with Power Apps, as well as with other data sources, it’s important to understand the limitations. By default, Power Apps returns the first 500 data rows from the data source. This limit can be increased to 2,000. Bringing 2,000 items from a SharePoint list to an application might not be generally a good idea. One key target to build efficient applications is to minimize the data retrieved and only bring data that is needed for the application.
For handling larger datasets, Power Apps utilizes a feature called delegation. Delegation moves data processing to the data source – for example, filtering the returned dataset to include rows created within two weeks or sorting rows alphabetically by title. Not all connectors and operations support delegation, and it’s always important to refer to the data connector’s documentation.
SharePoint also supports delegation when used as a...
