Image Source: Shutterstock.com

Jun 9, 2023 7:00 PM

External Blog Post

Microsoft Dataverse for Teams introduces a feature that allows the addition of a calculated column to your table using the data type, "Formula". This is facilitated by Power Fx, a language specifically designed for writing formulas and expressions within Dataverse for Teams.

Supported data types for this feature include Text, Decimal Number, Yes/No (Boolean), and Date. These data can be manipulated using operators such as +, -, *, /, %, ^, in, exactin, &.

To create a new Formula column, you need to edit your Dataverse table and select the "Formula" Column. For instance, to calculate the age of employees, you can use the formula DateDiff('BirthYear ', UTCNow(),TimeUnit.Years).

However, some users may encounter errors when using the Data column, such as "Time zone conversion" issues. To solve this, the "Time Zone Adjustment" property of your Data column can be set to "Time Zone Independent".

There are approximately 54 functions available to use within your formulas, like DateDiff, DateAdd, If, UTCNow, Abs, etc.

However, it's crucial to know that the Text and Value functions only work with whole numbers, and since formula columns are evaluated without locale knowledge, they can't properly interpret or generate the decimal separator.

For further information or queries, users are encouraged to check out the official documentation or reach out for assistance.

- Understanding the Formula Columns in Dataverse Power ...
- Formula columns empower citizen developers to express business logic on top of existing columns and reference column from other tables, directly in Dataverse.
- How to work with dataverse formula column
- Dec 26, 2022 — In a Microsoft Dataverse table, formula columns are columns that display a calculated value. Formulas are created with the programming language ...
- Adding the Power Fx Formula column (PREVIEW) into ...
- Aug 24, 2022 — Adding the Power Fx Formula column (PREVIEW) into Dataverse · 1. Select the table where you want to add the column. · 2. Click on “+ New Column” ...
- Power FX Formula Columns in Dataverse (preview)
- Jul 26, 2022 — Formula columns provide the ability to add business logic and calculations (formulas) within Dataverse so that the results of these columns will ...
- Power Fx Formula Columns in Dataverse - Joe Gill
- Jul 22, 2022 — Power Fx Formula Columns work in the same way as calculated fields and they create computed fields on the table in the SQL Azure database behind ...

Microsoft Dataverse, Power Fx, Calculated Column, DateDiff, UTCNow, TimeUnit, Years, Create Column