
Announcements
Hi everyone
I want to have ListBox depends on another listbox to filter a DataTable, but the challange here that I want my list box to have all items in it selected (ListBox are always not selected until the user select). So the ListBox should always selected everything in it.
My Formula in Items: Distinct(Filter(Table2, Division = ListBox3.Selected.Result), Department)
How can I proseed?is it doable or not?
No, you cannot select Items in a ListBox. Consider using another control where you can select items by default (like the Combobox) or use a gallery to provide similar results.
I hope this is helpful for you.