web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Is there a way to get ...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested Answer

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

(0) Share

Report

Report

Posted on by ams9

25

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

#2

André Arnaud de Cal... 71 Super User 2026 Season 1

#3

ManoVerse 54 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans