web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter for combobox mu...

Power Apps

Answered

Filter for combobox multi selecteditems using sharepoint

(0) Share

Report

Report

Posted on by BHR

55

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.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation