cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MKWIN
Level: Powered On

Cascading Dropdown from Multi-Selection ComboBox

Hello together, I've got some questions regarding a cascading dropdown from a Multi-Selection ComboBox:

 

Situation as follows: 

I've got a Data Source (SP list) with 3 Columns (All single lines of text, tho could be edited):

Stream         Product             Special Role

Stream1       Product 1          

Stream1       Product 2          Special Role 1

Stream1       Product 2          Special Role 2

Stream 2      Product 1          

[...]

 

I already got a working app which allows me to select a Stream, the dependent Product and, if the Product has special roles, a special role. I work with normal cascading dropdowns here.

 

Now I want to be able to select multiple products at once from 1 Stream, so the Multi-Selection ComboBox for Product is still cascading from Stream.

But now I have to be able to select the respective special roles for the products.

The best solution would be to have a dynamic number of dropdown fields which allow special roles selection for each Product on its own.  So if I would select 2 Products, which both have Special Roles, I'd have 2 dropdowns. 

--> Question: Is this possible and if so, how ?

If this is not working, I'd use a Multi-Selection ComboBox with a "double" layout which displays the role and the respective product.

--> Question: How do I have to configure the Items property of the Role-Selection-ComboBox and the Update property of the role data card?

 

I hope someone can help and thanks in advance 🙂 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Cascading Dropdown from Multi-Selection ComboBox

Hey @MKWIN 

 

Yes, you can create a cascading dropdown in such a way that it will only display the related items as:
 
StreamDropdown -> Items -> Distinct(SPlist,Stream)
 
ProductDropdown -> Items -> Distinct(Filter(SPlist, Stream = StreamDropdown.Selected.Result),Product)
 
SpecialRoleDropdown -> Items -> Distinct(Filter(SPlist, Stream = StreamDropdown.Selected.Result && Product = ProductDropdown.Selected.Result),'Special Role')
 
Now, since these are text fields and you want to save the values. In case you want to save the values separated by comma, then you can use the expression:
 
StreamDropdown Datacard -> Update-> Concat(StreamDropdown.SelectedItems,Result,",")
 
ProductDropdown DataCard -> Update-> Concat(ProductDropdown.SelectedItems,Result,",")
 
SpecialRoleDropdown DataCard -> Update-> Concat(SpecialRoleDropdown.SelectedItems,Result,",")
 
If this differs, please share more information about the implementation, maybe with an example. So that we might be able to help you better.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

5 REPLIES 5
Dual Super User
Dual Super User

Re: Cascading Dropdown from Multi-Selection ComboBox

Hey @MKWIN 

 

Yes, you can create a cascading dropdown in such a way that it will only display the related items as:
 
StreamDropdown -> Items -> Distinct(SPlist,Stream)
 
ProductDropdown -> Items -> Distinct(Filter(SPlist, Stream = StreamDropdown.Selected.Result),Product)
 
SpecialRoleDropdown -> Items -> Distinct(Filter(SPlist, Stream = StreamDropdown.Selected.Result && Product = ProductDropdown.Selected.Result),'Special Role')
 
Now, since these are text fields and you want to save the values. In case you want to save the values separated by comma, then you can use the expression:
 
StreamDropdown Datacard -> Update-> Concat(StreamDropdown.SelectedItems,Result,",")
 
ProductDropdown DataCard -> Update-> Concat(ProductDropdown.SelectedItems,Result,",")
 
SpecialRoleDropdown DataCard -> Update-> Concat(SpecialRoleDropdown.SelectedItems,Result,",")
 
If this differs, please share more information about the implementation, maybe with an example. So that we might be able to help you better.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

MKWIN
Level: Powered On

Re: Cascading Dropdown from Multi-Selection ComboBox

Hey, your answer helped a lot. I just have some further questions:

 

When selecting 2-3 products now, I can only select the respective roles for the last selected product, which means I'd have to explain to the user now that he has to do the selection as following:

Product --> Respective Role

Product2 --> Respective Role

[...]

Best would obviously be when the user could select all products and then get displayed all possible roles for all selected products. I'd then use the ComboBox-Property "DisplayFields" to display the respective dashboards to selectable roles.

Is it possible to get this solution to work?

 

Thanks in advance for all the support (:

 

Dual Super User
Dual Super User

Re: Cascading Dropdown from Multi-Selection ComboBox

Hi @MKWIN 

 

In that case, can you try to update the expressions as:
 
StreamDropdown -> Items -> Distinct(SPlist,Stream)
 
ProductDropdown -> Items -> Distinct(Filter(SPlist, Stream in StreamDropdown.SelectedItems.Result),Product)
 
SpecialRoleDropdown -> Items -> Distinct(Filter(SPlist, Stream in StreamDropdown.SelectedItems.Result && Product in ProductDropdown.SelectedItems.Result),'Special Role')
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
MKWIN
Level: Powered On

Re: Cascading Dropdown from Multi-Selection ComboBox

Perfect, this is working so far. Last question: How can I modify the DisplayFields value to display both, Product and Role?

 

Big thank you again!!

Dual Super User
Dual Super User

Re: Cascading Dropdown from Multi-Selection ComboBox

Hey @MKWIN 

 

To do this, select the combobox, and update the Layout under Fields from the right side menu. Select Double and this will allow you to select two fields, both product and role.
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,681)