Skip to main content
Dynamics 365 general forum
Suggested answer

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

editSubscribe (0) ShareShare
ReportReport
Posted on by 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!

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju on at
    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.

    pastedimage1674107163747v1.png

    (1)Sub-grid:

    pastedimage1674109497006v2.png

    (2)Report:

    pastedimage1674109852960v4.png

    pastedimage1674110389109v5.png

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,483 Super User on at
    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:

     

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans