Filtering Gallery with Dropdown plus a Combobox

(0) Share

Report

Posted on by R Bakker

725

Hi all,

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report

@Corissandageri

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

In the combobox that's showing items from other suppliers, what is the Items property set to? It should be filtered there.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Yeah, taking a while to understand how to work with combobox.
Dropdown_Sup_3
Items
Sort(Distinct(Table1,Supplier),Result)

ComboBox1Custom
Items
Table1
OnChange
ClearCollect(Purchaselist1, Gallery4Custom.AllItems)
DisplayFields
["Description02","Supplier"]
Search Fields
["Description02","Supplier"]

Gallery4Custom
Items
If(IsEmpty(ComboBox1Custom.SelectedItems) ,Table1 , Filter(Table1,Description02 in ComboBox1Custom.SelectedItems.Description02 && Supplier in Dropdown_Sup_3.Selected.Result))

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@Corissandageri

Would simply re-using the same code from the Items property of your Dropdown work?

Sort(Distinct(Table1,Supplier),Result)

---
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."

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (1)

Report
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:

Filter(Table1,Supplier=Dropdown_Sup_3.Selected.Result)

Other formulas do not need to modify.

If you want the combo box display items without duplicate value, try this:

Distinct(Filter(Table1,Supplier=Dropdown_Sup_3.Selected.Result),Distinct).Result

In this situation, the DisplayFields and Search Fields could only set to the column.

DisplayFields

["Result"]

Search Fields

["Result"]

The gallery's Items:

If(IsEmpty(ComboBox1Custom.SelectedItems) ,Table1 , Filter(Table1,Description02 in ComboBox1Custom.SelectedItems.Result && Supplier in Dropdown_Sup_3.Selected.Result))

Best regards,

Was this reply helpful? Yes No
Verified answer

R Bakker 725 on at

Like (0)

Report

Thank you
Filter(Table1,Supplier=Dropdown_Sup_3.Selected.Result)
This part of your code fixed it.

Was this reply helpful? Yes No