cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filtering many to many relationship Dynamics 365 CRM

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)

 

Unbenannt.PNG

 

Best regards,

ginas

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
PowerApps Staff EvanChakiMSFT
PowerApps Staff

Re: Filtering many to many relationship Dynamics 365 CRM

3 REPLIES 3
Administrator
Administrator

Re: Filtering many to many relationship Dynamics 365 CRM

adding in @EvanChakiMSFT to assist

 

@TopShelf-MSFT

Super User
Super User

Re: Filtering many to many relationship Dynamics 365 CRM

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. 

Highlighted
PowerApps Staff EvanChakiMSFT
PowerApps Staff

Re: Filtering many to many relationship Dynamics 365 CRM

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 289 members 1,885 guests
Please welcome our newest community members: