Hello, I have a search function that I want to fix that is attached to a sharepoint gallery, and the formula looks like:
SortByColumns(Filter([@'Lessons Learned'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
How can I fix the formula so that is filters for the entire gallery entry instead of just the first word it starts with?
Thanks