Hi,
I am trying to filter data in a gallery based on text input and dropdown box values. I have three tables, Service, Location and Status. Status only contains a choice field with "Open" and "Closed" as the available options.
I want to allow users to filter for Open and Closed cases by selecting Open/Closed from a drop down box
I cannot seem to select "Status" as the source. Instead I set item = ["Open", "Closed"]. The problem is I don't know the correct filter expression.
Filter(Service,SDB_Status = [@SDB_Status].Open) works when applied directly to the Gallery. Filter(Service,SDB_engineer = dropdown.selected.value) works because SDB_engineer is a normal text data type field. But if I replace SDB_engineer with SDB_Status, [@SDB_Status] or SDB_Status. value the filter does not work.
What is the correct way to filter/search/lookup data in fields that are a choice date type?
