How to filter gallery selections on either button or Combobox

(0) Share

Report

Posted on by Usernametwice

503

Hi all

I have a gallery that displays a variety of fruit depending on which button is selected prior to opening up with gallery.

I now want to add a combo box in the mix so if the user decides to select the variety of fruit using the combo box then it will still bring up the gallery.

So I am trying to filter the datasource/gallery using the variable set of the button selection and the combo box selection if the user decides to use the combo box.

Here is the formula im trying to use -

Filter(Table15, Variety=VarietySelection && Variety=ComboBox2_10.Selected.Description)

If I just use this-

Filter(Table15, Variety=ComboBox2_10.Selected.Description)

It works but only filters based off of the combo box selection.

Or this works filtering with variable created with button selection-

Filter(Table15, Variety=VarietySelection)

But i need it to filter both, just in case the user selects one or the other.

Thanks everyone for any help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

My advice is to use or button or combobox

To filter by combobox:

If( IsBlank(ComboBox2_10); Table15; Filter(Table15; Variety = ComboBox2_10.Selected.Description)

If you really want that, you can try to insert an AND in that filter... But i dont think it is a good idea...

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Hi @Usernametwice23 ，

I did a test for you.

1\ This is my list

2\ Add a combo box control 'ComboBox1' and set its Items property to:

Distinct(LIST153,Fruit_type)

Set its DisplayFields property to:

["Result"]

3\ Add a reset button and set its onselect property to:

ClearCollect(Col,{Type:"1"});Clear(Col);Reset(ComboBox1)

4\ Add 3 button controls and set their onselect property to:

ClearCollect(Col,{Type:"1"})
ClearCollect(Col,{Type:"2"})
ClearCollect(Col,{Type:"3"})

5\ Add a gallery control and set its Items property to:

Filter(ForAll(LIST153 As A,If(A.Fruit_type in Col.Type||A.Fruit_type in ComboBox1.SelectedItems,A,Blank())),!IsBlank(Fruit_name))

6\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report

Hi @v-xiaochen-msft

Thank you greatly for the help.

This seems to be working for my combo box, but the problem is that my buttons are in a gallery and not separate as seen in your post. Also my buttons are also based off of another gallery selection so I cant change them to be separated like yours.

Is there a way around this? Or you think that the buttons need to be not in a gallery for it to work?

Was this reply helpful? Yes No