Power Apps

Delegation Warning — Blue Underline Delegation Warning

A blue underline appears under a formula with a delegation warning.

Root cause

The formula contains a function (like Search() or complex Filters) that the data source (like SharePoint) cannot process on the server side. Power Apps will only download the first 500 records (by default) and process the formula locally.

How to fix it

  1. Rewrite the Filter() to use delegable operators like "=" or "StartsWith()".
  2. For SharePoint, avoid the "in", "Not", and complex logical operator groupings when dealing with large lists.
  3. If the dataset is relatively small, you can increase the data row limit to 2000 in App settings.

Decode any M365 error

Paste an unfamiliar error message into the interactive decoder — it searches every code in this catalog and explains the cause in plain English.

Open the Error Decoder →