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! 🙂
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.