Enable Power Fx formula columns inside Dataverse tables


This content is archived and is not being updated. For the latest documentation, go to What is Microsoft Dataverse?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.


Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Jul 15, 2022 To be announced

Business value

As part of the low code initiative, we'll now enable formula columns inside Microsoft Dataverse to improve maker adoption. Formula columns are a data type in Dataverse that are built on Power Fx.

Feature details

You can add a formula column to a table in real time. The Dataverse table stores the logic and gives you the values during fetch operations. Formula columns use the Power Fx syntax that's similar to Excel. As you enter the formula, Intellisense helps you with recommendations for formula, syntax, and errors.

For more information, go to the Data types and function types that are supported.

See also

Work with formula columns (docs)