Forum Discussion
AdministratorGallery is not searching as expected
I have an excel connection to a table, Table1, which has 3 columns: col1, col2, and col3.
For each item, i did
"col1: " & ThisItem.col1or
"col2: " & ThisItem.col2just 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!
3 Replies
Syndicate_AdminHi , @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