Skip to main content
Community site session details

Community site session details

Session Id : MOnWKRZ15KbZbeg+rFXxo9
Power Automate - Power Automate Mobile App
Answered

TextSearchBox not finding items in data source

Like (0) ShareShare
ReportReport
Posted on 18 Jan 2019 16:52:00 by 2

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.

  • MithaliGupta Profile Picture
    242 on 15 Nov 2022 at 12:45:53
    Re: TextSearchBox not finding items in data source

    You have just prefered search in specific field apply the same on all and return should be values you want and not only city

  • Verified answer
    v-bacao-msft Profile Picture
    on 22 Jan 2019 at 01:34:52
    Re: TextSearchBox not finding items in data source

    Hi @tmoey,

     

    Are you sure you post your question in the expected community?

    I don't see MS Flow related information from the content you provided.

    This seems to be related to PowerApps, please consider posting your question in the PowerApps community, perhaps there is a suitable workaround.

    Also if you have questions about Flow, please provide more details, we would provide proper workaround for you.

     

    Best Regards,

  • tmoey Profile Picture
    2 on 18 Jan 2019 at 17:54:30
    Re: TextSearchBox not finding items in data source

    Upon further analysis, this turned out to be a datasource refresh issue.

    There was nothing wrong with the Search or Sort formulas.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Featured topics

Loading complete