Filter Gallery on ComboBox

[administrator]

Search(
Filter({DataSource of Collection},
(IsBlank(ClassMethodeDropDown.Selected.Id) || ClassificationMethodId = ClassMethodeDropDown.Selected.Id) &&
(IsBlank(ClassGrpDropDown.Selected.Id) || ClassificationGroupId = ClassGrpDropDown.Selected.Id) &&
(IsBlank(ClassificationDropDown.Selected.Id) || classificatieId = ClassificationDropDown.Selected.Id)
),
SearchField.Text, "ProductName","ProductCode"
)

Yellow= Database or collection to connect to
RED = ComboBox in Canvas App
GREEN = Fields from the SQL database
BLUE = SQL Fields to search on in SearchField