filtering gallery based on multiple dropdowns

(0) Share

Report

Posted on by Sifu

834

Hello,

I am trying to filter gallery based on multiple dropdowns... here the example on how I do with 2 dropdowns... now i have to do this with 3 and i hope that there is a better way to do this.... 😕

(gallery shows items from some list, the dropdowns should filter this list and represent the columns in that list)

//if category is selected
If(Not(IsBlank(category.Selected.Result)) And IsBlank(layout.Selected.Result),Filter('IT Hardware Web Shop - Products', Category.Value = category.Selected.Result And Availability.Value = "Available"),
//if layout is selected
If(Not(IsBlank(layout.Selected.Result)) And IsBlank(category.Selected.Result),Filter('IT Hardware Web Shop - Products', LayoutLanguage.Value = layout.Selected.Result And Availability.Value = "Available"),
//if both selected
If(Not(IsBlank(layout.Selected.Result)) And Not(IsBlank(category.Selected.Result)),Filter('IT Hardware Web Shop - Products', Category.Value = category.Selected.Result And (LayoutLanguage.Value = layout.Selected.Result Or LayoutLanguage.Value = Blank()) And Availability.Value = "Available"),
//if non selected
Filter('IT Hardware Web Shop - Products', Availability.Value = "Available"))))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Sifu

Will this work as the Items property for your gallery? I added ASR for a third dropdown and since all of the filters included "Available", I created a temporary variable as a filtered table.

With( { CSR:category.Selected.Result, LSR:layout.Selected.Result, ASR: AnotherDropdown.Selected.Result, AVProducts:Filter('IT Hardware Web Shop - Products', Availability.Value="Available" ) }, Filter( AVProducts, CSR=Blank() Or CSR, LSR=Blank() Or LSR, ASR=Blank() Or ASR ) )

Was this reply helpful? Yes No
Sifu 834 on at

Like (0)

Report
Copy link

Link copied!
cant get this working can we maybe simplify this to two dropdowns just so i understand the concept...

With( { CSR:category.Selected.Result, LSR:layout.Selected.Result ) }, Filter( AVProducts, CSR=Blank() Or CSR, LSR=Blank() Or LSR, ) )

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Sifu

Check out this blog about how to do this correctly and why you may have run into a problem.

https://matthewdevaney.com/power-apps-filter-gallery-with-multiple-dropdowns/

Was this reply helpful? Yes No
Sifu 834 on at

Like (0)

Report
Copy link

Link copied!

thanks, will do

Was this reply helpful? Yes No