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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 182 members 6,403 guests
Please welcome our newest community members: