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)
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.