Hi@Georgetown15x,
Based on the issue that you mentioned, do you want to search two columns within a Search box?
Could you please share a bit more about the scenario, do you want to search and dispaly the filtering result within a Gallery?
Combine that with your description, you want to sort the 'Name' column based on the searched result if there is something with the TextSearchBox and you want to sort the 'Name' column within the data source if there is nothing within the TextSearchBox.
I think that the Search() function could achieve your needs. There is something syntax wrong with your formula.
I have a test on my side, please take a try as below.
Set the Items property of the Gallery as following:
Sort(
If(
IsBlank(FilterTextBox.Text),
Movements,
Search(
Movements,
FilterTextBox.Text,
"Location",
"Name"
)
),
"Name"
)
Best Regards,
Qi
