Creating cascading Dropdown in SharePoint with Power Apps (dependent) 

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

What a brilliant and clear instructional video!! Thanks

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

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

Thank you very much for posting this wisdom.

Thank you sir, You are a life saver.

Great explanation

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

So very useful!

Perfect, very nice.

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 = cb_main_activities.Selected.MainActivity)

Very well done. Thank you!

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!

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!

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

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

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

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

Love it!

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?

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.

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?

Hi teacher. I was able to follow your procedure and finish. Helped me a lot. But I am wanting to include a third dim table, and I am creating a new dropdown, and this dropdown will be filtered based on the result selection that is referring to the first dropdown linked to the first dim table. Summary A-One fat table B-One dim (to dropdown cascade) inside de powerapps form (done exactly as per your instructions. Success) C-Second dim (to dropdown cascade based on a dropdown created on result "B") I'm not getting. I believe it is some Parent configuration. But I have no idea. Could you help me if I send you a Video explaining it?

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

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.

for existed item I want to edit, so I need the already selected item and whenever I select above dropdown then 2nd dropdown should be empty and show the cascading items

Hi Alizera, i would like to add an extra column so i get 4 levels of cascading, is that even possible? Every filter of distinct i tried, i get error's.

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

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?

Hello Alireza, How to add hyperlink to Dropdown menu text in SharePoint with PowerApps

how to have 3 dropdowns instead of 2. how do you both distinkt AND filter ?

Hi Alireza :) My cascaded dropdown does not save data to the sharepoint list. The rest everything comes in my to sharepoint but not data from cascaded dropdowns. In app i can see data in the cascading dropdowns but it does not send it to the sharpoint list. 1 dropdown menu is called: Produkttype and formula is: Distinct('Data Source til Bestillingsliste', Produkttype) 2 dropdown is called: Produkt and it filters: Filter('Data Source til Bestillingsliste', Produkttype = Dropdown1.Selected.Result) could you please hlep? or anyone else? best regards Naji

Would you be able to do something similar with a choice combo box?

Dear master, possible to sync data from excel to another excel by power automate?