Hi @bobbybob
To search on multiple columns you just need to add further logical tests inside your filter statement and separate each one with the Or operator (i.e. '||' ). See below where I have added 2 further logical tests based on two additional text fields in your data source - the green text would need to be swapped out with your additional field names:
SortByColumns(
Filter(
[@'Filter Dates'],
StartsWith(Title, TextSearchBox1.Text) ||
StartsWith(OtherTextField1, TextSearchBox1.Text) ||
StartsWith(OtherTextField2, TextSearchBox1.Text)
),
"Title",
If(SortDescending1, Descending, Ascending)
)
If you want to add choice fields to your query and you want to search them, you can add the following as another logical test your filter, again separating from adjacent logical tests with '||' :
TextSearchBox1.Text in YourChoiceField1.Value
Note, once you add the 'in' function, the expression becomes non-delegable and you will run into issues if your data source grows beyond 2000 rows - Where-as using the expression above as is with startswith on text fields is delegable and you will have no issues if you data source grows in size over time.
I hope this is helpful, but let me know if you have any queries.
Gerard
