You’re offline. This is a read only version of the page.
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 @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/
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 @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
Is it possible to do something like this without Power Automate?
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.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
