Supported functions
Functions in Microsoft Dataverse can add business logic to your apps using the Power Fx expression language and you can quickly build rich workflows without any code. Functions support many of the Power Fx operators, variables, and formulas.
The following table lists the Power Fx formulas that work with functions in Dataverse but have limitations or don’t work but have an alternative for use with functions.
| Power Fx formula or operation | Supported in functions? | Limitation or work around |
|---|---|---|
Collect |
Yes | Requires the variable to exist and the variable type to match what you’re trying to set it to. |
Defaults |
No | Use Collect instead of Patch. For example, instead of Patch(account, Defaults(account), {"Account Name": "Example Account"}), use Collect(account, {"Account Name": "Example Account"}). |
| Add tables in the UI | Yes | For example, in order for the expression to Collect(Accounts, {... }), the accounts table needs to be added in the UI. This helps with intellisense. |
| Accessing fields in formula | Yes | No implicit scope for accessing fields. Instead of saying Field2, say NewRecord.Field2. This applies to Set as well: Set(NewRecord.Field1, OldRecord.Field2*10). |
With() |
Yes | Functions don't support contexts, named formulas, or variables. With() can be used to create aliases and factor the expressions. |
| Access Dataverse tables | Yes | Functions can read and write to Dataverse tables. This includes Collect(), Patch(), Filter(), and LookUp(). Delegation operations are supported, and a warning is issued if an expression can't be delegated. These operations run directly against the function’s IOrganizationService (not the current table) and directly operate on the database. Functions run in the transaction context. |
Power Fx functions not supported
The following Power Fx function aren't currently supported with functions in Dataverse.
ClearCollect
Update
UpdateIf
Concurrent
SetFocus
IsType
Download
RemoveIf
GroupBy
SetProperty
Search
UTCNow
UTCToday
Validate
As
Calendar
Choices
Clock
Select
Notify
HashTags
ISOWeekNum
SaveData, LoadData, and ClearData
Form-related formulas (EditForm, NewForm, SubmitForm, ResetForm, and ViewForm)
Device sensor formulas (Acceleration, App, Compass, Connection, and Location)
For more information about Power Fx, go to these articles: