PowerApps Cascading Dropdown - See comments for 2021 version

In today's show, you learn about PowerApps cascading dropdown menus. Nothing fancy but they are a must to make good apps for your users.

Other functions covered:
If
Reset
Sort
Distinct
Disabled

[carlamahlberg]

So easy to understand. I think I will subscribe to your channel, don't know why I went anywhere else to explain dropdowns :-)

[cztop]

Shane! As always --THE BEST! I just worked through another cascading video created by another well-known author. Could NOT figure it out and it was presented as "oh -- so very easy"! As usual, I knew right where to come when I was stuck.

What you do best is teach us how to thing through these things in the most clear, concise, non-intimidating, funny and kind way! Don't know what we'd do without you!

Thanks ever and always so much!

[bigjonradio]

Hello Shane!

I'm working my way through your videos. They're absolutely brilliant. 20 minutes is a great 'bite sized' chunk & you absolutely don't need to worry that "it's not pretty" - showing the functionality gets straight to the point. Love your style & sense of fun!

[tordsonander]

This channel is like finding a gold ore!
All the "what if i could build an app to help with that at work" is suddenly within reach with PowerApps.
Together with your work there is an epiphany every. single. evening! Thanks Shane!

[nharzic]

So helpful and clearly explained. Thank you. On the Refresh button, I added a reset of the two dropdowns so that the form would clear out any existing choices. This will be an ideal solution for choosing locations in a help desk form.

[dallas]

Great vid, sir! How has this been out here for TWO YEARS, and I just came across it now? Love your blend of authenticity and information. You have a great delivery.

[karamqusai]

was amazing, your solution inspired me to think of another one

you have a field you want to be filled from a selected item from a drop-down menu
here is what you do
1 create a dropdown button
2 let the field default value be the dropdown button selected value
3 put the dropdown button above the field to look like the field itself is a dropdown menu

[prasanthgeddam]

How update a label depending on cascading drop down: Example: 1st drop down HR is selected; cascading dropdown - manager is selected ; Now one flexible label should appear no.of new joinees this month; in similar way if IT is selected and in 2nd drop manager is selected label should tell no.of project hours this month and values entered in text boxes against that labels should go to that particular column in sharepoint list or excel - Thank you in advance and appreciate your high energy classes

[Andressamagalha]

I'm really grateful for you sharing your knowledge! I've been learning a lot. Your sense of humor makes the videos lighter and your straightforwardness for explaining the contents is quite valuable.

[marcsavoie]

You are a life saver! The Distinct() trick helped me with filtering data based on a dropdown list that was made in SharePoint, on which I had no control on what choices the user had.

[tausifjamkhandi]

I had created two cascading list using infopath form which was very much time consuming n also had to create multiple list with lookup columns, PowerApp is a great tool n thanks for ur explanation
It was easy to understand👍
Keep posting new vdos, u r doing a great job👌🏻

[angiferguson]

Shane, You're AMAZING! Thank you so much for explaining how to get the cascading dropdowns to work, from the beginning. It's so helpful!

[agytkumar]

Thank you for the awesome explanation. Your videos are the best source of information on PowerApps I found till now. Thank you for helping the community.

[none]

Please stick to same way of explaining things .. It's just so plain and easy to grasp and helped a lot .Thanks for doing it .

[keimomomon]

Watching in the year 2022, thank you for this tutorial! It helps with my current project right now!!!

[EmmaManetta]

Thank you very much for all your work on these videos. I was about to just forget about Powerapps all together because I was frustrated trying to learn and you helped give me hope again. :)

[almiraizmakova]

You explained very clearly than others YouTube videos 👍Keep going like that! I will be seeing only your videos.

[FM-luhu]

Direct, Concise, Useful; your stuff is great for folks that want to get in, get it done, and get on to the next thing. Two big Thumbs Up.

[jimfitch]

I try to be on time, but here I am joining this party 2 years later -- almost to the day! Great video, Shane, as always. The main topic may be Cascading Dropdown controls, but I really like the bonus tips here. They may be little things, but it's the little things that are the finishing touches that make a truly professional-looking app, isn't it?

[theinkweaver]

FYI - For using a SharePoint list instead of an excel table, I found that in the second dropdown, the data type also has to be Result (instead of Value). (It also then requires a value in each dropdown, auto-selecting the first available row instead of leaving it blank for the user to select an option. Not sure yet how to fix that issue, but I'm still learning.)