is it possible to set up two combo boxes (parent and child)?

(0) Share

Report

Posted on by cchan000

359

hi. this awesome group has helped me to learn how to do a cascading dropdown in powerapps from sharepoint.

now i have two combo boxes. one is REGIONS, the other is MARKETS. depending on what i select in the region, the markets box will populate. here are the examples. how do i create this?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cchan000 ,

Could you tell me the data type of REGIONS and MARKETS?

If they are choice column ,could you tell me whether they allow multiple choice?

I assume that they are both single choice column.

I've made a similar test for your reference:

1)Set the REGIONS combo box's Items:

Choices(listname.REGIONS )

Set the REGIONS combo box's OnChange:

ReSet(MARKETS combo box name)

2)Set the MARKETS combo box's Items:

Choices(listname.MARKETS)

Set MARKETS combo box's DefaultSelectedItems:

RenameColumns(Distinct(Filter(listname,REGIONS in REGIONS combo box.SelectedItems),MARKETS.Value),"Result","Value")

Then , if you choose selection in the region combo box, the MARKETS combo box will automatically poppulate value.

Best regards,
cchan000 359 on at

Like
a
(0)

Report
Copy link

Link copied!

hi! they are allow multiple choice selection.
cchan000 359 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yutliu-msft

hi! sorry, does your method work if it allows multiple choices?