Filter Gallery from CDS many to many relationship with multiple conditions

[BenzPA]

Hi Community,

I'm new on PA and I'll appreciate your help to figure out how can I Filter my gallery with multiple conditions based on related entity

to be more conveniently I attached a draw where I explained my use case :

[v-xida-msft]

Hi @BenzPA ,

Based on the needs that you mentioned, I think Filter function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Gallery to following:

Filter(
       LookUp(Flavors, Name = "Lemon").Drinks,
       Volume = "500 ml",
       Type = [@Type].Type5
)

Note: The Type wrapped with [@] represents the Option Set Name within your CDS Entity.

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

[BenzPA · Accepted solution]

Hello Thanks for your response,

I had a delegation issue with this solution, so to avoid this delegation issue, I created 4 filtred views on CDS based on flavours (As I have only 4 flavours) and I filtered this views on PA, so It works fine and without delegation issue..

Thanks for your help !

[Jonathan92]

I Don't understand how "LookUp(Flavors, Name = "Lemon").Drinks" could work. and especially with ".Drinks".

Could you explain ?

[jacktransform]

@Jonathan92  did you ever figure out how that works? Running into that problem now. When I do "LookUp(Flavors, Name = "Lemon").Drinks" I get only one record returned instead of multiple.

[Jonathan92]

@jacktransform unfortunately, there are multiple issues that I could not solve on Power Apps, and this one included. This is not anymore a problem for me as I am now on working as a fullstack dev JS. 

[jacktransform]

@BenzPA @v-xida-msft 

Just like Jonathan, I too am running into problems with the LookUp function. When I do "LookUp(Flavors, Name = "Lemon").Drinks" I get only one record returned instead of multiple. How are you able to return all the records in "Drinks" that have "Lemon" as part of its flavor?

Thanks!