Answered

Filtering many to many relationship Dynamics 365 CRM

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey community,

I have a problem with a many to many relationship in Dynamic 365 CRM between entity A and B. I want to show all records of entity A, that have a relationship to a particular record B. Currently I have chosen the filtering method to solve this problem but I'm not sure, if this is the right way. The problem is, I can't select the reletionship in the filter.

Relationship name (n:n): a_b_relationship

My Filter in the Datatable: Filter('A';a_b_relationship)

Best regards,

ginas

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

adding in @EvanChakiMSFT to assist

@Anonymous
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous,

I have no experience with Dynamics but to model many to many relationships you need a third table called a junction table with the primary keys from both of the other tables. You then can model the relationship between each table and the junction table as one to many. Please see my posts in the PowerApps community blog regarding relational databases in PowerApps, particularly the last one.
Verified answer

EvanChakiMSFT Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

You can check out this new blog post on how to do many-to-many with CDS - https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/