Model-driven powerapp field that is a sum of all previous records of another field.

(0) Share

Report

Posted on by EBS Hydros

I have field named AMA that contains decimal values. I would to have another field AMAcum that aggregates all previous records of AMA.

See below table.

AMA |AMAcum
4	4
3	7
5	12
8	20
3	23
9	31
2	33

Regards

I have the same question (0)

All responses (4)

Answers (0)

LeoAlt 16,331 Moderator on at

Like (1)

Report
Hi partner,

You could do this by js code.

Please add the following js code into your form properties and add the function to AMA field onchange event.

function getAMAcum(executionContext){ var AMA=executionContext.getFormContext().getAttribute("new_ama"); var AMAvalue=AMA.getValue(); var AMAcum=executionContext.getFormContext().getAttribute("new_amacum"); var AMAcumValue=AMAcum.getValue(); var finalnum=AMAvalue+AMAcumValue; executionContext.getFormContext().getAttribute("new_amacum").setValue(finalnum); }

Hope it helps.

Best Regards,

Leo

Was this reply helpful? Yes No
EBS Hydros 5 on at

Like (0)

Report

Hi Leo,

Thanks a lot for your help. I have created the OnChange Event handler as you guided.

However, I need some guidance on where and how to call the function.

Regards

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

Hi

Once you created your web resource and uploaded and published to crm.

As LeoAlt suggested, you have to add the script to the form, bind it to OnChange of Control ACM and then select the js file name and the onchange event function name.

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi Bernard,
Since you have created the OnChange event and published it, as Microsoft mentioned below, you just need to change the field value to trigger your js function.

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/clientapi/reference/events/attribute-onchange

Best Regards,

Leo

Was this reply helpful? Yes No