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.
The reset works and i dont loose the data in the gallery but I lost the search/filter function 😞
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! 🙂
User | Count |
---|---|
255 | |
114 | |
95 | |
48 | |
38 |