Search only working some of the time

[AAK1]

I have an app that is working quite well, except for the search. It is searching a gallery. I'm looking through three fields based on input in a text box. Sometimes the search works perfectly well, other times the gallery is showing too many items, but if I delete one letter or number and then add it back in, it works fine. I can't find any reason for this. I tried using filter, but got the same intermittent problems. My code is below.

SortByColumns(Sort(Search('[dbo].[myTable]',txtSearch.Text, "Field1", "Field2", "Field3"),ID,Descending),"Field1")

I also tried

SortByColumns(Sort(Filter('[dbo].[myTable]',txtSearch.Text in Field1 || txtSearch.Text in Field2 || txtSearch.Text in  Field3),ID,Descending),"Field1")

[AAK1]

Good point, my users are already getting used to backing out a character and re-entering it, so I may leave it like it is and hope that this is a bug that gets fixed.