Unanswered

Filter gallery item based on multiple combo boxes

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Everyone,

I want to filter my gallery item based on multiple combo boxes.
This is my screen, and under which I have two combo boxes (CustomerName and Month) and a gallery

This is in the 'OnVisible' property of the screen

This is in the Items of the CustomerName combobox

and finally this is in the 'Items' of the Gallery

So basically, I have applied the filters based on Month Combo box
But the requirement is to have filters by both combo boxes

How can I achieve that?
Please help and provide me the syntax which I can paste in the 'Items' of the Gallery so that I can filter it using both the combo boxes.

Let me know if you need more information.

Thank You!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT @RandyHayes @WarrenBelz @Pstork1 Please help on above request!
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous you can add one more filter condition like,
&& theOtherColumn.Value=theOtherCombobox.Selected.Value
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi ,
If you want to Filter on Two Items you need to setup your Filter function accordingly
For example the code below would filter based on both statement 1 and statement 2 being true.
Filter( YourCollection, (Statement1 && Statment2) )
If you want to filter on either Statement1 or Statement2 being true you would do something like this
Filter( YourCollection, (Statement1 || Statment2) )

You mention that you want to filter with multiple combo boxes. In this case you probably want to setup you combo boxes to cascade (where the value selected in ComboBox1 changes the Values in ComboBox2 - such as you want when one combo box selects the Category and the other selects the SubCategory). A description of how to do that can be here here