Unanswered

Filter gallery by multiple entity filters

(0) Share

Report

Posted on by bennstef

Hey! Powerapps noob here. I have been trying to work out how to filter a gallery by multiple entity filters.

The first entity in my CDS which is SKUs that contains all my items in the gallery to be filtered on.

Here is the code I am using to filter the gallery items based on a SKU drop down which works perfect:

Filter(SKUs, Colour = 'Colour dropdown'.Selected.Result)

The second entity in my CDS is "Brands" which has a field called "Brands family" which has a one-to-many relationship with the SKUs entity.

How can I adjust my gallery code to filter out the SKUs that match/don't match the dropdown for Brands Family?

Filter(SKUs, Colour = 'Colour dropdown'.Selected.Result &&
 // filter SKUs by Brands, 'Brands Family' = 'Brands family dropdown'.Selected.Result
)

Thank you for any help it is much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

eka24 20,923 on at

Like (1)

Report

Use:
Filter(SKUs, 'Brands family' in Brands.'Brands family' &&
Colour = 'Colour dropdown'.Selected.Result)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bennstef 36 on at

Like (0)

Report
Thank you for your reply. The Brands Family value can be changed by a drop down, so should it be something like this?:

'Brands family' in Brands.'Brands family' = 'Brands family dropdown'.Selected.Result

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

Do you have two dropdowns?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bennstef 36 on at

Like (0)

Report

Yes thats the case

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

Based on the fact, create a collection;
ClearCollect (MySKU,
Filter(SKUs, 'Brands family' in Brands.'Brands family' ))

Then filter using the Collection;
Filter (MySKU, 'Brand Family'='Brand Family Dropdown'.Selected.Result&&
Colour = 'Colour dropdown'.Selected.Result)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bennstef 36 on at

Like (0)

Report
Thanks dude, I have tried to implement this but it does not seem to be working.

ClearCollect (MySKU, Filter(SKUs, 'Brands family' in Brands.'Brands family' ))

Won't the above code filter out the brands family anyhow? I don't understand how this is meant to allow me to filter the gallery using the fields from both the SKUs & Brands entitys drop downs.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Syntax-for-joining-tables/td-p/61387 << Isn't something like this more appropriate?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

I think you did not understand the code. I gave two codes, the first to filter in a collection and the Second to filter on the Gallery.
Did yo try and what was the result
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bennstef 36 on at

Like (0)

Report

Both the drop downs and the gallery (images).

2.PNG

1.PNG

3.PNG

Was this reply helpful? Yes No
bennstef 36 on at

Like (0)

Report

The clearcollect code and entitys.

Brands was changed to demand families.

Can you please check the code to see where I have gone wrong?

Thanks so much!

5.PNG

4.PNG

6.PNG

Was this reply helpful? Yes No
bennstef 36 on at

Like (0)

Report

Was this reply helpful? Yes No