web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display specific value...
Power Apps
Unanswered

Display specific values from choice field.

(0) ShareShare
ReportReport
Posted on by 221

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. 

Categories:
I have the same question (0)
  • gulshankhurana Profile Picture
    1,397 Moderator on at

    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 Profile Picture
    1,228 Super User 2025 Season 2 on at

    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 Profile Picture
    221 on at

    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 Profile Picture
    1,228 Super User 2025 Season 2 on at

    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 Profile Picture
    1,397 Moderator on at

    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 Profile Picture
    221 on at

    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 Profile Picture
    1,228 Super User 2025 Season 2 on at

    Sure thing!

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard