Answered

Search function not searching

(0) Share

Report

Posted on by Connor0

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Connor0 6 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Thanks,

ANB

Was this reply helpful? Yes No