cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sgrpdl
Helper II
Helper II

Cascading Combo Box Multi select - share-point list possible?

I have searched solution for this long but still not able to got it. digged diffrent forum but got nothing. hope some one here can help me.

Issues is I have two list a) location List  b) Main List
Got two combo box in Main list
1)combo1zone= 
2)combo2place

 

If I select East in combo1zone then combo2place should display New York, New Jersey and if i select East and West  in combo1zone then combo2place should show  New York, New Jersey, Washington. 

I am able to cascade but not able to save and modify.

Is there any solution or any expert can help.

location.jpg

,

combo.jpg

,

 

update.jpg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
4 REPLIES 4
v-yuxima-msft
Community Support
Community Support

Hi @sgrpdl ,

 

What column type of the Zone and Place in your SP list?

Are they both choices type?

If yes, until now I have not found one perfect solution to solve it, however as one alternative solution, you can reference as next.

 

Data Source:

Zone (single line)

Place(single line)

20190314cascading1.PNG

 

App Test:

In the Form, Please change the Control type of the Zone_DataCard3 and Place_DataCard3 to "Allowed values";

Add one button, and Button.OnSelect:ClearCollect(test,{ID:1, Zone:"East",Place:"New York,New Jersey"},{ID:2,Zone:"East,West", Place:"New York,New Jersey,Washington"})

Then DataCardValue13.Items:test.Zone

DataCardValue14.Items:Filter(test,Zone= DataCardValue13.Selected.Zone).Place     

(you can change the datacard name to yours on your side)

20190314allowed values.PNG

 

Result Test:

20190314cascadinggif.gif

 

20190314cascadingresultsp.PNG

 

Hope this could be helpful.

 

Best Regards.

Yumia

 

Yes!

both zone and plcae is text type in "location LIST" and  (this zone and place will grow more than 500 items)
--
My req is: when i press default power apps save button
then the combo box selected items shoud get saved in MASTER LIST.

i created collection, colllction and set data source of combobox to it.
Items proerty of both combo are as
items.JPG


--

What should i use for update  and default in zone data card and place data card. I tried selecteditems but shows error'. 

 

 

}".update1.JPG

 

Hi @sgrpdl ,

 

Thanks for your solution and I will test it next.

 

Best Regards.

Yumia

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,383)