cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (15,609)