I've got a data table which is being filtered by several dropdowns using the following code:
Filter(
MyCollection,
(IsBlank(dropdown1.Selected.Value) || dropdown1.Selected.Value = value1) &&
(IsBlank(dropdown2.Selected.Value) || dropdown2.Selected.Value = value2) &&
(IsBlank(dropdown3.Selected.Value) || dropdown3.Selected.Value = value3) &&
(IsBlank(dropdown4.Selected.Value) || dropdown4.Selected.Value = value4) &&
(IsBlank(dropdown5.Selected.Value) || dropdown5.Selected.Value = value5) &&
(IsBlank(dropdown6.Selected.Value) || dropdown6.Selected.Value = value6)
)<div> <div><span>And here is the code I'm using to get the values for the dropdown menus:<div> <li-code lang="markup">Table({fieldname: Blank()}, Distinct(MyCollection, value1))<div> <div> <div><span>My question is how can I also filter the items shown in the dropdowns so I can get a more intuitive dropdown menu, like excel, so it doesn't also show values that were already filtered out of the data table?<div> </div></span></div></div></div>


Report
All responses (
Answers (