Text search box

[ithinkican123]

Hello I am new to PowerApps and I am having issues with the search Items box. I created a simple test list in sharpoint. I want to be able to search the name and have it display from the list below it. I am not sure if I need to make changes in the BrowseGallery1-items area or the TextSearchBox1 area. Thanks for any help!

[eka24]

Continue with @iAm_ManCat

[Tapesh]

This solution is perfectly working  "Sir Sancho"

Thank you so much for correcting me on my issue and clearing me what was wrong and what is the code or formula is doing. Thanks @iAm_ManCat 

[iAm_ManCat]

I'm happy to help @Tapesh - these kinds of filters can be tricky, and they will come up very often 😺

[Yousra]

Is it possible for the search bar to search the list by two different criteria:

1. Name (or title)

2. reference number

What would the formula look like in this case?

[iAm_ManCat]

Hi @Yousra 

I think you could do something like this:

SortByColumns(
      Filter(
             ListName, 
             StartsWith(
                        Name,
                        TextSearchBox1.Text
             )
             ||
             NumberColumn = TextSearchBox1.Text
             ), 
      "Title", 
      If(
         SortDescending1,
         Descending,
         Ascending
      )
)

Cheers,

Sancho

[Yousra]

Could you elaborate on this part of the function please?

||

NumberColumn = TextSearchBox1.Text