cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How to calculate values in model driven app

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: How to calculate values in model driven app

Hi @Brudavi,

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

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: How to calculate values in model driven app

Hi @Brudavi ,

 

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.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+1.000 students): https://www.udemy.com/pva-beginners
Highlighted
New Member

Re: How to calculate values in model driven app

Is it possible to do something like this without Power Automate?

Highlighted
Super User II
Super User II

Re: How to calculate values in model driven app

Hi @Brudavi,

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (4,733)