cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenzPA
Frequent Visitor

Filter gallery by related entity records (Many to many relationship)

Hi !

I have 2 entities with many to many relationship based on CDS :

- Entity 1: "Drinks"

- Entity 2 : Flavours  

A drink have multiple flavors (ex : Apple, Lemon, Orange) also, a flavour can be in multiple drinks.

when I navigate to my screen, I passed a context variable "Apple" and on my screen I have a gallery of drinks, I would like to filter this gallery to show only drinks that contains "Apple" flavour (without delegation issue because I have more than 2K records).

Is there a way to do that within filtering ? Or it is better to create a collection filtered on the app start ?

 

In advance, Thank you so much for your support !

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @BenzPA ,

 

Try to put the following formulas to Items property of drinks gallery:

 

If(IsBlank(Var_Apple),Drinks,LookUp(Flavours,'Field Name'= Var_Apple).Drinks)

 

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @BenzPA ,

 

Try to put the following formulas to Items property of drinks gallery:

 

If(IsBlank(Var_Apple),Drinks,LookUp(Flavours,'Field Name'= Var_Apple).Drinks)

 

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

View solution in original post

Hi @v-siky-msft 

Thank you four your prompt reply, It works on PowerApps designer when I Play the application but when I publish the application the gallery is empty ..

 

 

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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,381)