PowerApps Cascading Dropdown - See comments for 2021 version 

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

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!

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!

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.

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.

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

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.

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!

Thanks, Shane - this was great! So much out there, but your video was the most straightforward, clear, and directed at what I need than the rest.

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👌🏻

Thank you for your information regarding cascading dropdowns, was having the hardest time making them work. Your video helped me make my application much easier to use. Thank you!

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?

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. :)

Shane I love all you Powerapp Video!! i'm now onto PA #5 and doing some really cool stuff. These videos are soo good to come back to for reference - THANKS

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.

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.

I'm only beginning to use Power Apps. Thanks so much for your videos. You explain so well. Cheers!

Bold Shane!!! from Bold Zebras. Your content always excites me. Great work Shane. Now i know why you are MVP... :)

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.

Hi Shane, thanks for your great work.putting in front of us in a simple mannner and I am sure you have learned hard way .Lots of research has gone into it. Thanks

Shane, thank you so much! Your video's are so helpful and you explain it where a beginner, like myself, can understand!

great job man! I'm just starting out with Power Apps and you explained this very well. You just got another subscriber :)

I am new to PowerApps though but I hope to develop apps using your tutorilas.. this video is so cool and explanatory

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

Hi Shane, You make it so simple, thanks. You have a unique style which makes the whole learning so much fun & easy.... i am already your fan.... love & respect....

this is great. thank you for showing

Thanks for the video Shane, very helpful. Using Selected.Result rather than Selected.Value worked for me

Day one of learning PowerApps. So glad I found this video. Subscribed immediately as this is exactly what I need to build a powerful estimating tool. Thanks! Let me know if there are any videos that can combine this idea with adding values created in drop-downs continually while it builds an estimate in the background.

Thanks Shane... You've made my learning and use of PowerBI very simple and very interesting. Thank you.

Great video, much better than all the rest out there that I've watched.

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

Hei shane! Good video. I have one question. i have sharepoint list in which i have two dropdowns which i want to update for example from power apps .If i want to add more items in tht particular column of list .is tht possible ?

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

Great video Shane I already found a use for this in a invoicing system I've built

Man, you're helping me a lot! Thanks for your dedication on this

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!

Your videos are the best! They help me learn how to use powerApps!

Awesome you made my day . one small query i have two excel from one excel i am making cascading and in another excel i am saving i am able to save the value but the cascading value is not getting saved which i am fetching from another excel can you help me in this please

so simple, you are explaining it in such a great way, thanks a lot for the effort and all the great videos ,BIG LIKE!

Hi Shane, Thanks for the Great videos / Tutorials, there really easy to follow and understand, I only started this week using Powerapp and you have helped me out a hell of a lot so far :) Please can you do a video to show how to create a PowerApp to collect information then store the details on a local device until the devices has a WIFI connection and then have an option to sync the data once the device is on WiFi.

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.)

Shane, Please write a book and make its Kindle version available. Again, this is really great. Thank you very much for your hard work.

Thank you for posting this. I am a beginner and your videos have really helped a lot.

Hi Shayne, this will be very helpful when we map clients chart of accounts (or Product List) for example: Account Code/Name: 2000/000 - Motor Vehicles @ Cost Report Type: Balance Sheet (or Income Statement) Level 1: Assets (Liabilities ; Equity) Level 2: Non-Current Assets (Current Assets) Level 3: Fixed Assets And then after the account has been mapped it pulls through to a SQL Table that is imported in Power BI. Also after the account is mapped it gets removed from the dropdown in PowerApps. This is very handy for reporting purposes for things like mapping products in product category and - subcategories, or projects or employees in different groups. Would be great if you can do a video like that

Shane, You are awesome. Thanks for this presentation.

I am grateful to find this!!!

Hi Shane, thanks for your videos, they're very helpful. Can you please show us how can we navigate into screens by selecting the dropdown items? Thanks

Hi Shane - your videos are awesome! There is so much that I learn not just from watching them, but also they way you explain and demonstrate the concepts. I had a really noob question - if Im an external consultant developing an app from a customer, which account should I use? I would not be part of the Office 365 list - so would they have to make a separate account for me which they are then forced not to close (even after I exit); or is there just another way. My request is for you to make a video from a developers perspective in terms of setting the various environments, security groups and policies and finally rolling out the app. I know you have covered a some of these concepts in separate videos - but an integrated video would be terrific! Thanks again for sharing your extensive information and knowledge. Much appreciated!

Thank you so much for such good tutorials. Subscribed!

Just what I was looking for, Thanks!

Thank you Shane, your videos are very descreptive and i learning so much from that!! thanks

