Filter gallery with checkbox

(0) Share

Report

Posted on by Edward00

122

I want to filter the gallery when checkbox.value=true

I have functions like above and I don't know where to add the formula to filter the gallery with checkbox properly and how to filter galley. I hope people can help me solve this problem.Thanks for reading

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I'm assuming your filtering by IsDeleted = true when the checkbox is selected, and not filtering at all when the checkbox isn't selected.

If your isDeleted is a true/false column, you could try replacing your "&& isDeleted=false" at the end of either if statement with something like:
&& If(CheckBox.Value, isDeleted, true)

This could be relatively easily modified to account for other possibilities, such as all records whether they are deleted or not, or only getting not deleted records when it's not selected.

Hope this helps!

Was this reply helpful? Yes No
Edward00 122 on at

Like
a
(0)

Report
Copy link

Link copied!

It is delegation warning

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Interesting... the delegation warning shouldn't be an issue unless you have over 500 items in your datasource, although that can be bumped up to 2000. Do you think you'll have that many records?

Was this reply helpful? Yes No
Edward00 122 on at

Like
a
(0)

Report
Copy link

Link copied!

It's not. There are no more than 500 items in the Data Source. Only 5 items

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In that case you should be fine, as long as the function works as intended with that data

Was this reply helpful? Yes No
Edward00 122 on at

Like
a
(0)

Report
Copy link

Link copied!

So there's no other way to fix the delegation warning right, Sir

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

It's possible there is, but no easy way is coming to me off the top of my head, and since it shouldn't be an issue for functionality, and the user shouldn't ever see it, I don't really see a reason to.

If you'd like more information on why this is happening, when and how to avoid it, you can see these resources, as well as others elsewhere:
delegation overview
delegable functions and operations for sharepoint

Was this reply helpful? Yes No
Edward00 122 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you

Was this reply helpful? Yes No