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
Super User II
Super User II

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 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 Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,648)