I sort of have this working but not quite right. Focusing on the right pane of my sheet I have a Gallery filtered by both the dropdown (Dropdown_Sup_3) currently showing Lynn River, and a combobox (ComboBox1Custom) currently showing 4 Items. The dropdown is filtering but the combobox is still letting me choose items from other Suppliers. Is the combobox supposed to be filtered by the dropdown?
Solved! Go to Solution.
Are you saying that the ComboBox should only be showing 2 items?
Please supply the code used in the Items property of the ComboBox. Is there any column for Vendor in the datasource for this?
Yeah, taking a while to understand how to work with combobox.
If(IsEmpty(ComboBox1Custom.SelectedItems) ,Table1 , Filter(Table1,Description02 in ComboBox1Custom.SelectedItems.Description02 && Supplier in Dropdown_Sup_3.Selected.Result))
Would simply re-using the same code from the Items property of your Dropdown work?
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @Corissandageri ,
Do you want the combo box only display the items filtered by the drop down?
If so, Please set the combo box's Items:
Other formulas do not need to modify.
If you want the combo box display items without duplicate value, try this:
In this situation, the DisplayFields and Search Fields could only set to the column.
The gallery's Items:
If(IsEmpty(ComboBox1Custom.SelectedItems) ,Table1 , Filter(Table1,Description02 in ComboBox1Custom.SelectedItems.Result && Supplier in Dropdown_Sup_3.Selected.Result))
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications