how to filter gallery when multiple checkboxes ticked

[Amber_L]

Hey all,

Below is my powerapp

The green boxes are the items I wish to filter and are displayed inside a gallery which is connected to a sharepoint list.

Currently, I have the gallery filtered to check the dropdown in the top left and filter based on the selection. Here is my formula on the 'Items'

The part I am now having trouble with is then filtering the gallery based on the checkboxes.

In the sharepoint list, I have one single line of text column labelled "Tags". This contains all the tags associated with that particular item. These 'tags' are the same as the checkboxes on the left of the screen. I essentially want the gallery to filter based on if that checkbox is ticked and if that tag is on that item.

Example:

I have 'Show All' selected in the drop down and I have three checkboxes ticked.

The result would be to show All Items that have either or all or some of those three checkboxes in the "Tags" column

Is this possible and if so how?

Thanks in advance!

[StalinPonnusamy]

Hi @Amber_L 

The FIlter will be similar to this. 

Filter(
            SPList,
            Dropdown2.Selected.Value="Show All"  || Tags.Value in (Concat(Filter(
            Gallery1.AllItems, Checkbox2.Value = true ), Title & ","))
        )

My assumption is these checkboxes (s) are displayed within the Gallery

Thanks,
Stalin - Learn To Illuminate

[v-bofeng-msft]

Hi @Amber_L :

I've made a test for your reference:

1\I assume there is a table:

ClearCollect(GalleryDataSource,{Tags:"A,B"},{Tags:"A,B,D"},{Tags:"E"})

2\I assume there are 5 check boxes

You could filter the data in this way:

Filter(
    GalleryDataSource,
     If(CheckboxA.Value,CheckboxA.Text in Tags)||
     If(CheckboxB.Value,CheckboxB.Text in Tags)||
     If(CheckboxC.Value,CheckboxC.Text in Tags)||
     If(CheckboxD.Value,CheckboxD.Text in Tags)||    
     If(CheckboxE.Value,CheckboxE.Text in Tags)
)    

Best Regards,

Bof

[Amber_L]

hey! thanks for the help! I have that working now however I want to further filter it with the checkboxes. Best way is with an example:

The example above that you have done works well however by ticking checkbox B and checkbox D, it should only show results that have BOTH of those values. So if I tick checkbox B first it will show both of those results however once I select checkbox D, I want only result A,B,D as this is the only result that has both B and D in it.

Is this possible? I've tried so many ways and cant seem to get it to work.

[v-bofeng-msft · Accepted solution]

Hi @Amber_L :

Please try:

Filter(
    GalleryDataSource,
     If(CheckboxA.Value,CheckboxA.Text in Tags,true)&&
     If(CheckboxB.Value,CheckboxB.Text in Tags,true)&&
     If(CheckboxC.Value,CheckboxC.Text in Tags,true)&&
     If(CheckboxD.Value,CheckboxD.Text in Tags,true)&&    
     If(CheckboxE.Value,CheckboxE.Text in Tags,true)
)    
    

Best Regards,

Bof

[Amber_L]

Perfect!!! I had that originally and it wasnt working but I forgot to put true at the end of each if statement! Thank you so much!