Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Pallavi Phade 98
Tom_Gioielli 60 Super User 2025 Season 2
Gerardo RenterÃa Ga... 43 Most Valuable Professional
