Answered

Complex Calculated Fields

(0) Share

Report

Posted on by matthewvryan

Hi,

Calculated fields in model driven apps is currently quite limited to simple math. How do you support more complex calculations and expressions.

The use case would be something like this.

3 input fields, A, B, and C on the form.
1 calculated field = D on the form that should be calculated if A, B and C have values.

Expression for the calculated field is IF (A = "Bronze", D = 0, IF (A = "Silver", D = B x C, C^2))

Ideally this configuration would be Server side and universally available to both my model driven interface and my canvas apps running off the CDS entity.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (2)

Report

Hi @matthewvryan :

Could you tell me:

Do you want to configure complex caculation rules for 'D'?Something like this:

If so,I suggest you create a business rule for this entity.I'v made a test for your reference:

1\Create a business rule

2\Save and make it activate

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/cds-processes

Best Regards,

Bof

Was this reply helpful? Yes No
EDAKA 5 on at

Like (0)

Report

Bravo for this solution!!!
This gave me some hope about a challenge that I actually have!!!

What solution would you suggest for calculations where the values come from a column/field in another table/entity?

Following the example above, imagine that in the last result after the last condition was true ("C x B") the columns B and C were in another table or even come from 2 different additional tables?

Thank you in advance for your guide!

Was this reply helpful? Yes No