Display specific values from choice field.

[EMA03356]

Hello, 

I would like to display specific values of a choice field based on a different choice field selection. Please see below. I have three choice columns Deficiency area , Category and Description. These are all choice fields in a sharepoint list. I'd like for the powerapp to display specific values in the dropdown when selected. First a Deficiency Area is selected, then a Category and then a description. Each will have different values depending on the selection. 

Deficiency Area:

1. Electrical 

2. Mechanical

Category: 

If selected Electrical:

1. Cables

2. Cabinets

3. Labels

If selected Mechanical

1......

2....

3...

Then once a category is picked then another specific value based on that selection. 

Description:

If selected Cables

1. Routed improperly

2. Missing components

and so on...

Please help. 

[gulshankhurana]

Hi @EMA03356 

If it is a model driven app then the no-code approach would be to create a tree of lookups instead of using choice columns. You could have a lookup of Category in Description table and a lookup of Deficiency area in the Category table. 

On the form in question where you're using choice columns at present, place a lookup for all three - Deficiency Area, Category and Description. 

For Category lookup, choose to show 'related records only' by Deficiency area. Similarly, Description lookup to show related records by Category.

I hope you find this information useful.

Kind regards

Gulshan

Please give it a thumbs up 👍🏻 if you appreciate my efforts.

If my answer helped you resolve your issue then please also mark it as a solution ✅  so that it helps others experiencing the same problem.

[AmínAA]

Greetings @EMA03356!

While I do agree with @gulshankhurana on that, you might still want to have it that way for whatever reason. Should that be the case, here's how you would do it, but bear in mind that @gulshankhurana recommendation is far better than doint this, if you can do it as such.

Items property on Dropdown1

Distinct(LIST1;'CHOICE 1'.Value)

Items property on Dropdown2

Distinct(
    Filter(
        LIST1;
        'CHOICE 1'.Value = Dropdown1.Selected.Value
    );
    'CHOICE 2'.Value
)

Items property on Dropdown3

Distinct(
    Filter(
        LIST1;
        'CHOICE 1'.Value = Dropdown1.Selected.Value && 'CHOICE 2'.Value = Dropdown1_1.Selected.Value
    );
    'CHOICE 3'.Value
)

Hopefully this helped you out, otherwise, feel free to reply!

[EMA03356]

I'm really new to this, would you be able to point me in the direction of a tutorial or provide more information?

Thank you!

[AmínAA]

Hey @EMA03356!

Here you go! https://www.youtube.com/watch?v=Qzpjq008cBY&t=98s

That's a video from Reza on cascading dropdowns, hopefully that'll be enough, otherwise feel free to reply!

[gulshankhurana]

Hi @EMA03356 

Here's the video regarding cascading/filtering lookups that explains it beautifully:

How to Build Model Driven Apps Cascading Lookups in Dataverse 🙅🏻‍♂️ (youtube.com)

 Hope this information helps.

Kind regards

Gulshan

Please give it a thumbs up 👍🏻 if you appreciate my efforts.

If my answer helped you resolve your issue then please also mark it as a solution ✅  so that it helps others experiencing the same problem.

[EMA03356]

This was helpful, however, the patch function is not working properly. Could you help me figure out how to patch the entry to the list? 

[AmínAA]

Sure thing!

if you can share the details of the patch function I'll be glad to help you out on that one!