filter - dropdown values

[neill_long]

I have a gallery which displays users.  Each user has a dropdown field which lists their skills.  They can have more than one skill listed.

I would like to be able to add a search function or a filter that when you type a skill in the search box, the gallery will display all users who have this skill listed in their dropdown field.

Can this be done?

If so, can someone advise how i can go about creating this please?

[v-xida-msft · Accepted solution]

Hi @neill_long,

Could you please share a bit more about the Dropdown field that you mentioned? Is it a Choice type column which enables multiple selections?

The user @Lp939 has faced similar issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/Casading-dropdown-with-2-SharePoint-Lists/m-p...

I have created a SP list on my side, the data structure as below:

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery control to following formula:

If(
    IsBlank(TextSearchBox1.Text),
    '20181026_case11',
    Filter(
    '20181026_case11', 
    TextSearchBox1.Text in SkillSet.Value         /* SkillSet is a Choice column in my SP list, which enables multiple selections*/
    )
)

On your side, you should type:

If(
    IsBlank(TextSearchBox1.Text),
    'YourSPList',
    Filter(
    'YourSPList', 
    TextSearchBox1.Text in YourDropdownField.Value         /* YourDropdownField is a Choice column in my SP list, which enables multiple selections*/
    )
)

The GIF screenshot as below:

Best regards,

Kris

[neill_long]

Hi @v-xida-msft

It is a lookup field that you can select multiple options.

Following your suggestion, i was able to amend it a little to work the way i was hoping it to, so thanks for your help.