Interactive reference for Power Fx function delegation across data sources.
✅ Delegable⚠️ Partial❌ Not delegable
62 delegable, 5 partial, 113 not delegable
Function
Dataverse
SharePoint
SQL Server
Salesforce
Excel Online
Filter
Table shaping
Search
Table shaping
Sort
Table shaping
SortByColumns
Table shaping
LookUp
Table shaping
CountRows
Aggregation
Sum
Aggregation
Average
Aggregation
Min
Aggregation
Max
Aggregation
StartsWith
Operators
EndsWith
Operators
IsBlank
Operators
= (equality)
Operators
<> (not equal)
Operators
>, >=, <, <=
Operators
And / Or
Operators
Not
Operators
in (membership)
Operators
exactin
Operators
AddColumns
Table shaping
DropColumns
Table shaping
RenameColumns
Table shaping
ShowColumns
Table shaping
Distinct
Table shaping
GroupBy
Aggregation
Ungroup
Aggregation
FirstN
Table shaping
LastN
Table shaping
Concat
Text
Len
Text
Trim / TrimEnds
Text
Upper / Lower
Text
Year / Month / Day
Date
Today / Now
Date
DateAdd / DateDiff
Date
Showing 36 of 36 functionsLast verified: 2026-03-01 | Microsoft Docs
About delegation warnings
When Power Apps cannot delegate a function to the data source, it retrieves only the first 500 rows (or 2000 if increased in settings) and processes them locally.
This can silently return incomplete results. Always check the yellow triangle warning in Power Apps Studio.
The default row limit can be increased to 2000 in app settings, but cannot exceed that.