Thanks Mabel. I had put the filter on the dropdown instead of the gallery itself. Now one more question....
The filter works great. I and filtering products per store, so the dropdown selects a store #, and only shows the products at that store. I also want to search those filtered products. I have a text input called TextInput1 and am searching the column called ItemNameWeight. I tried:
Search(Filter(Products,StoreNum = Dropdown1.Selected.Value), TextInput1.Text,"ItemNameWeight")
When I use the above code the filter of the store works, but then when I search, it returns the search items from all stores. How can I limit it to searching only the filtered items?
I also tried to create a search button. I have this in the OnSelect of the button: UpdateContext({ searchTerm: TextInput1.Text }) and I changed the above code to this:
Search(Filter(Products,StoreNum = Dropdown1.Selected.Value), searchTerm,"ItemNameWeight")
If I choose a store number and search a blank input, then it returns the store products, but if I choose a store and search "Coke" for instance, I get all of the Coke products at all of the stores, regardless of what store number is in the dropdown.
Thanks in advance for the help!
