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
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
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.
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!
User | Count |
---|---|
132 | |
127 | |
78 | |
73 | |
70 |
User | Count |
---|---|
207 | |
199 | |
64 | |
63 | |
52 |