cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Model driven Apps

Hello

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?

 

1 REPLY 1
GarethPrisk
Resident Rockstar
Resident Rockstar

There are a few options here.

 

You can use a Business Rule.

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-business-r...

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

NOTE:

  • 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.

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/define-calculated-fields

NOTE:

  • 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.

NOTE:

  • 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

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,412)