web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps Multiple Filters in Ga...

Power Apps

Unanswered

Multiple Filters in Gallery

(0) Share

Report

Report

Posted on by JSeymour

I have a Gallery with a bunch of data from a SharePoint list.

I also have a Search box and a Toggle to filter the information in that list.

I have a command for the search box

Filter('List Name',StartsWith(Title,'Search Box'.Text))

and a command for the toggle

If(Toggle.Value = true, Filter('List Name',Status.Value = "Pending"))

They work fine on their own, but I can't figure out how to have them work together? Any help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

Re: Multiple Filters in Gallery

@JSeymour

With({_items: If(Toggle1.Value, Filter('List Name',Status.Value = "Pending"))},

Filter(_items , StartsWith(Title,'Search Box'.Text))

)

Was this reply helpful? Yes No
JSeymour on at

Like (0)

Report

Re: Multiple Filters in Gallery

That is amazing thank you. I probably didn't explain myself well enough so apologies.

I would like the List to remain unfiltered if both the toggle are not in use (so i set the toggle.value = "true") and the search box is still usable even if the toggle is not active.

Was this reply helpful? Yes No
Verified answer

JSeymour on at

Like (0)

Report
Re: Multiple Filters in Gallery

Figured it out!

Search(If(Toggle.Value,Filter('List Name',Status.Value = "Pending"), 'List Name'), 'Search Box'.Text,"Title")
Thank you @Drrickryp for the help, I have used your formula elsewhere in my app that solved a major problem!

Was this reply helpful? Yes No

Join the conversation