cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Filter with a combo box multiple selection

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

@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 ‌‌👍

 

View solution in original post

2 REPLIES 2
Super User
Super User

@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 ‌‌👍

 

View solution in original post

Community Support
Community Support

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.

combo.png

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.

combo2.png

Hope it could help.

Best Regards,

Qi

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,242)