how to filter gallery when multiple checkboxes ticked

(1) Share

Report

Posted on by Amber_L

181

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Amber_L 181 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Amber_L 181 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No