1,168
Hi,
Wondering what the approach would be to filtering a gallery off of 2, multiselect combo boxes? ComboBox1 has 5 options and ComboBox2 has 10 options.
Thanks in advance
Todd
Hi @Tango ,
Are you referring to two many-to-many relationships here ? Something like this
Share
Report
All responses (
Answers (
With(
{
wData:
If(
IsEmpty(FirstCombo.SelectedItems),
SPListName,
Ungroup(
ForAll(
FirstCombo.SelectedItems As aSel1,
Filter(
SPListName,
aSel1.Value in FirstChoiceColumn.Value
)
),
"Value"
)
)
},
If(
IsEmpty(Second.SelectedItems),
wData,
Ungroup(
ForAll(
SecondCombo.SelectedItems As aSel2,
Filter(
wData,
aSel2.Value in SecondChoiceColumn.Value
)
),
"Value"
)
)
)
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
