This usually happens due to a delegation limitation.
Possible reasons include:
- The gallery formula uses a non-delegable function
- Power Apps cannot send the query to SharePoint
- Only the first 500 records are processed locally
Example:
Search(TrainingRequests, txtSearch.Text, EmployeeName)
Since Search() is not delegable in SharePoint, Power Apps evaluates only a limited portion of the dataset.
Developers should check:
- Delegation warnings
- Data row limit settings
- Function support for the data source.
To understand how delegation warnings occur and how to fix delegation issues in real apps, see the
Complete Power Apps Delegation Interview Guide â
