Power Platform Community Forum Thread Details

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>

Categories:

Building Power Apps

Hi @ecruz1 ,

Is this what you are trying to do ?

With(
 {
 _Data,
 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)
 )
 },
 Table(
 {Value: Blank()}, 
 Distinct(
 _Data, 
 value1
 )
 )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps