Create Cascading DropDown in SharePoint Online using PowerApps 

in case your Data is not getting saved then go to Data Card advance option and in the Update field change 'DataCardValue.Selected.Value' to 'DataCardValue.Selected.Result ' and you will be good to go.

I have searched countless ways to get cascading drop downs to work, but this is by far the best solution I have come across. Thank you for an excellent tutorial!

extremely helpful tutorial, always appreciate the content!

found your vid and it was explained simply and I got it.. I watched two ads for you. thanks! :)

Excellent video, just what i was looking for...thank you!!!

Thank you for the video. If we have more complicated data with lots of rows or multiple columns, do we need to build the Source List in a flat structure? i.e. we can't set any of the fields as Lookup in order for it to work? For example, if I have a list with Company Name, Staff First Name, Staff Surname, Staff Email etc. Would it be possible to just select Company Name, and then it will ONLY show the First Name, Surname and Email of staff members that work for that company and not other companies? Thanks a lot!

Thanks for the tutorial. Is there a way to use a SUBMIT button once a selection from the cascading menus have been chosen? Or how to write the selections as a record in a SharePoint list? Thank you

Thank you for this it helped me resolve issue with my dynamic form today!

Awesome, this helped. Thank you.

thanks a ton..simple and effective way of drop down cascading 😀

Thanks for this video. Is it possible to create a cascading dropdown on document sets? I want to have a cascading dropdown under the 'properties' settings.

Very nice tutorial. Nicely explained

Great tutorial, thanks!

Thank you for this, was easy to follow and replicate. Can you do this with the second option being multiple choice?

Thanks for this video helped me alot.....evrything is working...but once an item is created in the list am not able to edit it...when i select and click on edit it shows getting your data(only this msg is displayed) isn't allowing me to edit, should i do some configuration to edit an item

Would this cascading lookup fields be working in the grid view as well? Is there any available option to have it working there?

dropdown working fine and it saves data in my main list. No issue on that. However in power automate I cant find dynamic value for these columns, how to get that? I need the value to powerautomate email flow I need to send an email when new item is added by powerautomate but in dynamic content I can only see coloumn names as these are single line text. It returns a blank result in email output

Great example. Can this concept be applied to document library cascading metadata? or you have to use the Term Store to select values?

Very helpful.Thankyou!

Could my sharepoint admin be restricting what Control Types I have access to? When I edit my control type, I only see View selection and Edit selection. On your screen there are at least 6 items displayed: View text, View phone, View email, Edit Edit, edit multi-line text, Allowed Values and the others are out of view.

@Lernen thank you so much for the video its really helpful i have done everything but the data is not getting saved, as you mentioned in the comments i tried to go to datacard and advance option but where do i find update field to change it to 'DataCardValue.Selected.Result ' ?

Can you please suggest, how can i get the Selected Value for editing the existed item and when I select another dropdown value from above, i need below dropdown should empty

Hi, wanted to thank you for the video and I have a question: I've been trying to do the cascading menus with 3 different columns but I'm not having any luck. I have a lot of data and the third cascading menu just doesn't work and all the things I find online refer to two menus just like your video (which is the clearest I've seen so far), do you have some advice on how to do it?

Very nice tutorial.

Thank for the video :), in filter("source list", Region = DataCardvalue5.select.result) how i can add a distinct???

nice video. I wanted to create a 3 levels cascading dropdown, but when I change the control type of the 3rd field to "allowed value" i get an error un the formula..is it limited to just 2 levels?

I have similar requirement, But i have 2 lists, Agency and User. Agency contains list of all agencies and User has look up column agency and another column as user name. I am referring agency List lookup from agency List and user name column filtered based on agency selected. ( there can be zero or more users from one agency). This formula is not working in that case. Can you help me modify this as per my requirement,

The cascading dropdowns work great, except for the 2nd dropdown's value doesn't save to my main SP list.

Hello, Thank you for this tutorial, very helpful I tried to follow your steps for something else but not working, can we connect for few minutes Thank you Amjad

Thanks for this. What if the second selection is a "Person or Group" field? I've been trying it out but can't seem to make it work

Hi, it is great sharing video. I have completed the example. However, I tried to create an app from that DataList, why does the Region and Country field won't show as dropdown list ? Could you please assist to check it out?

Very helpful tutorial, but I noticed that after I followed the steps, Id get an error on the fields that I am creating cascading menus, which at the end, although working on the form, it would not load data into my SP list. I noticed that in your tutorial you got the same errors after connecting the fields to the data. How do you solve for this?

Thank you so much it helped me, i want to use ms flow generated from sharepoint list using power apps, but somehow when i create condtion in ms flow , it didnt read the value from the cascaded column even though it is shown in the sharepoint list. Do u have any advice?

Is it possible to embed this on the hole page?

nice video

Hello Lernen Tech, Cascading dropdown values are not visible for me once I publish the App but dropdown values are visible in edit mode. Why it's happening?

I tried this in a document library in sharepoint - and couldnt get it to work.

The video is correct up to the point of testing if this work. the presented did not press save. if he did, he would have known that the field default card settings are incorrect. now I need to go through comments to look for whats wrong.

Hi Lernen Tech, is it posible to make 2nd menu to multi choices.

Great video. I tried, everything worked, but ... how do I save the record? I make a choice, but choosing "save", but saves empty fields (Region and Country save, but only empty)

In my data i cannot see options related data under field it shows Add field but no option of region and country below..time : 1:50 Any help appreciate

I tried this but when I check on my list, data doesnt appear on.my main list

Why didn't you click save?

How do I change default values

Hi This doesn't work when we try to view records, values are not shown. Pls share steps which are missing.

Hi all! How could I go about selecting multiple Countries or Regions?