Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter Multiple Combo boxes - first one from choice column in SharePoint List

I have several combo boxes that I need to filter on for a gallery.   The first one (Department) is from a choice column in a SharePoint.    



Department Drop-down coding (Dept_ComboBox)

Items = Choices(SharePointList1, Department)

Tooltip = Dept_ComboBox.Selected.Value


I get an error at  the "=" when trying to use the first combo box value to filter on the second combo box. 

Books Drop-down coding (Books_ComboBox_1):

Items = Distinct(Filter(SharePointList1, Department = Dept_ComboBox.Selected.Value),Books)

Tooltip = Books_ComboBox_1.Selected.Result



Community Support
Community Support

Hi @Anonymous,



Is Department a multiple-value enabled choice column? If so, then the settings should be:


Dept_ComboBox.Items = Choices(SharePointList1.Department)
Books_ComboBox.Items = Distinct(Filter(SharePointList1,
First(Dept_ComboBox.SelectedItems) in Department &&
Last(FirstN(Dept_ComboBox.SelectedItems,2)) in Department&&
Last(FirstN(Dept_ComboBox.SelectedItems,3)) in Department &&
) ,Books)

How "......" shows depends on how many options you have for this choice column.





Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution Supplier
Solution Supplier

you can use:




also, i think you are getting Warning with 'yellow' icon, if you use collection instead of list then this will gone.


Not applicable

Hi   @v-monli-msft


The department is a multiple-value enabled choice column.  I have a couple of errors.  Should there be a comma this section? 



I have attached some screenshots of errors.  

Thank you!

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (21,083)