Microsoft 365

Apr 18, 2023 2:30 PM

Matt showcases a new preview feature inside Dataverse tables. There is now a new datatype called Formula. This data type allows you to leverage the PowerFX language for populating the column. From simple math calculations to conditional logic.

In this demonstration, he will show how to do a simple math calculation and also set the Boolean value of a column using an If statement that references columns directly on the table. He later showcases how a PowerAutomate could use one of the formula columns to execute a flow.

New Power FX Dataverse Formula Columns are a set of features that allow you to create calculations and formulas in your Dataverse applications. This feature enables you to create calculations and formulas based on the data in your Dataverse applications and use them to generate new insights and understandings. You can use these formulas to calculate values and compare data across multiple records. This feature also allows you to filter, group, and sort data based on the results of the formulas. New Power FX Dataverse Formula Columns can also be used to create custom visualizations, such as charts and graphs, based on the data in your applications.

Add a formula column · Operators

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” ...

Formula columns are based on Power Fx commands which are already present in the Canvas App editor. We are using the same Excel-like language you use for Power ...

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 ...