Hi,
I am trying to filter a gallery based on a dropdown. The connected SharePoint list 'list1' has a 'Due Date' Column. When "Past Due" is selected anything that has a due date before today should be shown. Also 'No Due Date' I want to filter to have the empty rows where no 'Due Date' is entered.
Switch(PastDueDropDwn_2.Selected.Value,"Past Due Items", Filter('list1', 'Target end'<Today())
Thanks!