Choices that are dependent on other Choices

(0) Share

Report

Posted on by AZ-11111722-0

We have two choices on a Power Apps Form on Dynamics 365 and we'd like to make it so that the choices that appear in the second choice are dependent on what they pick in the first choice.

For Example:

Company Name (First Choice)

-Company 1

-Company 2

-Company 3

Division Name (Second Choice)

-Division 1 (only shows if they picked Company 1)

-Division 2 (shows only if they picked Company 2 or Company 3)
-Division 3 (show for all companies)

-Division 4 (show only for Company 3)

etc.

And then we want all the Divisions to be in the same table column.

Is there a good way for us to modify which choices are visible depending on circumstances? Or maybe another way to accomplish what we want? The best I've figured out is creating three different Division fields with the choices we want for each Company and using business rules to hide/show the three "Division" fields as necessary. But this causes there to be 3 different table columns for Division which really isn't ideal.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

jrletner 720 Super User 2025 Season 2 on at

Like (0)

Report
Without understanding of your table structures, this is the best I can do for you. If this doesn't help, perhaps you could provide more information.

Cascading dropdowns:

Set the Items property of the Company dropdown to list the unique companies, for example:

Distinct(Divisions, Company)

2. For the Division dropdown, filter based on the selected Company. Set the Items property of the Division dropdown to:

Filter(Divisions, Company = CompanyDropdown.Selected.Result)

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi AZ-11111722-0

If you really want to hard-code it, the format would be
Switch( FirstComboBoxName.Selected.Value, "Company 1", ["Division 1", "Division 3"], "Company 2", ["Division 2", "Division 3"], "Company 3", ["Division 2", "Division 3", "Division 4"] )

otherwise the suggestion from jrletner is the best option using a reference list (except the output of Distinct is now .Value, not .Result)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No