Cascading Dropdown from Multi-Selection ComboBox

[MKWIN]

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 🙂 

[yashag2255 · Accepted solution]

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!

[MKWIN]

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 (:

[yashag2255]

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]

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!!

[yashag2255]

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!