Filter for combobox multi selecteditems using sharepoint

[BHR]

Hi All,

A candidate can have multiple skills(In sharepoint list column(Skill) having value as : A,B,C) and the gallery shows the list of candidates and their skills. I want to filter the gallery to show Candidates for each skill selected  in combobox.

For ex: If i select A,C gallery should shows the list of candidates who are having skill as  A or B.

Thanks.

[v-bofeng-msft · Accepted solution]

Hi @BHR ,

I assume Skill is choice column that allow multiple selections. I've made a test for your reference:

1\My SP list

2\Add a combo box(ComboBox1) and set it's items property to:

Choices(Bof005.Skill)

3\Add a Gallery and set it's items property to:

Filter(Bof005,Sum(ForAll(ComboBox1.SelectedItems,If(Value in Skill.Value,1,0)),Value)>=1)

Best Regards,

Bof