@@dlucci43 I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, Thanks for this wonderful video. Can you share video on cascading between dropdown and people picker field? Where on click from 1st Drop Down(Department), the people picker field(Managers Name) will cascade its options. Source is SharePoint list. I tried but unable to build connection between Active Directory.
Thank you! Thank you! Thank you!!!! I got this to work with the patch function! It's my first power apps form!! I'm a beginner! This video is amazing. I cannot thank you enough.
I spent literally HOURS trying to make this work with "modern" drop-down controls and finally gave up, watched this video, and got it to work with Classic drop-down. Thank you.
Reza thank you so much for providing these instructional videos. They are very informative and helpful. Your presentation style is easy to follow and understand.👍
Nice video, Reza Sir. Was looking for this subject, and there you are with a wonderful explanation. May you have a wonderful year ahead. Keep educating.
Thanks Reza, clearly explained as always. Just as some extra info: cascading dropdowns are not supported when Dataverse is the data source. It works in some cases but can give some unexpected behavior.
It should work with Dataverse also. If there are issues, I would recommend posting it on the forums at powerusers.microsoft.com/ to cross check if others are facing a similar issue.
The first lesson of 2022. Great Information. Learn by Reza, do by Reza, and be happy😊 Thank you so much Reza, and wish you a healthy and successful happy new year.
Your explanations are crystal clear - like always. Great thanks for all your fantastic videos. I was able to reproduce all the steps with a blank power app. And it works perfectly. It also works (kind of) with a customized edit form for one of my Sharepoint lists. But for the past couple of hours I fail to fix the problem, that all entries in the drop-down control are "invisible" (no text displayed). The selected value from a drop-down is correctly saved to the Sharepoint list though. Has anyone ever experienced this problem?
I found the answer to my problem: In my power app settings I switched to the modern controls. These apparently do not fit to the steps described in this video. But I can switch back and forth to classic and modern controls, whatever I need to add to my form. And then everything works like a charm. Thanks again to Reza for these excellent videos.
@@anjaniniranjan4574 I have explained outline of multi select in there. I do not have a specific video reference on your scenario. I will recommend checking on forums at powerusers.microsoft.com
Multiple lists in single dropdown would require to first combine data into a collection. I do not have a video on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza. As always, great video! I have two questions: 1 - Do I (as the developer) need premium license for the Dataverse option? 2 - If so, do the users need premium license to use the app I develop with Dataverse?
Thanks Reaz, Very helpful. One question I had was can we make the cascading drop-down combo box as multi-select? I have a situation where the first drop down is single select and the options in the second dropdown should cascade based on first drop-down. Additionally the user should be able to select multiple options from the combo box. When I tried this, only the last selected choice is transferred to the Sharepoint on submitting the form and not the others.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Thank you very much. This is extermely helpful. I am facing one issue. After submiting the selected dropdown options, it saves into the database (i.e. another sharepoint list), but if I make a change in the options name in the master list (e.g. let's say I misspell the state name of 'Deelhi' and correct this to ''Delhi'). This correction does not automatically update on the previously submitted items in the database where 'Deelhi' was saves, and those fields start appearing blank.
Most welcome! I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorraniHi Reza, Just want to add a bit more explanation to my previous query. In your video, at 16:30, the records saved successfully. Now, I want to change the Miami spell to Miammi in the dropdown sharepoint list but it is not automatically updating in the gallery view (output sharepoint list). Can you suggest a solution please? Thanks
@@bhup3190 I have not come across this scenario or issue. I can only suggest if I try out your use case to know more. Best place to post issues/queries is the forums
You would need to use a combo box control with multiple selection turned on. But subsequent cascading logic would become complex and run into delegation issues.
excellent video. have one question to you. how we can achieve the same in power pages? have one api want to call that in power pages and bind that data in a drop down. how it is possible in power pages ?
Thanks. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Great work! Could you please explain how to do this with Multiple selection combo boxes? Example you would select two countries in the first field and you could select 2 states from the second which would give you the cities list ----> all fields with multiple selections? When I try to do this the second combo box only lists the last states based on the last selected country from the first box ie: I select USA and Canada the second box only lists states from Canada
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Hi Reza, Your other video (Multi Select Filters in Power Apps) gave me the answer on the second combo box: Filter(Cascadinglist, Countries in DataCardValue5.SelectedItems) Have a great day!
Hi! Thanks for this great tutorial! I have an issue right from the start, for the value field of the item, I only have the option to select "value", I can't seem to get the "result" option. What am I doing wrong? Thanks!
Nicely explained video. In other scenarios like my data source is now a collection which is fetching the details of a sharepoint list items. If I want to add a dropdown function in which I have to pull a column from my save collection of sharepoint list. This column is having data as datatable. In this scenario how can we have the column items listed under dropdown? Can you make one video which explains this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I make videos when I receive a lot of requests on a particular topic. This is the first request on this topic. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza, the video was much helpful. Is it possible to enter a manual item in the cascaded dropdown. I have a dropdown choice as other and when it is selected I want to enter the values manually in the same dropdown box. Is it possible.
It is possible but there is no out of the box feature for that. It would involve a decent amount of work. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
The combo box control search feature is what gives that delegation warning. In most cases, your 3rd level dropdown would have less than 2k records. If you use a dropdown control for city, you will not get the delegation warning.
Thank you RD for posting cascading dropdown video. Is it possible to achieve the same using the value from checkbox control. say I have checkbox1, checkbox2, checkbox3, and a text box which has value . Depending upon the value selected in checkbox the value in my dropdown should be listed. If you have posted any video around this can you share me the link. Again thank you so much for all your powerApps video. It is very helpful.
Possible but I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza for amazing videos. As a new user, it has been a great help. All the best. I also have a query, In My case, I am only using Title, Country and state, when I submit (Patching cascading), It only saves Title and Country in the Information list. State is left blank. Could you guide?
Most welcome! I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza, Thank you for sharing the great video, I have one issue in my app, I have just attached a second list to my app for columns Config_Item, Support group, and assigned to I have cascaded all three columns. Also want to inform you the same column is present in my first list which is already attached, I just want to update my first list once the form submitted with these columns which is connected to second list ,I could not understand how to do this, please help
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey! thank you for your video, it helped me a lot. I have a question. I was following you with the steps but in the second DropDown I analyze the created table and it's correct but the items don't appear in the DropDown values. I was wondering if you could help me to configure that pleasee. Thank youuu
Thank you Reza. Couldn't thank you enough. A quick question for you, I have a SharePoint list with over 5K distinct values and the distinct function is non delegable. What is the alternative for returning all unique values where SharePoint is the data storage, single line data type and large set of data?
Another great video, Thank you Raza. Is it possible to create a dropdown list that doesn't repeat (display) selected items, and reset after all the items were selected?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello, You are making great videos and very helpful. I got a requests many time, Would you be able to create video for Cascading Combo Box (Multi Selections for Region, Country, State). It would help many users . I see a lot of requests or tickets online but no one is able to solve or respond it to those ticket.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Is there a way to search a drop down box? I have over 300 medications that I have to scroll thru in my drop down. Thank you for great videos and sharing your knowledge.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Great video... Good Job. Thank you very much. Question: What to do If I have two drop down lists with Employee ID & Employee Name and when I select Employee ID the "Employee Name" should be displayed accordingly.
Depends on how the data from dropdowns is being stored in your backend system. I will have to look at your scenario in action to provide guidance. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, thanks for the videos. I have built a fully functional app using your videos. However, I am struggling a bit here. There are instances where either the comb box or the drop-down input does not have a 'depends on' option, neither can I see 'allowemptysection' nor is the update option working with both Value and Result. I am using a 'table' as my primary data collection point and and excel file for the static drop down values.
Great video. Question.. how can I have the cascading drop downs reset to blank outside of the form control once someone hits submit? Everything I’m finding online only works in a form experience.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video, is cascading dropdowns possible in SharePoint without PowerApps as the form? Through json formatting perhaps and is there any resources on it?
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for this video, Reza. It was very useful. I’m customizing a SP form in PowerApps. Within this form, I need 3 cascading dropdowns. I had to create a custom card and add a drop down to it for these cascading drop downs because the form is very long and text label kept floating up and down the page as I scrolled. I created the cascading drop downs successfully and they appear on the form, but the selections will not save to the form. I’m sure it’s because the data source for the dropdowns is from a separate SP list. However, I don’t want to create a separate record for these drop downs. I want to save the information on the same record as all of the other information on the form so within the same record. Can you advise? I greatly appreciate your help!
I do not have a specific video reference on the method you are trying to use. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great Video! I am trying to achieve a step further. Is there a way that I select the 'State' and 'Country' field defaults automatically to the right option. Power app is throwing me 'Circular Reference' error. Any ideas how to achieve this?
Thanks! Possible to do that but not something I have tried. Circular reference error typically means some value that is dependent on a value being set by same control. I would recommend posting your issue on forums at powerusers.microsoft.com
This is great, thank you so much... Just one more question: is it possible to create cascading DD of the datasource columns are complex e.g. People or Choice?
@@RezaDorrani so I’ve got 3 columns: Title( which I use for document name), Project name(choice column from other list) and Project Manger column which is People column…. Can I do cascading Dropdown list based on the selection of the Project manager first and then filtering Projects for that Manager?
@@karolinaunderwood1039 This is something I would have to try out to know it’s feasibility. I will recommend posting your query on forums at powerusers.microsoft.com
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Amazing Explanation, Thank you Reza. It helped me to create the same logic using combo Box. But Unfortunately when I select 2 Countries, the second Combo Box shows only the states of the second country. What I'd like to have is when I select 2 countries, I want to have the states of the 2 countries. Is there any solution for that?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi @Reza, Thank you so much for this video. One additional query I have here: Is it possible to achieve this in a LookUp fields. e.g. In particular this case - how to achieve this if Country and State would be LookUp fields?
Distinct is not a delegable function and there is no way around it. An option would be to restructure the cascading list. Create a list of countries. Then create your cascading data list by looking up the countries (Lookup column).
![How to create a dependent cascading Drop Down, Combo Box controls in Power Apps [Patch]](http://i.ytimg.com/vi/tunWOyPcXks/mqdefault.jpg)
A recent update was made in Power Apps where "Result" is now "Value". Concept showcased in video works the same. Simply replace "Result" with "Value"
tq
Thank you!
Hi Reza, Great Video! Is there an additional step to create Multi Select Dependent Cascading Dropdown?
@@dlucci43 I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, Thanks for this wonderful video. Can you share video on cascading between dropdown and people picker field? Where on click from 1st Drop Down(Department), the people picker field(Managers Name) will cascade its options. Source is SharePoint list. I tried but unable to build connection between Active Directory.
Best 17:20 I've spent all week. This tutorial was exactly what I needed. Thanks Reza!
Wow! Thanks so much for watching
Thank you, Reza. Your work is extremely important for everyone out there learning Power Apps development from scratch. Thumbs up!
100% Agree!
Thank you! Thank you! Thank you!!!! I got this to work with the patch function! It's my first power apps form!! I'm a beginner! This video is amazing. I cannot thank you enough.
You're most welcome!
I spent literally HOURS trying to make this work with "modern" drop-down controls and finally gave up, watched this video, and got it to work with Classic drop-down. Thank you.
Most welcome!
Check this also th-cam.com/video/TrjIsY9UIGA/w-d-xo.htmlsi=jhFDMTjPqTWOa6D-
I can't get tired of saying this: Thank you! So helpful, clear and concise. Great success awaits you, Reza,
You're so welcome!
Thanks!
Wow! Thanks so much.
@@RezaDorrani You're welcome. Your channel is a life saver. Thank you for all that you do 🙂
@@dianezpilon2805 Most welcome
Thank you! wish you and your loved one's a healthy and prosperous year.
Thanks Pawan! Wish you the same.
This was exactly what I was wondering about but didn't know what to search for. Thank you once again!
Great! Thanks for watching.
Thanks
Thank You
how many days i struggled with that! and solution was right here! thank you @Reza, you are the one and only.
Glad to hear that! Thanks for watching and liking the video.
Thank you Reza, it’s all a pleasure to start the new year with your knowledge sharing. I hope you the best for 2022!
Thank You & Happy New Year!
Thank you Reza, you always bail us out! regards!
Happy to help!
Happy new year and Thanks for Useful video ...!
Happy New Year & thanks for liking the video.
Nice video and explanation, helped a ton, thanks for sharing Reza!
Your most welcome!
Clear and concise. Thanks, Reza and Happy New Year.
Thanks Sani.
Wish you a Happy New Year.
Reza thank you so much for providing these instructional videos. They are very informative and helpful. Your presentation style is easy to follow and understand.👍
Thank You for the awesome feedback. Much appreciated!
Thank you Reza, again you helped me fix something that I overlooked (Depends On)!
Really Awesome Example. I need to duplicate to completely grasp your great explanation.
Glad you liked it
Perfect , it is easy and to the point . thank you so much.
You're most welcome!
Excellent, quick, and to the point. Thanks for making these.
Thank You so much
This video is very informative! Thank you!
You are so welcome!
Happy new year Reza. Another knowledge gained
Thanks 🙏
This is very useful information. Explained extremely well. Thank you for sharing your knowledge!
You're very welcome!
Happy New Year Reza and your Family. Thank you for this great video!
Thanks Yuji. Wish you & your family a Happy New Year!
Nice video, Reza Sir. Was looking for this subject, and there you are with a wonderful explanation. May you have a wonderful year ahead. Keep educating.
Thanks Vishal & Happy New Year!
Awesome tutorial, all the important details are here
Thank You!
Finally!! I found the way to do it. Thank you Reza .
Thanks for the your knowledge sharing as always. Clean and concise. Happy new year, Sir.
Thanks & Happy New Year!
Thanks Reza, happy new year.
Happy new year!
Man... This is fantastic... Thanks!
Thanks so much for watching
Useful content Reza, thanks.
Glad you think so!
Thanks Reza, clearly explained as always. Just as some extra info: cascading dropdowns are not supported when Dataverse is the data source. It works in some cases but can give some unexpected behavior.
It should work with Dataverse also.
If there are issues, I would recommend posting it on the forums at powerusers.microsoft.com/ to cross check if others are facing a similar issue.
Great tutorial, Thanks for sharing.
Glad you liked it
The first lesson of 2022. Great Information. Learn by Reza, do by Reza, and be happy😊 Thank you so much Reza, and wish you a healthy and successful happy new year.
Thank You and wish you the same.
Well presented and much appreciated about this great tutorial 🙏🏽
Thanks for watching!
Your explanations are crystal clear - like always. Great thanks for all your fantastic videos. I was able to reproduce all the steps with a blank power app. And it works perfectly. It also works (kind of) with a customized edit form for one of my Sharepoint lists. But for the past couple of hours I fail to fix the problem, that all entries in the drop-down control are "invisible" (no text displayed). The selected value from a drop-down is correctly saved to the Sharepoint list though. Has anyone ever experienced this problem?
Thanks for watching and liking the videos.
I have not experienced the mentioned issue, hence not sure.
I found the answer to my problem: In my power app settings I switched to the modern controls. These apparently do not fit to the steps described in this video. But I can switch back and forth to classic and modern controls, whatever I need to add to my form. And then everything works like a charm. Thanks again to Reza for these excellent videos.
Great video as always.. Thanks Reza..
Thanks for watching
Hi Reza, Thanks for your videos keep doing.
Thank you, I will keep trying my best!
Thank you very much Sir!
Most welcome!
sir great function well done.
Thank You
Thank you, Reza!!!!
You are most welcome
Thanks for sharing and 🎄Happy New Year 2022🎄
Thanks Moyura and Happy New Year.
Thanks alot ma man!
Most welcome
Wish you very happy new year 🥳 Rezza
Same to you :)
Thank you Reza for explanation, could you please share details if we have multiselect city column. How to patch it?
Patch function - th-cam.com/video/g9ChYuTdNd4/w-d-xo.html
@@RezaDorrani in recommended video, column 'class' is single selection lookup column, any help for multiple selection lookup column
@@anjaniniranjan4574 I have explained outline of multi select in there. I do not have a specific video reference on your scenario. I will recommend checking on forums at powerusers.microsoft.com
Thankyou for this Reza, i had a doubt how to add multiple lists in dropdown and display form for respective list selected from dropdown
Multiple lists in single dropdown would require to first combine data into a collection.
I do not have a video on this scenario.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Happy New Year Reza 💥💥👍👍
Happy new year!
Thankyou so much sir
Your most welcome
Thank you Reza. As always, great video! I have two questions: 1 - Do I (as the developer) need premium license for the Dataverse option? 2 - If so, do the users need premium license to use the app I develop with Dataverse?
All users will need a premium license that use Dataverse
Thanks reza...
👍
Awesome!
Thank you! Cheers!
thank you sir
You’re most welcome
Very good
Thanks
Thank you Reza
Your most welcome
Thanks Reaz, Very helpful. One question I had was can we make the cascading drop-down combo box as multi-select?
I have a situation where the first drop down is single select and the options in the second dropdown should cascade based on first drop-down. Additionally the user should be able to select multiple options from the combo box. When I tried this, only the last selected choice is transferred to the Sharepoint on submitting the form and not the others.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Thank you very much. This is extermely helpful. I am facing one issue. After submiting the selected dropdown options, it saves into the database (i.e. another sharepoint list), but if I make a change in the options name in the master list (e.g. let's say I misspell the state name of 'Deelhi' and correct this to ''Delhi'). This correction does not automatically update on the previously submitted items in the database where 'Deelhi' was saves, and those fields start appearing blank.
Most welcome!
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorraniHi Reza, Just want to add a bit more explanation to my previous query. In your video, at 16:30, the records saved successfully. Now, I want to change the Miami spell to Miammi in the dropdown sharepoint list but it is not automatically updating in the gallery view (output sharepoint list). Can you suggest a solution please? Thanks
@@bhup3190 I have not come across this scenario or issue. I can only suggest if I try out your use case to know more. Best place to post issues/queries is the forums
Hi Reza, Thank you for this great video, for the city, how we can enable the multiple-choices?
You would need to use a combo box control with multiple selection turned on.
But subsequent cascading logic would become complex and run into delegation issues.
excellent video. have one question to you. how we can achieve the same in power pages? have one api want to call that in power pages and bind that data in a drop down. how it is possible in power pages ?
I have done no work with power pages.
I recommend posting your query on forums at powerusers.microsoft.com
Thx! muchas gracias 🎉
Most welcome
Love the Demo. My Country and State don't update on a new item. Any ideas?
Thanks.
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Great work! Could you please explain how to do this with Multiple selection combo boxes? Example you would select two countries in the first field and you could select 2 states from the second which would give you the cities list ----> all fields with multiple selections? When I try to do this the second combo box only lists the last states based on the last selected country from the first box ie: I select USA and Canada the second box only lists states from Canada
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Hi Reza, Your other video (Multi Select Filters in Power Apps) gave me the answer on the second combo box:
Filter(Cascadinglist, Countries in DataCardValue5.SelectedItems)
Have a great day!
Hi! Thanks for this great tutorial! I have an issue right from the start, for the value field of the item, I only have the option to select "value", I can't seem to get the "result" option. What am I doing wrong? Thanks!
Nothing. I believe Result has changed to Value now for distinct function.
@@RezaDorrani Thank you! I gave it another shot and it's working perfectly!
Nicely explained video. In other scenarios like my data source is now a collection which is fetching the details of a sharepoint list items. If I want to add a dropdown function in which I have to pull a column from my save collection of sharepoint list. This column is having data as datatable. In this scenario how can we have the column items listed under dropdown? Can you make one video which explains this.
I do not have a video reference on this scenario and would have to try it out to provide guidance.
I make videos when I receive a lot of requests on a particular topic. This is the first request on this topic.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza, the video was much helpful. Is it possible to enter a manual item in the cascaded dropdown. I have a dropdown choice as other and when it is selected I want to enter the values manually in the same dropdown box. Is it possible.
It is possible but there is no out of the box feature for that. It would involve a decent amount of work. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Firstly, thanks for the video.. Very useful.. Does DISTINCT only work with Title column from SharePoint.. Thanks
Distinct works with simple column types like text.
@@RezaDorrani Thanks for clarity
Thank you
👍
Do you have a video showing how dropdown option is filtered to show only for the current user?
No
Happy New year ... Here I believe the City field is showing delegation warning.. could you please check that ?
The combo box control search feature is what gives that delegation warning.
In most cases, your 3rd level dropdown would have less than 2k records.
If you use a dropdown control for city, you will not get the delegation warning.
@@RezaDorrani Thank you..Got it
Thank you RD for posting cascading dropdown video. Is it possible to achieve the same using the value from checkbox control. say I have checkbox1, checkbox2, checkbox3, and a text box which has value . Depending upon the value selected in checkbox the value in my dropdown should be listed. If you have posted any video around this can you share me the link. Again thank you so much for all your powerApps video. It is very helpful.
Possible but I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza for amazing videos. As a new user, it has been a great help. All the best.
I also have a query, In My case, I am only using Title, Country and state, when I submit (Patching cascading), It only saves Title and Country in the Information list. State is left blank. Could you guide?
Most welcome!
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorraniSure Thank you.
Hello Reza,
Thank you for sharing the great video, I have one issue in my app, I have just attached a second list to my app for columns Config_Item, Support group, and assigned to I have cascaded all three columns. Also want to inform you the same column is present in my first list which is already attached, I just want to update my first list once the form submitted with these columns which is connected to second list ,I could not understand how to do this, please help
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey! thank you for your video, it helped me a lot. I have a question. I was following you with the steps but in the second DropDown I analyze the created table and it's correct but the items don't appear in the DropDown values. I was wondering if you could help me to configure that pleasee. Thank youuu
I will have to see your app in action to provide guidance. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi, Reza.. can you please share the dependent dropdown formula with the hidden column.
Does the video not show the formula?
Thank you Reza. Couldn't thank you enough. A quick question for you, I have a SharePoint list with over 5K distinct values and the distinct function is non delegable. What is the alternative for returning all unique values where SharePoint is the data storage, single line data type and large set of data?
Probably sharepoint is not a good data source for your scenario. You could try using flow.
@@RezaDorrani Thank you. I will look into that. I appreciate your reply.
Another great video, Thank you Raza. Is it possible to create a dropdown list that doesn't repeat (display) selected items, and reset after all the items were selected?
You could use Distinct function to not repeat selected items.
Hi Reza, Thanks for your videos, do you have one that explains the cascading multi-select combo box?
I do not have one with cascading combo boxes
Great video! but when I filter dropdown2 based on dropdown1 the dropdown2 is coming empty, can you tell what it can be?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How do I import Power BI table data into a dropdown on Power Apps? Your help will be awesome.
Check my videos on power bi and power apps.
Hello, You are making great videos and very helpful. I got a requests many time, Would you be able to create video for Cascading Combo Box (Multi Selections for Region, Country, State). It would help many users . I see a lot of requests or tickets online but no one is able to solve or respond it to those ticket.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Is there a way to search a drop down box? I have over 300 medications that I have to scroll thru in my drop down. Thank you for great videos and sharing your knowledge.
Drop down does not have a search option.
Combo box has but it has limits as well.
Check th-cam.com/video/zPM0Q53L3sE/w-d-xo.htmlsi=cAy29ap1pIRee_7b
Can you please create similar video for cascading dropdown using modern controls?
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Great video... Good Job.
Thank you very much.
Question: What to do If I have two drop down lists with Employee ID & Employee Name and when I select Employee ID the "Employee Name" should be displayed accordingly.
Depends on how the data from dropdowns is being stored in your backend system.
I will have to look at your scenario in action to provide guidance.
I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thank you once again, with first solution and patch formula, what's the best way to clear the form after patch? thank you!
Reset the controls using Reset formula.
Hello Reza, thanks for the videos. I have built a fully functional app using your videos. However, I am struggling a bit here. There are instances where either the comb box or the drop-down input does not have a 'depends on' option, neither can I see 'allowemptysection' nor is the update option working with both Value and Result. I am using a 'table' as my primary data collection point and and excel file for the static drop down values.
Depends on wether you are using modern or classic controls. I recently did a new video on cascading using modern controls.
@@RezaDorrani Thank you
Great video. Question.. how can I have the cascading drop downs reset to blank outside of the form control once someone hits submit? Everything I’m finding online only works in a form experience.
You should be able to use the reset function on controls. I did 2-3 videos on cascading in which I may have covered scenario outside forms.
Hi, How about cascading person for example to assigned person for selected Task. Please let me know if you have any video about that. Thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hello,
Is there a way how return two values via disctinc function?
I'm not aware how to do that
Great Content Reza! Is it possible to build cascading drop downs / combo box controls using modern controls?
Should be possible
Great video, is cascading dropdowns possible in SharePoint without PowerApps as the form? Through json formatting perhaps and is there any resources on it?
Not with JSON formatting.
Thank you, Reza! May I ask how to fix if the Dropdown Properties Value only has Value, Result is not available.
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, any video you have for SQL Database for Cascading dropdown. Much appreciated.
I do not
Thank you for this video, Reza. It was very useful. I’m customizing a SP form in PowerApps. Within this form, I need 3 cascading dropdowns. I had to create a custom card and add a drop down to it for these cascading drop downs because the form is very long and text label kept floating up and down the page as I scrolled. I created the cascading drop downs successfully and they appear on the form, but the selections will not save to the form. I’m sure it’s because the data source for the dropdowns is from a separate SP list. However, I don’t want to create a separate record for these drop downs. I want to save the information on the same record as all of the other information on the form so within the same record. Can you advise? I greatly appreciate your help!
I do not have a specific video reference on the method you are trying to use. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi @karidoyle559, I've the same issue! Did you manage to solve it?
Great Video! I am trying to achieve a step further. Is there a way that I select the 'State' and 'Country' field defaults automatically to the right option. Power app is throwing me 'Circular Reference' error.
Any ideas how to achieve this?
Thanks!
Possible to do that but not something I have tried. Circular reference error typically means some value that is dependent on a value being set by same control.
I would recommend posting your issue on forums at powerusers.microsoft.com
This is great, thank you so much... Just one more question: is it possible to create cascading DD of the datasource columns are complex e.g. People or Choice?
Depends on how your data is structured. Could be possible.
@@RezaDorrani so I’ve got 3 columns: Title( which I use for document name), Project name(choice column from other list) and Project Manger column which is People column…. Can I do cascading Dropdown list based on the selection of the Project manager first and then filtering Projects for that Manager?
@@karolinaunderwood1039 This is something I would have to try out to know it’s feasibility. I will recommend posting your query on forums at powerusers.microsoft.com
Thanks Reza,
Can you please help for the same when drop-down populated with sql server column ?
I do not have a video reference for sql. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Please make cascading dropdown video with Dataverse table as well
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Amazing Explanation, Thank you Reza. It helped me to create the same logic using combo Box. But Unfortunately when I select 2 Countries, the second Combo Box shows only the states of the second country. What I'd like to have is when I select 2 countries, I want to have the states of the 2 countries. Is there any solution for that?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi @Reza, Thank you so much for this video.
One additional query I have here: Is it possible to achieve this in a LookUp fields. e.g. In particular this case - how to achieve this if Country and State would be LookUp fields?
Maybe I showed lookup in this video th-cam.com/video/IWEQwGLcW7Q/w-d-xo.html
@@RezaDorrani Thank you for this very quick response.
Hi Reza, can you please provide some more information regarding delegation for distinct function
Distinct is not a delegable function and there is no way around it.
An option would be to restructure the cascading list.
Create a list of countries.
Then create your cascading data list by looking up the countries (Lookup column).