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
More About This Author

-
Inogic is one of the leading Microsoft Dynamics 365 ISV since 10+ years. Its flagship product Maplytics™ is a market leading certified (CfMD) geo-analytical mapping app. Maplytics empowers Dynamics CRM users across industries with the power of geographical data visualization, route optimization and along the route search with turn-by-turn directions, appointment planner, locational search by radius and shapes with drill-down filters and color-coded pushpins, heat maps, shape layers & territory management.
Inogic is renowned for its high quality and low-cost offshore development services and productivity apps like InoLink: QuickBooks + Dynamics CRM, User Adoption Monitor, Attach2Dynamics, Alerts4Dynamics Click2Export, Click2Clone, Kanban Board, SharePoint Security Sync, Lead Automation & Distribution, Map My Relationships, Auto Tax Calculator, Subscription and Recurring Billing and Marketing4Dynamics.
Array
Dyn365CE2023.03.21Microsoft Release 2023 Wave 1: Form creation and management in Real-Time Marketing – Part 2
Dyn365CE2023.03.02Get Entity Colors in PowerApps Component Framework
Dyn365CE2023.03.01Enhanced UI for improved New User Experience while using Power Apps
Dyn365CE2023.02.27Schedule and Post Content on Social Media using Dynamics 365 Marketing