Searchbox with substring

(0) Share

Report

Posted on by FZ80

148

Hi All,

I'am looking for a formula for my Gallery linked to a searchbox.

This formula should return the results of of what is entered in the searchbox in this way:

If I type 'po' all cells of a specific column with 'po' in it should be returned. So: Police, Opposition but also is the cel with 'After Poule' .

So far I did not manage to fix this.

I tried:

- Filter(Datasource, Instr(Textcolumn, Srachstring) >0)

- Filter(Items, Instr (Columnname, Searchstring) >0)

- Filter(Datasource, Search( SearchString, TextColumn, TextOrBinaryComparison.Full) <> -1)

- Filter(DataSource, TextSearchBox.Text in TextColmn)

Does someone have the sollution?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Hi @FZ80 , use a pattern like below:

Search( 'Your Data Source', TextInput1.Text, "Your Column" )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
FZ80 148 on at

Like (0)

Report

Thanks Amik, this is exactly what does the job!
This fx is for searching in 1 column, do you (by accident :)) know how to let the formula do this search job but than in 2 or even more columns of the same Table?

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@FZ80 you can search multiple columns from the same TextInput box by additional fields into the expression:

Search( 'Your Data Source', TextInput1.Text, "Your Column", "Your Column2", "Your Column3", "Your Column4" )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

FZ80 148 on at

Like (0)

Report

Thanks so much Amik, Now it all works perfect!

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

No problem. Please accept my solution as the solution rather than your reply 😆

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No