Search Filtered Gallery

(0) Share

Report

Posted on by ItsGavin_

Hi all,

Still a newbie to PowerApps, so asking for some more help!

I have a list that I would like to hard code a filter, which I have done by the fomula: Filter('Toolkit', StartsWith(Name, "BRIEFING SHEET")||StartsWith(Name, "BULLITEN")||StartsWith(Name,"Brief"))

However, I would like the end user to be able to search through the list that is filtered. I have tried to add the search box an add search functions, but none of them seem to be working. Any tips?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ItsGavin_ ,

Please take a look at this document.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup#syntax

Does it help?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

timl 37,285 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@ItsGavin_

>> However, I would like the end user to be able to search through the list that is filtered

What column in your list do you want your user to search against? Asuming you want users to search against the Name column, the syntax would look like this:

With( {data:Filter('Toolkit', StartsWith(Name, "BRIEFING SHEET")||StartsWith(Name, "BULLITEN")||StartsWith(Name,"Brief") ) }, Filter(data, txtSearchBox.Text in Name) )

Was this reply helpful? Yes No
ItsGavin_ 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@timl
This is amazing! Worked like a dream! Thank you!

Was this reply helpful? Yes No