cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MPtest1234
New Member

Filtering Gallery with Multiple Dropdown Boxes from SharePoint List

Hi,

 

I have searched and found similar questions but still unable to fully understand how to best achieve this.

I have 10 dropdown boxes and need to be able to filter the gallery based on the selection of each of these dropdown boxes.

 

I can have a single filter working simply using the following:

 

Filter('SPListName',Dropdown1.Selected.Value in SPColumnName)

 

How do I build this out so the filter is respected by each selection - sorry I am new to this!

 

Thanks,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hello @MPtest1234 🙂

 

In Filter statement, you can add every filter you want after your source, like this :

Filter(
    'Source',
    Condition1,
    Condition2,
    Condition3
)

For your needs, you have to do this :

Filter(
    'SPListName',
    SPColumn1 = Dropdown1.Selected.Value,
    SPColumn2 = Dropdown2.Selected.Value,
    SPColumn3 = Dropdown3.Selected.Value,
SPColumn4 = Dropdown4.Selected.Value,
SPColumn5 = Dropdown5.Selected.Value,
SPColumn6 = Dropdown6.Selected.Value,
SPColumn7 = Dropdown7.Selected.Value,
SPColumn8 = Dropdown8.Selected.Value,
SPColumn9 = Dropdown9.Selected.Value,
SPColumn10 = Dropdown10.Selected.Value )

I precise that Dropdowns can only get one selected value, so it's better here to put '=' than 'in'.
With ComboBox you have to use 'in' because the result of the selection is always a table.

 

I hope it will be helpful for you.

 

Best regards,

 

Louis

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hello @MPtest1234 🙂

 

In Filter statement, you can add every filter you want after your source, like this :

Filter(
    'Source',
    Condition1,
    Condition2,
    Condition3
)

For your needs, you have to do this :

Filter(
    'SPListName',
    SPColumn1 = Dropdown1.Selected.Value,
    SPColumn2 = Dropdown2.Selected.Value,
    SPColumn3 = Dropdown3.Selected.Value,
SPColumn4 = Dropdown4.Selected.Value,
SPColumn5 = Dropdown5.Selected.Value,
SPColumn6 = Dropdown6.Selected.Value,
SPColumn7 = Dropdown7.Selected.Value,
SPColumn8 = Dropdown8.Selected.Value,
SPColumn9 = Dropdown9.Selected.Value,
SPColumn10 = Dropdown10.Selected.Value )

I precise that Dropdowns can only get one selected value, so it's better here to put '=' than 'in'.
With ComboBox you have to use 'in' because the result of the selection is always a table.

 

I hope it will be helpful for you.

 

Best regards,

 

Louis

View solution in original post

Thanks - this is great

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,339)