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! 🙂
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!