Resources · Power Apps

Delegation in Power Apps: what the warning means and how to check your formula

What the delegation warning in Power Apps means, how SharePoint, Dataverse, and SQL Server differ, and how to check your formula.

01Questions and answers

Frequently asked questions

What does the delegation warning in Power Apps mean?

Power Apps can't pass the entire query to the data source. The app then evaluates only the first records up to the data row limit (500 by default) locally. With large data sources, results may be missing.

What is the delegation limit?

500 records by default. You change it under Settings > General > Data row limit, up to a maximum of 10,000.

Does raising the data row limit help?

It can be enough for small data sources. It can slow down data retrieval and doesn't return complete results above the limit.

Why doesn't Power Apps show a warning for collections?

Collections are already in app memory. The limit applies when you fill them, though: ClearCollect loads only up to the data row limit from a connected data source.

Is Search delegable with SharePoint?

Microsoft doesn't list Search as delegable for SharePoint. StartsWith in a Filter is delegable for simple text columns, but it only searches at the beginning of the text.

How can I check my app for delegation issues?

Look for warnings and test with a low data row limit and suitable test data. The Performance Check for Microsoft Power Apps includes checkpoints for delegation.

02Next step

Does your app show delegation warnings or load slowly?

Review your canvas app with the Performance Check for Microsoft Power Apps: 64 checkpoints, a scoring workbook, and a handbook.

Your process. My solution.

Tell me where things get stuck today - in a free, no-obligation initial consultation via Microsoft Teams, we will clarify what the Power Platform can do for your process and what a sensible first step looks like.