Customer experience | Sales, Customer Insights,...

Mapping many-to-many relationship within CRM

(0) Share

Report

Posted on by CalebG

Hi! I'm currently working on adding new entities to our CRM environment, one being customer contracts and the other being manufacturers. I set up a many-to-many relationship between the two, and my end goal is a contracts form where our employees can select the manufacturers on that specific contract. However, I can't figure out how to map within CRM. Does anyone have any experience with this? Thanks!

All responses (4)

Answers (0)

CalebG 54 on at

Like (0)

Report

Mapping many-to-many relationship within CRM

Aren't subgrids just views though? I don't believe I can allow the end user to select specific records to relate back to the main form.
Leah Ju Microsoft Employee on at

Like (0)

Report

Mapping many-to-many relationship within CRM

Hi Partner,

A subgrid exists within a main form and let app users view data within a Dataverse table, typically related to the record currently being reviewed.

https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/sub-grid-properties-legacy
CalebG 54 on at

Like (0)

Report

Mapping many-to-many relationship within CRM

Hi Leah,

Sorry, mapping may have not been the right word. I want contracts to be a form in Dynamics where users can add the related manufacturers to a field.
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Mapping many-to-many relationship within CRM

Hi Partner,

Mapping? many to many relationship?

But mapping feature is only support 1:N(one to many) relationship:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/map-entity-fields