Filter table based on comma separated search input text?

(1) Share

Report

Posted on by kooliokevin

Hello

Foreword: I'm using modern controls, so the text inputs below would use .Value instead of .Text

I am filtering a gallery using the Search() function on multiple columns, to return records from a table that have the text from tiSearch.Value in the columns specified:

Search(

[@'DataverseTableName'], //table to search

tiSearch.Value, //text value used as search criteria

'Example Column1', //column to search

'Example Column2' //column to search

)

This would return any records that have the text from tiSearch in either of the columns 'Example Column1' or 'Example Column2'

ex: tiSearch text is "Frank", it would return records with "Frank" in the above columns

Say I want to comma-delimit my search criteria, say I want to search "Frank, 2024" - where I want to return results that contain either "Frank" or "2024" in either those columns?

Is such a thing possible?

Something like this?

Search(

[@'DataverseTableName'],

ForAll(Split(tiSearch.Value, ","),TrimEnds(Value)),

'Example Column1',

'Example Column2'

)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi kooliokevin,

Try this format
Ungroup( ForAll( Split( tiSearch.Value, "," ), Search( [@'DataverseTableName'], TrimEnds(Value), 'Example Column1', 'Example Column2' ) ), Value )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Unfortunately no

You either have to use:

1) Filter function instead

2) Build a Search of Search of Search

meaning you would have to wrap the first search that only did for word "ONE", with another search that does "TWO" etc etc

Was this reply helpful? Yes No
kooliokevin 39 on at

Like (0)

Report

@WarrenBelz

Thank you, this is very close to what I'm looking for!

It seems change to a different identifier for the column names though, as in:

Within the gallery, I have a text label that is showing ThisItem.'Example Column1', however now it is needing ThisItem.'dataversetable_column_schema_name'.

This column is a choice column instead of text, how does that play into this?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi kooliokevin ,

You need a delimiter for Split() to operate the ForAll function. I do not think there is one in the structure you suggest.

Was this reply helpful? Yes No