As outlined in detail in the Understand delegation article, delegation is where PowerApps will delegate the processing of data to the data source rather than moving data to the app for processing locally.

Delegation is supported for tabular data sources only. This list identifies tabular data sources and whether they support delegation, with details in the next section.

  • Common Data Service - Yes
  • SharePoint - Yes
  • SQL Server - Yes
  • Dynamics 365 - Yes
  • Salesforce - Yes
  • Excel - Coming soon
  • Dynamics 365 for Operations - Not yet
  • Dynamics 365 for Financials - Not yet
  • Dynamics NAV - Not yet
  • Google Sheets - Not yet

More tabular data sources and delegation support for them are being added continuously.

This document lists the current state of supported delegation per data source.

Prerequisites

List of data sources and supported delegation

This list of data sources and delegable functions and predicates will be updated periodically to reflect the current status of delegation support in PowerApps.

Top-level delegable functions

  Common Data Service SharePoint SQL Server Dynamics 365 Salesforce
Filter Yes Yes Yes Yes Yes
Sort Yes Yes Yes Yes Yes
SortByColumns Yes Yes Yes Yes Yes
Search Yes1 No Yes Yes Yes
LookUp Yes Yes Yes Yes Yes

1For string fields only

Filter and LookUp delegable predicates

  Common Data Service SharePoint SQL Server Dynamics 365 Salesforce
Not Yes No Yes Yes Yes
IsBlank No No Yes Yes No
TrimEnds No No Yes No No
Len No No Yes No No
+, - No No Yes No No
<, <=, =, <>, >, >= Yes Yes (only =) Yes Yes Yes
And (&&), Or (||), Not (!) Yes2 Yes (except Not(!)) Yes Yes Yes
in No No Yes No Yes
StartsWith No Yes No No No

2For operators only. And/Or/Not function not delegated.