I have a gallery that has its records being filtered. I want is a button or something for the filter to be removed and for all records to display like they did before being filtered. When I select an item from Gallery1, items in the table that have a matching location display on Gallery2. Gallery1 is just a gallery that displays a list of locations.
Filter(Search(Testing_Database,'Textbox Search'.Text, "Artist","Title","Location","Medium","Nationality"), Location = Gallery1.Selected.Result)
I've also realized that the search bar searches the entire table instead of just the items being filtered when the user selects a filter. Of course, if the user selects a filter they would only want to search through the filtered list not the entire table. How can I fix this?
Solved! Go to Solution.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021