How to Add & Subtract Date Values With Formula Column in Power Apps – 365 Community Online

In one of our previous blog, we explored how to add and subtract dates using Date Time functions in Power Automate. This blog will demonstrate how to achieve the same functionality using the Formula Column in Power Apps.

With this approach, there is no need to create a Power Automate flow to handle date calculations. Instead, you can easily implement this requirement using the Formula Column in the Dataverse.

What is the Formula Column?

Let’s get into basics-

A Formula Column in Dataverse allows you to perform real-time calculations and data transformations using Power Fx formulas. It eliminates the need for Power Automate flows by enabling dynamic data computation directly within the Dataverse table.

Thus, when a new Customer (Account) is added to the CRM the next time and the user wants the next follow-up date calculated for the Account, it can be done without designing any Power Automate flow, simply using the Formula Column in the Dataverse.

If you’re interested in exploring…

Source link

Source link

Leave a Reply

Your email address will not be published. Required fields are marked *