Announcements
I am using CDS as my source to store data. I have a few numeric fields which get their value from user input. What I would like to do is take the values the user puts in, then take that value and do some calculations and then insert that value in a result field. Can you do this in model driven apps? Or can you only do something like this in Canvas apps?
Hi @Anonymous ,
I recommend you to use a Power Automate workflow to do it.
Basically, you will use the trigger "When a record is updated" (CDS connector) and calculate inside the Power Automate and after using the "Update a record" (CDS connector) action to update the total field.
Is it possible to do something like this without Power Automate?
Hi @Anonymous,
Depending on how complicated the calculation is, you can also use out-of-the-box calculated fields. Might be worth taking a look at it. Here's more info: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/define-calculated-fields
Hope this helps
Hello @EricRegnier ,
I have a calculated column with a formula that contains a POWER function. Both POWER and ^ do not seem to work. Is there a workaround you would suggest besides PowerAutomate?
Thank you
Hi @mxlgbr,
Unfortunately Power is not a valid function as you stated, the list of available functions are here: https://docs.microsoft.com/power-apps/maker/data-platform/define-calculated-fields#capabilities. The only workaround with calculated are multiplying by the number of times you need if it’s always a constant number. For example: cr755_column * cr755_column * cr755_column
The other options besides Power Automate are:
1) create a plug-in but requires C# code
2) lookout for Power FX calculated columns coming soon. More info: https://powerapps.microsoft.com/blog/power-fx-formula-columns-in-dataverse/
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
