Recently when I was adding the new column in Microsoft Dataverse from the PREVIEW maker portal (https://make.preview.powerapps.com/) I was amazed by looking at the new option in the Datatype available named “Formula”.
In this blog, we will focus on the introduction and related use cases where this “Formula” datatype can be useful.
Formula Column Features:
- Formula columns use the Power Fx syntax similar to Office Excel. Power Fx is the low code language that is being used across the Microsoft Platform.
- Formula column expands the ability of existing calculated and rollup columns it adds the value in expression by performing the arithmetic calculation in real-time.
- The formula expression can be made available with Today () and Now () functions for the first time.
- Many supported functions are available for inbuilt arithmetic operations.
- As you enter the formula, Intellisense helps you with recommendations for formula, syntax, and errors.
- Making it easy to see and edit the…
Source link