Hi Guy's
I have a gallery where I have added a Text Input control to search the gallery.
For the Items in the Gallery I have - SortByColumns(Filter('Contractor List',StartsWith(Title,TextInput1.Text)),"Title",SortOrder.Ascending)
@StretchFredrik
Thanks, that is spot on. I was getting mad as in another app, exactly the same formula was working
Try writing it like this:
SortByColumns(Filter('Contractor List',(IsBlank(TextInput1.Text)|| StartsWith(Title,TextInput1.Text))),"Title",SortOrder.Ascending)
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1