Announcements
No record found.
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,
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
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.
Thank you very much :-)
Hi, Svetlanasyo remember close this thread if the response was usefull : )
Best Regards.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Muhammad Shahzad Sh... 69 Most Valuable Professional
ManoVerse 62 Super User 2026 Season 1
11manish 43
