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.
@Connor0 Not sure why this doesnt work for you earlier. Basically we have used StartWith function in Filter.
Thanks,
ANB
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.
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
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1