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

[Anonymous]

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

[v-monli-msft]

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.

Regards,

Mona

[panand99]

you can use:

Distinct(Filter(SPList,Department=DepartmentCombobox.Selected.Result),Books)

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

[Anonymous]

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? 

Choices(SharePointList1.Department)

I have attached some screenshots of errors.  

Thank you!