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

Announcements

News and Announcements icon
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 Moderator 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 Moderator 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 Moderator 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard