Loading...

Dataverse Formula columns (Power Fx)

Dataverse Formula columns (Power Fx)
Dataverse Formula columns (Power Fx) julien.biedermann Thu, 02/29/2024 - 15:08
Body

What is Formula columns ?

The official announcement of the public preview of formula columns in Dataverse was made on September 15, 2021 and was released in general availability in late 2023.

Formula columns are columns that display a calculated value in a Microsoft Dataverse table. Formulas use Power Fx, a powerful but human-friendly programming language. Build a formula in a Dataverse formula column the same way you would build a formula in Microsoft Excel. As you type, Intellisense suggests functions and syntax, and even helps you fix errors.

Formula columns will eventually replace the classic calculated columns feature. You can find an interesting benchmark between calculated field and formula column here.

Create a formula column

  1. Sign in to Power Apps at https://make.powerapps.com
  2. Create a new column with Data type = fx Formula
  3. Enter your formula in the formula box and save
    1. The formula that you enter determines the column type. You can't change a column type after the column is created. That means you can change the formula after you've created the column only if it doesn't change the column type.

Create formula column  Formula column in form

Coming features

New capabilities

Some enhancements will be done to address calculated columns capabilities that aren't currently supported inside the formula columns.

Here are some of the known gaps that formula columns don't support today:

  • Creation of currency columns.
  • Creation of whole numbers.
  • Support for choice columns.
  • Ability to change labels for choice columns (other than Yes/No).
  • Number of formula columns at the table level.
  • Support for floating fields.

Get formula suggestions (preview)

Formula suggestions accepts your natural language input to interpret and suggest a Power Fx formula using GPT-based AI model.

To enabled this feature you must enable the AI suggestions for formula columns environment setting.

AI suggestions for formula columns

Image
/sites/default/files/2024-03/article.png

Published on:

Learn more
Featured Articles | Dynamics Chronicles
Featured Articles | Dynamics Chronicles

Welcome to our blog, the content is entirely dedicated to Microsoft Dynamics 365, CRM, Power Platform, Common Data Service (CDS) but also Azure. Follow us !

Share post:

Related posts

Power Platform & M365 Dev Community Call – July 3rd, 2025 – Screenshot Summary

Call Highlights   SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...

3 days ago

Power Platform admin center – The agent inventory page is now available for Public Preview

We are announcing that the agent inventory page for the Power Platform admin center is now available for Public Preview. This page allows admi...

3 days ago

Microsoft 365 & Power Platform Call (Microsoft Speakers) – Community Takeover – July 1st, 2025 – Screenshot Summary

Call Highlights   SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...

5 days ago

Power Platform admin center – Manage agent security with enhanced admin controls

We are announcing the ability to govern Copilot agent development in your environments and enforce governance policies for Copilot agents. Thi...

5 days ago

Power Platform – Information regarding the ability to re-enable customer-managed key locked environments

We are announcing the ability to manually re-enable customer-managed keys locked environments will reach public preview starting on June 30, 2...

10 days ago

How to Use AI Builder in Power Platform to Automate Complex Business Tasks?

Is your business, even today, spending unnecessary time and resources on repetitive, manual tasks — processing invoices, updating records, sor...

12 days ago

Microsoft 365 & Power Platform Call (Microsoft Speakers) – June 24th, 2025 – Screenshot Summary

Call Highlights   SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...

12 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy