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?
There are a few options here.
You can use a Business Rule.
This has some basic mathematical capabilities, and can sum fields together.
NOTE:
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:
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:
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
277 | |
254 | |
87 | |
38 | |
34 |
User | Count |
---|---|
342 | |
246 | |
128 | |
73 | |
44 |