Hi:
I need some help to figure out why the TextSearchBox feature in my mobile PowerApp is not working correctly.
In my BrowseScreen, I have a BrowseGallery that display City, State, Zip and TextSearchBox on top of the screen.
The TexSearchBox search works fine for filtering what is displayed in the BrowseScreen.
However it does not search the entire data source for records to return into the BrowseScreen.
So a very simplified example:
a) DataSource name of "Locations" has these columns : City, State, Zip
Los Angeles, CA, 12344
Santa Monica, CA, 12355
Long Beach, CA, 12366
Anchorage, AK, 22233
Fairbanks, AK, 22244
b) TextSearch box is set to search on City or Zip
This is the formula i have for the BrowserGallery Data Item option:
SortByColumns(
Search(Locations, TextSearchBox1.Text, "City","Zip"),"City",
If(SortDescending1, Descending,Ascending))
b) Let's say I browse to display the cities in the state of California.
Los Angeles, CA, 12344
Santa Monica, CA, 12355
Long Beach, CA, 12366
When using the TextSearchBox:
If I search for "Monica" it will correctly filter the results to only display Santa Monica
If I search for "344" it will correctly filter the results to only display Los Angeles.
If I search for "Anchorage" it will return nothing to the browse screen
The mobile PowerApp was created using the "Start from Data" template, and the data source is an excel file on a OneDrive for Business folder.
thanks in advance for any help or guidance.
