Creating cascading Dropdown in SharePoint with Power Apps (dependent)

In this video we create a cascading dropdown fields for a SharePoint list. In this video we convert Plain text fields to dropdown and make the two dropdown controls dependent in a way that selecting an item in one, filters items on the second one.

To enroll in my Udemy courses see below link for discount vouchers

This video contains:
- 0:00 Introduction
- 0:34 SharePoint initial setup
- 4:33 replacing the Text Input with a Dropdown inside Data Card
- 17:40 Enabling dependent dropdown fields
- 19:21 Using Combo box as a better replacement for cascading dropdown
- 29:15 Conclusion

Contact me

[felipesignorellireis]

OMG. You saved my life. I was struggling with the problem to make the form accept card change. I needed exactly what you explain. Thank you so much.

[peterdrysdale]

What a brilliant and clear instructional video!! Thanks

[nicolesm]

You legend. This was just what I needed. I've been looking for weeks. Love your Udemy lessons too.

[ashimishra]

Really liked your approach of explaining things. You made it look so simple for new learners like me... thanks a lot 😀👍

[ChrisLoyens]

Thank you very much for posting this wisdom.

[dhangschannelnd]

this is very helpful thanks for the brilliant idea I can use this as my reference on creating Cascading dropdown on my organization.

[nitinrajput]

Thanks. Could you please prepare a quick video on Model Driven PowerApp as well for just a simple Country and State scenario? Or guide on any similar tutorial for it. I am interested in joining your course on Udemy as well if this topic is available there. Please help! Thank you so much!

[AfsalEravakkad]

Hello sir, first of all i would like to thank you for this video which helped me create a form which has multiple CBs depending on others. THANK YOU. Right now i'm stuck at one thing where the combo box has duplicates and i'm not able to apply DISTINCT function since its already using FILTER function. /// Formula in ITEMS -> Filter('List-activities', MainActivity =

[wfwojey]

Awesome tutorial but for some reason the cascading fields don't clear upon clicking the New button. Tried a few reset-type formulas, to no avail - thanks!

[jsncyf]

Thank you so much for the help! this has worked great. Is there a way you can do the same Cascading drop down, but allowing you to select more than one choice on the (dependent Dropdown), or the second drop down that depends on the first selection?

[artgraphixwebandmore]

Hello, thx for this very good video, i have only the problem that i can update the data from the dropboxes, but when i reopen the data record the dropdown has other values not the record data. it seems that the dropdown dont get the real data to the dropboxes. do you have a tip for me? Greetings from DE

[Gabbyo]

Great lecture, It's awesome and I'd like to a crash course on Power Apps with you

[Excel-power-users]

Hello Ali, Both the approaches are superb, but in prefer the first approach since it is very easy for the end user to use without any help. The problem where I am facing is that the second dropdown is showing the complete list of. Is there any restriction in the dropdown that not more then this count will be shown.

[MahsaGharecheloo]

Hello Ali, and many thanks for your videos, I tried this cascading dropdown menu for my sharepoint list and I need to let it open for multiple choice, but when I save it only save one Item, what can I do for that? thanks in advance for your help

[wfwojey]

Great tutorial - thank you! Question, while I see the dropdowns in the SPO form and it behaves as expected, I'm not seeing any dropdown items when I'm in the 'Edit in grid view'. Is this normal behavior or is something wrong on my end?

[ucetin]

Ich hab im Powerapp gleich gemacht, in Powerapp funktioniert auch, es übernimmt aber die Auswahl Möglichkeit nicht in Sharepointlist

[williamchamorro]

what would be different if it were a Library instead of a list ?

[asmr_anah]

does the excel have to have the cascading table before you import it into sharepoint or do you just need a list of the items?

[Bsquared]

Thanks. I have followed these instructions and achieved adding a cascading dropdown field. There is one problem, though. The data from the DDL is entered and stored and viewable in the regular SharePoint view. But when the Power Apps form is reopened to edit, the cascading dropdown field looks empty, even though the data has not been lost. Any advice is appreciated.

[sinsonfrancis]

Hi, it really helped, thanks for the video. Also would like to know how to bring these cascade dropdown into bulk edit window of Sharepoint? Any thoughts