Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Model driven Apps


I recently started using CDS and Model-Driven apps.

So I have four columns A, B, C, D 

Column A value = 10

Column B value = 5 

Column C value = A + B = 15 

Colum D value = 5% of Column C


Please how do I evaluate Column C and Column D on a Dataverse Table?


Super User II
Super User II

There are a few options here.


You can use a Business Rule.

This has some basic mathematical capabilities, and can sum fields together.


  • This typically runs on the form itself, but you can/should set it to run at Entity scope (which will let it run on all forms, and on the server for updates/imports)
  • You may need multiple rules, and need to plan correctly to ensure that the rules execute in the correct order


You can define column C and D as calculated fields, to do this automatically.


  • There is a limit of the number of calculated fields you can have
  • Calculated fields are read-only, and derived when the field is read (data is not actually stored)
  • Cannot trigger workflows/Flows/etc.


You can use Power Automate to update those fields, with the calculations you discussed. This would mean that you are using regular (non-calculated) fields/columns, which a Flow would set.


  • Depending on the volume of data, and frequency of changes, then Flow runs may be a problem
  • This is asynchronous, meaning you won't see the fields being calculated and would need to refresh the record after the Flow completed

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


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 the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (10,414)