Enable Power Fx formula columns inside Dataverse tables
Important
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.
Important
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)