cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dos757
Resolver I
Resolver I

filter with N-N relationship

Hi all, 

 

I have a N-N relationship between "Gamme" entity and "Catalogue" entity as below : 

 

"Gamme" entity

dos757_0-1627640230475.png

"Catalogue" entity

dos757_1-1627640319903.png

 

Now i have a Power Apps canvas that must filter the "Gammes" related to the choosen catalogue like that 

dos757_2-1627640564376.png

 

How can i do this ? 

 

 

Many thanks for your help. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
dos757
Resolver I
Resolver I

Hi guys, 

 

I've finally found a way. 
To filter the gammes related to a selected Catalogue. I've just needed to activate N-N relationship options on the Apps parameters. 

 

Then i was able to add this code in the gallery item "CatDropDown.Selected.Gammes(if_if_catalogue_if_gamme)"

I can now access to N-N relationship tables 🙂 

View solution in original post

5 REPLIES 5
dos757
Resolver I
Resolver I

I really need help for this case. 

There's no way to filter on Many to Many relationship. 

 

I have to create a table that link both tables ? 

 

Many thanks for your help.

StalinPonnusamy
Community Champion
Community Champion

Hi @dos757

 

Yes, you need to create a separate table that intersects both tables which is custom N:N, and you have more control over this approach.

 

 

Ramole
Memorable Member
Memorable Member

Hi @dos757 

This post will explain in to depth and how to do it 

https://powerapps.microsoft.com/en-us/blog/relate-records-in-many-to-many-relationships/

 

Thank you
If this post helps, then please consider Accept it as the solution to help the others and consider giving it a "Thumbs Up."

Hi @Ramole ,

 

My need is not exactly as explained in the link you gave me. 

I don't want to patch or to add values. I just want to filter the gammes of a selected Catalogue. 

 

Something like you can do via N-1 relationship : 

Filter(Gammes; Catalogue.name = dropdown.selected.name)

dos757
Resolver I
Resolver I

Hi guys, 

 

I've finally found a way. 
To filter the gammes related to a selected Catalogue. I've just needed to activate N-N relationship options on the Apps parameters. 

 

Then i was able to add this code in the gallery item "CatDropDown.Selected.Gammes(if_if_catalogue_if_gamme)"

I can now access to N-N relationship tables 🙂 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,136)