Hi All,
I have a Datatable with a field called Status, which is either delivered or Not Delived. This datatable has Filter on it already,
What I would like to do is when the check is ticked, it will only show the Delivered items and unchecked it will show all. I have already tried the OnCheck option for the checkbox
Any assistance would be appreciated.
Hello @Skybluekid
If your Status column is choice type
Filter('YourTable', 'YourHiddenColumn'=ComboBox1.Selected.Value, If(CheckBox1.Value, Status.Value="Delivered", true))
If your Status column is text:
Filter('YourTable', 'YourHiddenColumn'=ComboBox1.Selected.Value, If(CheckBox1.Value, Status="Delivered", true))