I have a search box connected to Gallery data source. I have included a RESET button to remove text from the searchbox in order to perform new search. When the RESET is pressed twice it hides the data within the gallery and I cant see the data unless I close the app. (If RESET is pressed once, it removes the text written in the searchbox but doesn't hide the data in the gallery) The issue is when you press the RESET twice the data cannot be seen in the gallery.
Below screenshots shows when RESET is pressed twice.
When I remove the text by using backspace from the searchbox the data in the gallery shows.
Can someone help?
Solved! Go to Solution.
What was your filter formula before?
The current formula you took from us was more of an example than a "use this". If you want searching, then you need to specify that in the formula...
This formula will only show results if the name is complete - not partial:
Filter(ContactList_1, (IsBlank(MySearchTextBox.Text) || Name = TextInputSearch_2.Text) )
This formula will show results if the name startswith what is typed:
Filter(ContactList_1, (IsBlank(MySearchTextBox.Text) || StartsWith(Name, TextInputSearch_2.Text)) )
This formula will search anything that matches (NOTE: This is non-delegable):
Search(ContactList_1, TextInputSearch_2.Text, "Name" )
Happy to help!
@poweractivate thanks for chiming in too! 🙂
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.