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

All responses (5)

Answers (2)

Sort by

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

Like
a
(0)

Report
Copy link

Link copied!
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.
FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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.
Verified answer

FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much Amik, Now it all works perfect!
Verified answer

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

Like
a
(0)

Report
Copy link

Link copied!

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.