Microsoft Dynamics 365 | Integration, Dataverse...

Is there a way to get the related field of a M:N relationship to display on the parent record?

(0) Share

Report

Posted on by ams9

Hi, I am still in the learning phases of Dynamics 365.

I have a many to many relationship between a reports form and classrooms. I know with M:N relationships, you cannot pull that information forward onto the parent record view.

Is there a way to get the related field of a M:N relationship to display on the parent record? I have tried the multi select lookup option, but does not do what I need it to do.

Any guidance is much appreciated.

Thank you!

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report

Hi,

You can use below PCF Control to show data in dropdown format for N:N relationship:

https://pcf.gallery/n-to-n-multiselect/

Also, when we create the N:N relationship then in CRM we can add Subgrid on both entities. For e.g. A and B have N:N relationship then on A we can add subgrid of B and on B we can add Subgrid of A.

for more info:

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi ams9,

I have tried the multi select lookup option, but does not do what I need it to do.

What do you need?

In the form, you can show related records in the sub-grid.

If you want to show parent and child records in the same view, maybe you need achieve it through creating Reports.

https://learn.microsoft.com/en-us/power-apps/user/create-report-with-wizard

For example, Account and custom are many to many relationship.

(1)Sub-grid:

(2)Report:

Was this reply helpful? Yes No