
Announcements
Hi,
In the pic below I want the drop-down to work either as 1 or 2 but its showing error.
Please help!
It doesn't work like that. You need to provide an action which specifies which one you want to use.
Set a variable to do that or may be try this;
If(IsEmpty(ComboBox.SelectedItems),Unfiltered Distinct Statements, Filtered Distinct Statement));
This will first check if something is selected in the combobox. if something is selected. It will give use distinct with filter. If comboox is empty it will use un filtered distinct