How to filter Gallery based on column value using a checkbox

(0) Share

Report

Posted on by F_Quint

257

Hello,

I have a PowerApp with a SharePoint List as the data source.

What I basically would like to do is to filter the Gallery when a checkbox is selected.

My Gallery items section has :

SortByColumns(Filter([@CollectionRequests], StartsWith(Title, TextSearchBox1.Text)), "Created", Descending)

The relevant column is called 'Business Unit' in my SP list.

On my OnCheck I have:

Filter(CollectionRequests,'Business Unit'="CBRO")

But I'm not sure how to modify my Gallery formula without losing current functionality.

In advance thank you !!!

help with checkbox.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Assuming your checkbox1,
Change the filter on the Gallery to;

If(Checkbox1.Value,
SortByColumns(Filter([@CollectionRequests], StartsWith(Title, TextSearchBox1.Text)), "Created", Descending),CollectionRequests)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 thanks for the reply. That doesn't seem to work. It's not filtering by the column value I want. It's also putting my gallery from oldest to newest when Unchecked.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

I have seen you modified the question. Do you want to combine the two codes with the checkbox?

If(!Checkbox1.Value,
SortByColumns(Filter([@CollectionRequests], StartsWith(Title, TextSearchBox1.Text)), "Created", Descending),
SortColumns(
Filter(CollectionRequests,'Business Unit'="CBRO"),"Created"))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Sorry about the ninja edit, I wanted to my question more specific.

but to answer your question, yes I would like to keep the Gallery's functionalities intact when the checkbox isn't checked. and when OnCheck, filter the Gallery from newest to oldest based on the Business unit column value

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried the new code I gave.
If any issues give a screenshot
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 I tried but got the following error

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

The attached is blurred, image not clear. Please resend
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24

I pixelated the name of my collection and other identifying info.
Let me know if this is clearer.
Thanks for your help!

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Check the spelling of SortByColumns in the second line:

If(!Checkbox1.Value,
SortByColumns(Filter([@CollectionRequests], StartsWith(Title, TextSearchBox1.Text)), "Created", Descending),
SortByColumns(
Filter(CollectionRequests,'Business Unit'="CBRO"),"Created"))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 That works! Thank you so much.

Now if I wanted to combine a drop-down into the formula?
I'll open a new question, much appreciated.

Was this reply helpful? Yes No