cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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.    

Sample_Drop-down.JPG

 

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

 

 

3 REPLIES 3
Community Support Team
Community Support Team

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

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

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.
Highlighted
panand99
Level 10

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

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
Not applicable

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

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!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 480 members 6,619 guests
Please welcome our newest community members: