Unanswered

Cascading Combo Box with multiple selections

(1) Share

Report

Posted on by jeroen1290

Hi all,

I am trying to create a setup with three Combo Boxes where they are cascading and dependent on the selected values from the previous Combo Box. I currently have this as logic for my second Combo Box:

Sort(
 Distinct(
 Filter(
 edf_costcontrol_list_local_budget_owners,
 CRG in ddCRG.SelectedItems.Value
 ),
 CostObject_CMT
 ),
 Value
)

So what I am trying to achieve for this combobox is that it gives all the available options for CostObject_CMT, based on the selection made in CRG. In the example table below, if i would have selected Apple and Peer, i want the second dropdown to provide me with the options A, B, and C. However, currently when i make multiple selections for CRG, it doesnt provide all options for CostObject_CMT. I know this because sometimes when I add a value for CRG to my selection, one of the options for CostObject_CMT dissapears, which shouldnt be possible as it should add the additional available options, so nothing should be able to dissapear. Any knows how to resolve this? Thanks

CRG	CostObject_CMT
Apple	A
Apple	B
Peer	C
Banana	D

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hallo @jeroen1290 ,

The only thing that comes to mind that may be related is a delegation issue due to the use of the in operator. However, that doesn't explain why you lose CostObject_CMT values that were showing before when adding CRG items to the selection.

Can you please share what data source you are using and how many items you have in there?

Was this reply helpful? Yes No
Giraldoj 762 Super User 2025 Season 2 on at

Like (0)

Report
Hi @jeroen1290

PowerApps sometimes struggles to handle dynamic tables like ddCRG.SelectedItems directly within a Filter function. This can lead to evaluation issues where the filter logic doesn't work as expected.

You can use a workaround by storing your ComboBox1 selections in a collection and then filtering that collection in ComboBox2.

To do that, follow this configuration:

OnChange Property of ddCRG:

ClearCollect( colSelectedCRG, ddCRG.SelectedItems );

Items Property of ComboBox2:

Sort( Distinct( Filter( edf_costcontrol_list_local_budget_owners, CRG in colSelectedCRG.Value ), CostObject_CMT ), Value );

Using this approach ensures that the filter logic works correctly by leveraging the collection to store selected items, which PowerApps can handle more efficiently.

If my response resolved your issue, please feel free to mark it as the solution by clicking "Accept as solution." This helps others find the answer more easily. If you found the content helpful in any other way, a "Thumbs Up" would be greatly appreciated. Thank you!

Grabación de pant...

Was this reply helpful? Yes No