Answered

Filter a gallery with multiple checkboxes

(0) Share

Report

Posted on by water-guy-5

101

Hello,

I have a gallery and one of the columns is "Category". In this case, I have 5: A, B, C, D, E.

I have a filter pane on the left side of my gallery with a checkobx for each, labeled filtA, filtB, etc.

I need to enter a function into the Items property of my gallery that filters my gallery depending on the values selected. I tried to do this the loooooooooong way, but it is driving me nuts, where I would have to write a function like

If(filtA.Value = true, Filter(Table1, Category = "A"))

I would have to do this ^ for EVERY combination of 1, 2, 3, or 4 boxes being selected and not selected.

There has to be a better way right?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@water-guy-5

Set the OnCheck property of each checkbox Collect(coll, "A:), Collect(Coll, "B"), etc until all the boxes are assigned.

Set the UnCheck property of each checkbox Remove(coll, "A"), Remove(Coll, "B"), etc

Set the Defaults to false

Set the Items property of your gallery to: Filter(Table1, Category in coll.Value)

If Category is a Choice type column: Filter(Table1, Category.Value in coll.Value)

Was this reply helpful? Yes No
water-guy-5 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh my goodness thank you so much

Was this reply helpful? Yes No
water-guy-5 101 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp how would this look with multiple filters?

Lets say I also have a Status column. Can I create coll2 and apply the same logic? How would this look in my Items function?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@water-guy-5

Status is single or multiselect? Choice or single line of text?

Was this reply helpful? Yes No