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!
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:
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:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (