Gallery - wildcard filtering

(0) Share

Report

Posted on by Caelan

Hi,

Not sure if my title is misleading, unsure on terminology.

I have a power app where colleagues select a client name from a combo box, and the combo box selection filters a gallery.

I have an issue where, if a client has a middle name, the user gets a blank in the combo box when searching for the name. For example, 'Caelan T Gill' would not display if the user searched 'Caelan Gill'. I'm trying to find a way to have the dropdown options return names where the search text appears anywhere in the name, allowing for letters between the text. Effectively, I'm wanting to filter the items for each letter of the search individually.

Is there a way to do this?

I've been messing with splitting the search text, concatenating it back together again with """" "&" and filtering the items by that, but can't seem to get it to work.

Categories:

General Questions

All responses (2)

Answers (0)

WarrenBelz 148,693 Most Valuable Professional on at

Like (0)

Report
Re: Gallery - wildcard filtering

Hi @Caelan ,

Your example will never work as it needs to match the complete string you have entered with any part of the target field (Caelan Gill as a string is not in Caelan T Gill ). I had a bit of a play with Split and this seems to work in the Items. NOTE: as it is not Delegable, your list cannot be above your Data Row Limit. - I have used With() at the top to mask the warning, but also to convince the Combo Box to search.

With( { _Items: Split( Self.SearchText, " " ), _Data: YourSPList }, Ungroup( ForAll( _Items, Filter( _Data, Value in YourFieldName ) ), Value ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
mmbr1606 13,090 Super User 2025 Season 1 on at

Like (0)

Report
Re: Gallery - wildcard filtering

hey @Caelan

you can try something like that:

Filter( YourDataSource, TextSearchBox1.Text = "" || Lower(Substitute(ThisItem.FullName, " ", "")) Contains Lower(Substitute(TextSearchBox1.Text, " ", "")) )

be aware that this is only a high level approach

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings