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!

All responses (2)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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

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:
Suggested answer

Pradeep Rai 5,482 Super User 2025 Season 1 on at

Like (0)

Report

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

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: