Gallery is not searching as expected

[Syndicate_Admin]

I have an excel connection to a table, Table1, which has 3 columns: col1, col2, and col3.

For each item, i did 

"col1: " & ThisItem.col1

or

"col2: " & ThisItem.col2

just to make it easier to read.

For my Gallery, the Items field is coded like this

SortByColumns(Search(Table1,TextInput.Text,"col1"),"col1",If(SortDescending1,SortOrder.Descending,SortOrder.Ascending))

If i search "2" in the text input, nothing appears even though the first item shown in the image should appear.

Whats wrong? Any help appreciated!

[Syndicate_Admin]

Hi , @doveshampoo 

You may try to use this code :

SortByColumns( Search(AddColumns( Table1,"col1-Text",Text(col1)),TextInput.Text,"col1-Text") "col1",If(SortDescending1,SortOrder.Descending,SortOrder.Ascending))

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,

Yueyun Zhang

[Syndicate_Admin]

having "col1: x" shouldn't matter right?

even if I remove 

"col1: " &

from the formatting, the search doesn't work

[Syndicate_Admin]

Hi, @doveshampoo 

Sure , this is no matter with your "col1: x" , This is just a item in your gallery control.

Dose the before code can not solve your issue?

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,

Yueyun Zhang