10
Hi.
I have two entities, which relate by N:N relationship. Construction entity and Material entity. Material entity has field materialValue, and Construction entity has field constructionValue which is result of sum all related materialValue. I can not use rollup field for N:N relationship. May be anybody can help me and explain how I can do this? Please forgive me if I wrote too chaotically, but this is my first experience.
Hi, Svetlanasyo remember close this thread if the response was usefull : )
Best Regards.
Thank you very much :-)
This solution require a Workflow Activity, using a fetch with the agreggate sum.
Check this links, if not are familiarize with this actions.
Workflow Example https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/workflow/sample-create-custom-workflow-activity
About the Fetch https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-fetchxml-aggregation
Programming a workflow activity , you can get sum the materialValue after with a Update Record Step on a normal workflow to set the value on constructionValue.
Hi Svetlanasyo,
It's a little complicated since rollup field doesn't support N:N relationship. So you need to create a manual many-to-many relationship.
Following article describes one example. When you create two 1:N relationships from the same entity in this manner, this can be described as a manual N:N relationship.
And you could use the Intermediate transitional entity rollup fields to sum the materialValue field.
community.dynamics.com/.../microsoft-dynamics-365-manual-n-n-relationship
Hope above would help.
Regards
Johnny
#1
Daivat Vartak (v-9d...
225
Super User 2025 Season 1
#2
Muhammad Shahzad Sh...
91
#3
Vahid Ghafarpour
78
Super User 2025 Season 1
Share
Report
All responses (
Answers (
