Skip to main content
Community site session details

Community site session details

Session Id : YEDBSd1PavkghP/tukcVQk
Power Apps - Building Power Apps
Answered

Search function not searching

Like (0) ShareShare
ReportReport
Posted on 21 Jun 2024 15:03:38 by 6

Hi All,

 

I know that there are a lot of articles on this already. I've spent hours reading through all the solutions to problems but none of the solutions seem to fix my problem. Like most people with this same problem I am a beginner and I am trying to trial and error my way to a solution.

 

I have a canvas power apps app, which is being fed from Excel Online (Business)

 

I have a gallery and a search bar. The gallery populates when the search bar is empty. Using the function - Search(Table,SearchInput.Text,'Column 1','Column2')

 

My understanding is that it is using the text in the search box to look for matching text in my 2 columns. With the box being empty it is bringing through everything into the gallery. 

 

The issue I'm having is that when anything at all is typed into the search box (numbers, letters, symbols) the gallery goes blank.

 

I've no idea where to start trying to fix this. So far I have tried the Start with function, which has exactly the same problem. It feels like it doesn't recognise that there is text in my columns.

Categories:
  • ANB Profile Picture
    7,128 Super User 2025 Season 1 on 21 Jun 2024 at 16:26:04
    Re: Search function not searching

    @Connor0 Not sure why this doesnt work for you earlier. Basically we have used StartWith function in Filter. 

     

    Thanks,

    ANB

  • Connor0 Profile Picture
    6 on 21 Jun 2024 at 15:43:56
    Re: Search function not searching

    Thank you, this now works. For future reference, why does this work? It seems to be using the same functions that I had already tried.

  • Verified answer
    ANB Profile Picture
    7,128 Super User 2025 Season 1 on 21 Jun 2024 at 15:08:22
    Re: Search function not searching

    Hi @Connor0 < Please try this:

    Filter( Table, StartsWith( Column 1, SearchInput.Text ) || StartsWith( Column 2, SearchInput.Text ) || IsBlank(SearchInput.Text ))

    https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-startswith

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


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

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Loading complete