Filter with a combo box multiple selection

[gaffyjes]

Hi, I have a combo box with multiple selections that are shown in a label field separated with commas (product1, product2, etc), I need to filter another combo and have only the records that were selected in the first combo box.

Thanks for the help

[ganeshsanap · Accepted solution]

@gaffyjes Check below threads, it might help you:

1. Filtering one combo-box items, based on another combo-box selected items 
2. Filter Combo box items based on another multi select Combo box item 
3. https://powerusers.microsoft.com/t5/Building-Power-Apps/combo-boxes-filtering-on-different-combo-box... 

---

Please click Accept as solution if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

[v-qiaqi-msft]

Hi@gaffyjes,

Based on the issue that you mentioned, do you want to filter Combo Box based on another multi-select Combo Box?

Could you please share a bit more about the scenario?

Here is my scenario, you can check to compare with yours.

Set the Items property for both of the Combo Boxes as below:

Choices([@Test1029].Combo1) // For the Combo1 column

Choices(Test1029.Combo2)  // For the Combo2 column.

Set the DefaultSelectedItems property of the Combo Box corresponding to the Combo2 column as below:

LookUp(
    Test1029,
    Concat(
        DataCardValue11.SelectedItems.Value,
        Value & ","
    ) in Concat(
        Combo1,
        Value & ","
    )
).Combo2

Note: DataCardValue11 represents the Combo Box corresponding to the Combo1 column.

Hope it could help.

Best Regards,

Qi