Power Apps delegable functions and operations

 Power Apps delegable functions and operations

Reference

Delegation is supported for certain tabular data sources only. If a data source supports delegation, its connector documentation outlines that support. For example, these tabular data sources are the most popular, and they support delegation:

Dataverse

1. Numeric with arithmetic expressions (for example, Filter(table, field + 10 > 100) ) aren't delegable. Language and TimeZone aren't delegable.

2. Doesn't support Trim[Ends] or Len. Does support other functions such as Left, Mid, Right, Upper, Lower, Replace, Substitute, etc.

3. DateTime is delegable except for DateTime functions Now() and Today().

4. Supports comparisons. For example, Filter(TableName, MyCol = Blank()).

5. The aggregate functions are limited to a collection of 50,000 rows. If needed, use the Filter function to select 50,000

6. CountRows on Dataverse uses a cached value. For non-cached values where the record count is expected to be under 50,000 records, use CountIf(table, True).

7. For CountRows, ensure that users have appropriate permissions to get totals for the table.

SharePoint

• Expressions that are joined with And or Or are delegable to SharePoint. Not isn't delegable.
• SharePoint supports delegation of complex types by deferring the decision for delegation to the subfield involved. Check the type of the subfield being used on the complex type and then check this table for delegation capabilities. Note that only Email and DisplayName are delegable in the Person data type.
• The SharePoint ID field for a table is a number field in Power Apps. However, SharePoint only supports the equal ('=') operation for delegation on an ID field.
• A formula such as Filter(..., IsBlank(CustomerId)) won't delegate to SharePoint. However, that formula is semantically close to Filter(..., CustomerId = Blank()), which will delegate to SharePoint. These formulas aren't equivalent because the second formula won't treat the empty string ("") as empty. However, the second formula might work for your purposes. On SharePoint, this approach will work for the equals operator ("=") but not the operator for not equals ("<>").
• SharePoint system fields are not delegable. These fields include:
• Identifier
• IsFolder
• Thumbnail
• Link
• Name
• FilenameWithExtension
• Path
• FullPath
• ModerationStatus
• ModerationComment
• ContentType
• IsCheckedOut
• VersionNumber
• TriggerWindowStartToken
• TriggerWindowEndToken

SQL Server

You can delegate the following Power Apps operations, for a given data type, to SQL Server for processing, rather than processing locally within Power Apps. You can also delegate expressions joined with And, Or, and Not to SQL Server.