I AM SHOCKED!! Not about you, Shane. Your videos are great and very helpful! When I started playing around with PowerApps and started watching your videos, some things were a little odd. I was constantly getting syntax errors and did not understand why. Today I found out. Microsoft, for reasons I cannot understand, decided that it was a good idea to use different characters within the formulas, depending on the used browser language!! So if your browser is set to English (strangely no language selection inside the PowerApps portal and ignoring the language set in the user account settings in Office 365) comma is used, so RGBA(255, 255, 255, 1) in German semicolon is used, so RGBA(255; 255; 255; 1) No wonder my formulas were not working! And due to my screen resolution, I didn’t see the little dot over the comma before today. But why?? I realize that this must come from Excel. Same thing there, BUT Excel is very very old and for compatibility reasons they never changed that, although using localized characters - and even more shockingly - function names, was never a good idea. Anyway, PowerApps is not Excel. So why continue a bad practice in a new tool?? Do you have any idea?

Shane, Love, Love your videos. Thank you. I am fairly new to PowerApps and have been struggling. Your videos are very helpful. I do have a question. I am creating an app from multiple SharePoint lists. On the first 'Dashboard' screen I want to show a list of items and allow the users the ability to filter. I have setup the cascading drop downs for filtering and they work, with the small issue that I cannot have the filters blank and display everything allowing the user to scroll through all items or elect to filter. Thanks.

Straight to the point. Easy to understand.

Thanks Shane. very well explained. Any chance of putting a video about the repeating table behavior of infopath in powerapp

Hi Shane, your videos are great! A question, is it possible to show in one column of the Sharepoint's list the option selected on the drop down menu?

Excellent tutorial Shane! Thank you :)

Great video’s keep up the gold work. Just subscribed to your channel.

Hi Shane, awesome videos! you're the first I've found to actually be helpful. I am attempting to connect to a SharePoint list data source to create my cascading dropdown but I am getting the error "Property cannot consume the type of Tables that this rule produces, due to incompatible schemas" The column type in my list is a Choice with multiple unique choices assigned. Thoughts? Furthermore, as I understand you can connect multiple data sources to an app. In this case could I create things like these drop down options external of the SP List but also connect other data connections within this app to said SP list? Thank you in advance!

This video was super informative! Helped me a lot with my App. Thanks a lot Shane Young

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 .

Hi Shane, I want to thank you for the great help with these tutorials. Could you tell me how I can open another application made with powerapps from an already created one by means of a button? Thank you.

Great Video! I wonder if it is possible to make a cascading list while allowing manual text input into it and make them part of the list after.

This is really a great description. I have tried with a database same as shown in this video with the table consisting 3 columns and i put three dropdowns in the app. The first two dropdowns are working perfectly with all the commands described in the video but i am still unable to find a way so that i could connect the third dropdown as well which will be dependent upon the selected values of first two dropdowns. If you could help me in some way then it will be really helpful.

WOW, Thank you very much. You made it very understandable and now I know how to create cascading drop downs.

This tutorial really helped ! Thank you Shane !

Dude this worked, you are the man.

Hope all is well, may I say your videos are very easy to follow. I appreciate how you stick with mechanics only. I have one question, within your cascading dropdowns I notice that you only display 2 fields/columns to display. I have 3 columns that I need to filter by, I am having trouble with the 3rd dropdown, it only references the 2nd dropdown. I need the 3rd dropdown to filter from 1st and 2nd dropdowns: columns (1st DD = Program Type, 2nd DD = Expense Type, 3rd DD = Expense Description). I tried using the "And" function also "&", "&&" and neither of them worked properly. Please advise if I need 2 distinct functions or an If statement, I have tried them and didn't work either.

Hey Shane, thanks for the great video and hope you can help resolve this: I was able to create the dropdown when I used a static excel sheet as the data source. but the same commands are not working when I am trying to use an excel sheet through onedrive (which allows the option of refreshing the table). Do you have any idea on what might be going wrong?

Thanks Shane, Great Vid. Subscribed.

Hi Shane, what would the dropdown filtering formula would look like if the values come from different sources and the Dept is not a dropdown but a text field?

Hi Shane, have learnt a lot from your videos thanks for all the knowledge u r sharing, I have a doubt I have a form with share point list, I have created a drop down and added one more drop down for the same column and have set visible parameter depending on the yes/no selection but when I submit the form the value from only one of the drop downs is getting updated in the list

