Delegation Warnings: What They Mean and How to Fix Them

The Yellow Warning Triangle

When you see this warning, your function can't be delegated. The app will only process local data (up to 2000 records by default).

Common Non-Delegable Functions

• Search() - Use Filter() with StartsWith() instead
• Len(), Left(), Right() - Calculate in data source
• IsBlank() on some data sources - Use = Blank()
• in operator - Use multiple Or conditions

Delegation Patterns

Pattern 1: Use StartsWith Instead of Search

// Non-delegable
Search(Customers, SearchBox.Text, "Name")

// Delegable alternative
Filter(Customers, StartsWith(Name, SearchBox.Text))

Pattern 2: Pre-filter with Views

Create Dataverse views that pre-filter data, then use the view in your app.

Pattern 3: Server-Side Calculated Columns

Instead of using Year(Date) in Power Apps, create a calculated column in Dataverse.

Increase the Limit (Temporary Fix)

Go to Settings > Upcoming features > Experimental > Data row limit and increase to 2000. This is not a real solution for large datasets.

Data Source Delegation Support

Best practice: Design your data model with delegation in mind from the start. It's much harder to fix later.