You’re offline. This is a read only version of the page.
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.
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.
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!
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
Share
Report
All responses (
Answers (
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!
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.
#1
WarrenBelz
146,609
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
