Cascading Dropdown from Multi-Selection ComboBox

(0) Share

Report

Posted on by 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 🙂

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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!