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
Filter Gallery on ComboBox
Who is online
Users browsing this forum: No registered users and 7 guests