Hello,
Hello, my search query is currently SortByColumns(
Filter(
[@'keyspace.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91'];
IsBlank(TextSearchBox1.Text) || StartsWith(Number; TextSearchBox1.Text) || StartsWith(Title; TextSearchBox1.Text) || StartsWith(Address; TextSearchBox1.Text)
);
"title";
If(
SortDescending1;
SortOrder. Descending
)
)
For example, my entry in the Microsoft List is ( HG Metropol )
If I now enter Metropol in the SEARCH, it does not find the entry. Only when I enter HG do I get a list. However, I want this entry to be found when I enter METROPOL. How do I do that??? Thanks
Hi @Rallf ,
It seems that your search query appears to be case-sensitive ? Maybe you can try to make the search query case-insensitive with the Lower() function to convert both the search term and the fields you're comparing to lowercase ?
Hope it helps
thanks,
Regards