
Announcements
Hi,
I am trying to set up filtering using a combo box and text search via a search field in a gallery.
In the combo box, users should be able to select from various categories, and in the text search field, users should simply be able to search by text. The two functions should work together.
I have added the data source to the combo box and selected the categories.
Combo box:
Items: Search(Materialebanken, ComboBox2.SelectedItems, Value)
The data source is called Materialebanken.
The column to be used in the combo box is called Materialekategori.
Gallery
The gallery is set up like this:
Items: Search(Materialebanken, TextSearchBox1.Text, Titel)
In the combo box I do see the correct categories and the text search is also working and sorting in the gallery. But I guess I need the correct setup for the gallery so that the combo box also work.
Are the combo box, text search field, and gallery set up correctly?
Search(
Filter(
Materialebanken,
Materialekategori in ComboBox2.SelectedItems.Value
),
TextSearchBox1.Text,
Titel
)