Hi Shane! Even after 3 years your video is a great help. But i still have a question. In your example your data are stored vertically -> each entries for your dropdowns are in a row. So how does it works if my data are stored horizontally in columns? The "department dropdown" is the same like yours. But how to do this with your jobtitles if they are written in column1, column2, column3... etc.?

You have great videos! I like all them.

Another great video thanks. I was wondering if you are connecting to a sharepoint, how do you achieve the blank line that you mention. Thanks in advance

Hey Shane, loving your content so far. What do you suggest for Cascading Dropdown with a source of 2000+ options?

Thank you, I was having an error with one of the tutorial I'm reading. This gave me an idea.

Shane, you're cool! (y) Thanks for the tutorials!!

Crystal clear dude.. keep going you'll get more subscribers..

Excellent tutorials. Thank you!!!

Fantastic video! Very helpful, thank you!

Shane, Great video, hoping you can help. So I have a pair of SP lists in the same site. I am trying to use the first list which has a list of our resource in 3 different roles (eg: PC, GPA, ISA). The basics of the table are Role, First, Last, Full Name and details about the resource. Second table is for projects and depending on the services aligned to it a PC, GPA and or ISA will be assigned. For each of the assignments I have a drop-down list which I want to have a filter to reduce the available options . The formulas I have tried include: - ShowColumns(Filter('ICI - Team',IsDCMGPA = "Yes"),"FullName") - No results (Get blue icon with the >500 error/notification.) - Distinct(Filter('ICI - Team','ICI - Team'.Role=PC_Label.Text),'ICI - Team'.FullName) - No results (Get blue icon with the >500 error/notification.) I have also tried a number of other formulas all of wihch have resulted in no results. I am not sure what I am doing wrong.

Shane, thanks for your videos as they are helping me a lot as I am new here. I am looking for a video where toggle buttons are used with SharePoint list. Do you have any plans of doing it?

Another great video, Shane! Do you have any advice for setting up filtering using SharePoint List columns? I have 2 filters and a display panel that are pulling from the same SharePoint list. I need one dropdown filter to set-up the next dropdown filter, and then this sets the form display. I initially was using lookups but that did not work out.

Hi Shane! Is it posible for the JobTitles dropdown to have a Default value of an blank option (empty string) that comes first and then the rest of the options, after we selected the department?

very useful and inspiring. Thanks shane.

Another great video solution. Thanks so much!

Hi Shane thank you for your great videos, they have been very helpful to me. Quick question please how would i achieve role based authentication in powerApps? i want to show/hide fields depending on what sharepoint group the user belongs to.

Thanks so much for such a valuable tutorial :)

Super useful! Really easy to follow. Thanks

Greate video! Do you have a video where show how combine dropdowns with another gallery? The idea is for example show all the jobtitles regarding IT department . Thanks

@Shane Young, have you tried reverse cascading. I was trying that on an App that I'm developing, where you can actually pick items from the bottom Combobox and the parent combobox (es) will be filled up for you.

Hello Shane, First of all thank you for all your videos! I got a question regarding the sort(distinct(sharepoint list data) function. It does work with my dropdown tool. But the data that I choose are not saved in the sharepoint list which is link to my powerapp. I don't know if I'm clear (hello from France) Thanks for your help

Hi Shane, I am learning Powerapps from your videos . Very helpful . Thank You,Much. I have a doudt from this video. Please tell me the use of Reload Icon when the excel which we use is having static data.We might not use it rt?

Shane Young, First congratulations on the video and didactics, secondly I apologize for my English, I am using translator. I ask, when I use cascading dropdown, what function do I use to submit? For example: SubmitForm (EDITFORM1) or needs to be another function.

This is really helpful..In this same scenario can we do it in reverse way. Like, If user selects the value from "Job Titles" dropdown it should show "Department" values..(It should work in both the ways).If possible please let us know

Hi Shane, thanks so much for your helpful tutorials. I'm new to the brave world of Powerapps but I've watched your video on creating custom sharepoint list forms and this one. I have adapted the form on our sharepoint library but am finding users have to a) click "see all" from the form right-hand side menu in sharepoint to get to the customised form and b) after filling it in and saving, the options selected from the drop down lists are not assigned to the files. I figure this might have something to do with sharepointintegration? but am struggling to find a way to fix it. Can you point me in the right direction?

Thank for your teaching, I try very hard to find this way >>>>> Thank again ;) Respect

Hi Shane, I am watching your videos from long time and I found it really helpful, could you please tell me how to set default value blank in dropdown in powerapps other than creating collection.

Great tutorial - I am looking for how the data is actually rendered on the page when using cascading dropdowns , I am using a datatable source which doesn't allow me to use 2-level drop-down filter