How to create Cascading (Dependent) Dropdowns in Power Apps

  Рет қаралды 178,058

Reza Dorrani

Reza Dorrani

Күн бұрын

Пікірлер: 484
@RezaDorrani
@RezaDorrani Жыл бұрын
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"
@nurulsyazana5070
@nurulsyazana5070 Жыл бұрын
tq
@labelleza7065
@labelleza7065 Жыл бұрын
Thank you!
@dlucci43
@dlucci43 Жыл бұрын
Hi Reza, Great Video! Is there an additional step to create Multi Select Dependent Cascading Dropdown?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@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
@subhadas9852
@subhadas9852 Жыл бұрын
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.
@tmccann887
@tmccann887 10 ай бұрын
Best 17:20 I've spent all week. This tutorial was exactly what I needed. Thanks Reza!
@RezaDorrani
@RezaDorrani 10 ай бұрын
Wow! Thanks so much for watching
@anastasianikolovski8337
@anastasianikolovski8337 2 жыл бұрын
Thank you, Reza. Your work is extremely important for everyone out there learning Power Apps development from scratch. Thumbs up!
@ivsbanks
@ivsbanks Жыл бұрын
100% Agree!
@moniso2277
@moniso2277 2 жыл бұрын
I can't get tired of saying this: Thank you! So helpful, clear and concise. Great success awaits you, Reza,
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You're so welcome!
@dianezpilon2805
@dianezpilon2805 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
You're most welcome!
@esterraful
@esterraful Жыл бұрын
how many days i struggled with that! and solution was right here! thank you @Reza, you are the one and only.
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad to hear that! Thanks for watching and liking the video.
@pawanmishra6549
@pawanmishra6549 2 жыл бұрын
Thank you! wish you and your loved one's a healthy and prosperous year.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Pawan! Wish you the same.
@peterhober5681
@peterhober5681 2 жыл бұрын
This was exactly what I was wondering about but didn't know what to search for. Thank you once again!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Great! Thanks for watching.
@tristangeoffroy9286
@tristangeoffroy9286 2 жыл бұрын
Thank you Reza, it’s all a pleasure to start the new year with your knowledge sharing. I hope you the best for 2022!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You & Happy New Year!
@sjwimmel
@sjwimmel 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@akashkaushik3267
@akashkaushik3267 2 жыл бұрын
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.👍
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You for the awesome feedback. Much appreciated!
@joelcaro691
@joelcaro691 2 жыл бұрын
Thank you Reza, you always bail us out! regards!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Happy to help!
@StephanOnisick
@StephanOnisick 2 жыл бұрын
Really Awesome Example. I need to duplicate to completely grasp your great explanation.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Glad you liked it
@vishaljhaveri7565
@vishaljhaveri7565 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Vishal & Happy New Year!
@zakw3637
@zakw3637 2 жыл бұрын
Excellent, quick, and to the point. Thanks for making these.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You so much
@necdetsaritas8722
@necdetsaritas8722 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You and wish you the same.
@rajasekar5069
@rajasekar5069 2 жыл бұрын
Happy new year and Thanks for Useful video ...!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Happy New Year & thanks for liking the video.
@sueamin2788
@sueamin2788 2 жыл бұрын
This is very useful information. Explained extremely well. Thank you for sharing your knowledge!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You're very welcome!
@OpusMagnoCards
@OpusMagnoCards 2 жыл бұрын
Nice video and explanation, helped a ton, thanks for sharing Reza!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Your most welcome!
@SaniGarba
@SaniGarba 2 жыл бұрын
Clear and concise. Thanks, Reza and Happy New Year.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Sani. Wish you a Happy New Year.
@SurachetNakvichien
@SurachetNakvichien 10 ай бұрын
Finally!! I found the way to do it. Thank you Reza .
@zmbman1122
@zmbman1122 2 жыл бұрын
Happy New Year Reza and your Family. Thank you for this great video!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Yuji. Wish you & your family a Happy New Year!
@gerryscat
@gerryscat 2 жыл бұрын
Awesome tutorial, all the important details are here
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You!
@nabiledelbi5502
@nabiledelbi5502 19 күн бұрын
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?
@RezaDorrani
@RezaDorrani 19 күн бұрын
Thanks for watching and liking the videos. I have not experienced the mentioned issue, hence not sure.
@nabiledelbi5502
@nabiledelbi5502 19 күн бұрын
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.
@mohameddomairy3327
@mohameddomairy3327 Жыл бұрын
Perfect , it is easy and to the point . thank you so much.
@RezaDorrani
@RezaDorrani Жыл бұрын
You're most welcome!
@oluwatobiyusuf
@oluwatobiyusuf 2 жыл бұрын
Happy new year Reza. Another knowledge gained
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks 🙏
@kavitacherian3167
@kavitacherian3167 2 жыл бұрын
This video is very informative! Thank you!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You are so welcome!
@dianezpilon2805
@dianezpilon2805 Жыл бұрын
Thanks!
@RezaDorrani
@RezaDorrani Жыл бұрын
Wow! Thanks so much.
@dianezpilon2805
@dianezpilon2805 Жыл бұрын
@@RezaDorrani You're welcome. Your channel is a life saver. Thank you for all that you do 🙂
@RezaDorrani
@RezaDorrani Жыл бұрын
@@dianezpilon2805 Most welcome
@god_hacker581
@god_hacker581 2 жыл бұрын
Thanks for the your knowledge sharing as always. Clean and concise. Happy new year, Sir.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks & Happy New Year!
@merdwerkz
@merdwerkz Жыл бұрын
Man... This is fantastic... Thanks!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks so much for watching
@edilturdumambetov389
@edilturdumambetov389 Жыл бұрын
Useful content Reza, thanks.
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad you think so!
@Thor_Underdunk_Caballerial
@Thor_Underdunk_Caballerial Жыл бұрын
Great tutorial, Thanks for sharing.
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad you liked it
@ECERaagulLD
@ECERaagulLD 2 жыл бұрын
Hi Reza, Thanks for your videos keep doing.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank you, I will keep trying my best!
@aderibigbeadeyinka7136
@aderibigbeadeyinka7136 2 жыл бұрын
Thanks Reza, happy new year.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Happy new year!
@causaposer
@causaposer 2 жыл бұрын
Great video as always.. Thanks Reza..
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks for watching
@POWERAPP-z1w
@POWERAPP-z1w 9 ай бұрын
Thanks
@RezaDorrani
@RezaDorrani 9 ай бұрын
Thank You
@gauravsiyal3256
@gauravsiyal3256 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@anjaniniranjan4574
@anjaniniranjan4574 2 жыл бұрын
Thank you Reza for explanation, could you please share details if we have multiselect city column. How to patch it?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Patch function - kzbin.info/www/bejne/nWqmmYyricmBmpY
@anjaniniranjan4574
@anjaniniranjan4574 2 жыл бұрын
@@RezaDorrani in recommended video, column 'class' is single selection lookup column, any help for multiple selection lookup column
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@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
@akanksharaut6694
@akanksharaut6694 2 жыл бұрын
Thankyou for this Reza, i had a doubt how to add multiple lists in dropdown and display form for respective list selected from dropdown
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@mauriciopeclatlopesdasilva768
@mauriciopeclatlopesdasilva768 4 ай бұрын
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?
@RezaDorrani
@RezaDorrani 4 ай бұрын
All users will need a premium license that use Dataverse
@karidoyle559
@karidoyle559 2 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@andreiasola9162
@andreiasola9162 Жыл бұрын
Hi @karidoyle559, I've the same issue! Did you manage to solve it?
@lisamona8960
@lisamona8960 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@albertarce1135
@albertarce1135 9 ай бұрын
Thank you very much Sir!
@RezaDorrani
@RezaDorrani 9 ай бұрын
Most welcome!
@moyura2
@moyura2 2 жыл бұрын
Thanks for sharing and 🎄Happy New Year 2022🎄
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Moyura and Happy New Year.
@tiggavideo
@tiggavideo Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@tiggavideo
@tiggavideo Жыл бұрын
@@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!
@daniellapcosta
@daniellapcosta 2 жыл бұрын
Thank you, Reza!!!!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You are most welcome
@bhup3190
@bhup3190 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@bhup3190
@bhup3190 Жыл бұрын
​​@@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
@RezaDorrani
@RezaDorrani Жыл бұрын
@@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
@rarun0080
@rarun0080 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@bongasibiya8368
@bongasibiya8368 Жыл бұрын
Thanks alot ma man!
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@PowerPlatformDiv
@PowerPlatformDiv 2 жыл бұрын
Wish you very happy new year 🥳 Rezza
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Same to you :)
@indranilbose2406
@indranilbose2406 Жыл бұрын
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 ?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have done no work with power pages. I recommend posting your query on forums at powerusers.microsoft.com
@prema6887
@prema6887 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@aysanhaghani5271
@aysanhaghani5271 2 жыл бұрын
Hi Reza, Thank you for this great video, for the city, how we can enable the multiple-choices?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@paulalopezromero7
@paulalopezromero7 Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@WendersonReisss
@WendersonReisss 2 жыл бұрын
Awesome!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank you! Cheers!
@FCSSOFTWAREDEVELOPMENT
@FCSSOFTWAREDEVELOPMENT 2 жыл бұрын
sir great function well done.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You
@ravidk6706
@ravidk6706 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@ravidk6706
@ravidk6706 Жыл бұрын
@@RezaDorraniSure Thank you.
@johanvandyk6532
@johanvandyk6532 4 ай бұрын
@3:24 you mention it will return 'Result' but for me it returns 'Value'. I have 'Distinct(Categories,Title)'. Will this make any difference if it does not return 'Result'?
@RezaDorrani
@RezaDorrani 4 ай бұрын
kzbin.info/www/bejne/iqPNeqaPbrp8faMsi=pozV_e_PjzNdqrMG
@jiteshmarathe1422
@jiteshmarathe1422 2 жыл бұрын
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
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@StephanOnisick
@StephanOnisick 2 жыл бұрын
Love the Demo. My Country and State don't update on a new item. Any ideas?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@omprasaddehury2109
@omprasaddehury2109 2 жыл бұрын
Happy New year ... Here I believe the City field is showing delegation warning.. could you please check that ?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@omprasaddehury2109
@omprasaddehury2109 2 жыл бұрын
@@RezaDorrani Thank you..Got it
@spen2431
@spen2431 2 жыл бұрын
Happy New Year Reza 💥💥👍👍
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Happy new year!
@Spylo1234
@Spylo1234 2 жыл бұрын
Thanks reza...
@RezaDorrani
@RezaDorrani 2 жыл бұрын
👍
@kumnegerholdings
@kumnegerholdings Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Probably sharepoint is not a good data source for your scenario. You could try using flow.
@kumnegerholdings
@kumnegerholdings Жыл бұрын
@@RezaDorrani Thank you. I will look into that. I appreciate your reply.
@karolinaunderwood1039
@karolinaunderwood1039 2 жыл бұрын
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
@RezaDorrani 2 жыл бұрын
Depends on how your data is structured. Could be possible.
@karolinaunderwood1039
@karolinaunderwood1039 2 жыл бұрын
@@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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@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
@mkavo
@mkavo 2 жыл бұрын
Great video, is cascading dropdowns possible in SharePoint without PowerApps as the form? Through json formatting perhaps and is there any resources on it?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Not with JSON formatting.
@moetoledo
@moetoledo Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
You could use Distinct function to not repeat selected items.
@chahinefliss4555
@chahinefliss4555 2 жыл бұрын
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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@MharaMunyaradzi
@MharaMunyaradzi Жыл бұрын
Hi Reza, Thanks for your videos, do you have one that explains the cascading multi-select combo box?
@RezaDorrani
@RezaDorrani Жыл бұрын
I do not have one with cascading combo boxes
@ranimaharaj-sharma4332
@ranimaharaj-sharma4332 8 ай бұрын
Firstly, thanks for the video.. Very useful.. Does DISTINCT only work with Title column from SharePoint.. Thanks
@RezaDorrani
@RezaDorrani 8 ай бұрын
Distinct works with simple column types like text.
@ranimaharaj-sharma4332
@ranimaharaj-sharma4332 8 ай бұрын
@@RezaDorrani Thanks for clarity
@cristianflores5879
@cristianflores5879 2 жыл бұрын
Great Video! Quick Question. Last I checked, the Distinct function is not delegable to SP. Have you found a way around this delegation issue?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
I would organize the cascading data list differently to avoid delegation. I would have a separate list for the countries (directly query that in Power Apps). And then create a lookup column on the country list to set the country values.
@antoncastillo5664
@antoncastillo5664 Жыл бұрын
Thx! muchas gracias 🎉
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@satyasaichaitanya1265
@satyasaichaitanya1265 2 жыл бұрын
Thankyou so much sir
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Your most welcome
@colinracheljustpootling7468
@colinracheljustpootling7468 Жыл бұрын
Reza, your tutorials are so helpful and extremely well explained. Ive followed this one as i wanted a cascading dropdown/combo list. I did run into an issue where one of the combo boxes refuses to update in the sharepoint list and when editing the gallery to repopulate the form this particular combo refused to populate. I also couldnt update back to the list/gallery when changes were made. Is this normal or are there other steps needed? Thanks Colin
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks! I have not come across this 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
@wweennddyy
@wweennddyy 2 жыл бұрын
Hi Reza, thanks for your sharing~ If I want to design a Gallery + Edit Form, "Distinct" function cannot be used in Dropdown List or ComboBox right? Need to have two screen View Form and Edit Form, right? Thanks a lot (Because now I use "Distinct" in the dropdown list / CombBox, the existing data in Lists can't be displayed in the field.)
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Distinct can be used in dropdowns or combo boxes, but it is not delegable. I will have to look at your App in action to know more about your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@TheRealPinky050
@TheRealPinky050 Жыл бұрын
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!
@RezaDorrani
@RezaDorrani Жыл бұрын
Nothing. I believe Result has changed to Value now for distinct function.
@TheRealPinky050
@TheRealPinky050 Жыл бұрын
@@RezaDorrani Thank you! I gave it another shot and it's working perfectly!
@ashimishra23
@ashimishra23 Жыл бұрын
Thanks for the video on such an imp topic! I have been trying to replicate it but somehow, it's not working for me. I have simple form with Name, State and City. State and Cites are being fetched from another sharepoint list. Cities are dependent on state selection. When user fills the form, he has to fill his name(text), select state ( dropdown -values fetched from SP list), select city( dropdown - values fetched from SP list). Working fine till this point. But when I submit the form, Only Name and State fields are visible in Sharepoint list and City field is blank. would be great help if you can through some light why it would be happening?
@RezaDorrani
@RezaDorrani Жыл бұрын
I cannot guess why it is not working for you since I did not come across any issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@alagator28
@alagator28 Жыл бұрын
Hi Reza, thank you for this and many other videos. They are very helpful! I have watched a few of your videos featuring cascading drop down lists from a SharePoint data source and I keep having trouble with one particular step. After writing the formula for Distinct values of the first drop down, you ask to make sure I set the "Value" property to "Result". I only have "Value" as an available option, though... It doesn't give me an error, but when I get to the end, I'm not able to pass the second dropdown info to the SharePoint list. It is blank but shows values in PowerApps prior to saving. I have exactly the same setup as you, with a source of SharePoint list with text columns... Any idea where I'm going wrong?
@RezaDorrani
@RezaDorrani Жыл бұрын
I will have to look at your App in action to know the reason for your issue as I have not come across this. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@OSSABWeb
@OSSABWeb Жыл бұрын
@@RezaDorrani I'm having the same trouble and using the same steps you gave and the outcome is the same as alagator28 / OP
@jamesbuchanan407
@jamesbuchanan407 Жыл бұрын
I have the same problem. When I try to set the Value to Result in the properties Value dropdown, there is only Value there, no option to select Result. I started with a new app, added the sharepoint list, added a dropdown and then tried to select Result.
@rutica
@rutica Жыл бұрын
I am having the same issue. For the first drop down, I can only select Value. I don't have the option to select Result. If I type 'Result', Power Apps tells me 'Result' isn't recognized.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@rutica Try posting your issue with screenshots on forums powerusers.microsoft.com
@nununu8
@nununu8 2 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Reset the controls using Reset formula.
@chreep
@chreep 8 ай бұрын
Do you have a video showing how dropdown option is filtered to show only for the current user?
@RezaDorrani
@RezaDorrani 8 ай бұрын
No
@kylesef
@kylesef 2 жыл бұрын
Awesome video Reza. In my case, based on the first value selected I want to grab information from different tables (one list was too large, so I separated it). is this possible to do?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Combo box is limited to 2k records. For large list scenarios, use a gallery and allow user to select from gallery.
@kylesef
@kylesef 2 жыл бұрын
@@RezaDorrani Thank you!
@nurulsyazana5070
@nurulsyazana5070 Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@mutantlabor
@mutantlabor Жыл бұрын
Hey Reza, this is a lifesaver. Do you know if this is still possible with the modern Drop Down insert? It no longer has a Depends On property and I’ve tried entering the code by hand but it has no result. Thanks in advance.
@RezaDorrani
@RezaDorrani Жыл бұрын
It should work with modern as well but not something I have tried.
@mutantlabor
@mutantlabor Жыл бұрын
I will keep trying. The code doesn't show an error but the dropdown doesn't populate. Maybe I am overlooking something.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@mutantlabor May be. I would recommend posting your query on forums at powerusers.microsoft.com/
@mutantlabor
@mutantlabor Жыл бұрын
I think it is just being finnicky. I tried again and now it is working except that the actual text is not appearing in the dropdowns, but the number of fields changes to the right amount. I think my app is just tired from working on a Sunday night.
@EpicBizHero
@EpicBizHero 2 жыл бұрын
Thank you Reza... Very helpful as always! Two quick questions. I've tried this using collections in both dropdowns (because both the parent and child are Choice columns in SP), but no success. "Sort(Distinct..." works, but do you know if the dependency can be done for collections? Also, what if the SP column you want to use as the parent does not appear in your Matching Field Result options? Thanks again... You are Truly Appreciated Reza!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Shawn. It should work with collections as well. I will have to see your App in action to know more about your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@EpicBizHero
@EpicBizHero 2 жыл бұрын
BOOM... GOT IT!!!@@RezaDorrani knowing that IT COULD be done, I kept trying! For the 2nd collection (in the child dropdown "DropdownOutputPlan") coming from the list "2. Planning", my 1st collection (in the parent dropdown "DropdownProcessPlan") came from a column called "Process", the second collection came from a column called "Output". Here's what worked, perfectly: Distinct( Filter('2. Planning', Process.Value = DropdownProcessPlan.Selected.Result),Output.Value). Thanks so much Reza... God Bless Brother!!!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@EpicBizHero Awesome 👍
@isabiryedickson6904
@isabiryedickson6904 Ай бұрын
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.
@RezaDorrani
@RezaDorrani Ай бұрын
Depends on wether you are using modern or classic controls. I recently did a new video on cascading using modern controls.
@isabiryedickson6904
@isabiryedickson6904 Ай бұрын
@@RezaDorrani Thank you
@sawansoni6818
@sawansoni6818 Жыл бұрын
Hi, Reza.. can you please share the dependent dropdown formula with the hidden column.
@RezaDorrani
@RezaDorrani Жыл бұрын
Does the video not show the formula?
@JansoRibeiro
@JansoRibeiro 2 жыл бұрын
Great video! but when I filter dropdown2 based on dropdown1 the dropdown2 is coming empty, can you tell what it can be?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@srainstruments45
@srainstruments45 2 жыл бұрын
Hello Reza. Your tutorial is very interesting and well done. I have followed the different steps. I use an Excel file online and I have the same kind of problem Marialison Iriarte mentioned in the comments below : when I open the app on my computer, I have an error message indicating : Requested operation is not valid. Server response : failure of tableau 2_2 : Expression "Référence eq null" is not supported. Tableau 2_2 is my data source and Référence the first column of this table. It seems the message appears only when I use the icons >, pencil and + for the first time, then using the app it doesn't appear anymore, and data are well saved in the Excel file. Do you know why this error message appears ?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
I'm not sure about this. 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
@srainstruments45
@srainstruments45 2 жыл бұрын
@@RezaDorrani Thank you very much Reza ! I followed your advice : I've been on the forums and I found that someone had exactly the same problem as me. As an answer it was suggested to use to a SharePoint list instead of an Excel table as the data source. I've tried and it solved my problem 🙂. Thank you again
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@srainstruments45 Glad to know the issue is resolved.
@Ravixxxx96
@Ravixxxx96 Жыл бұрын
Hi Reza, any video you have for SQL Database for Cascading dropdown. Much appreciated.
@RezaDorrani
@RezaDorrani Жыл бұрын
I do not
@iggyguajardo3463
@iggyguajardo3463 8 ай бұрын
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.
@RezaDorrani
@RezaDorrani 8 ай бұрын
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.
@MuaviaOne
@MuaviaOne 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@mkavo
@mkavo 11 ай бұрын
Hi Reza, say you wanted to also set ur Title column text with some default text based on Country selected, and then also allow the user to append that text in the Title field and save to form, how best to go about it? seems to be very tricky to do. you can't use the dropdown as default text because each time you edit the form the Title value would flip back to that dropdown value which would be incorrect. Would only work if the Title text column was View only.
@RezaDorrani
@RezaDorrani 11 ай бұрын
Not something I have tried so not sure
@mkavo
@mkavo 11 ай бұрын
@@RezaDorrani - a challenge for you so? , its a very typical scenario to have placeholder text presented based on predefined values that also allows users to edit and save..
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@mkavo I have not come across this scenario at work and hence not attempted it.
@muru4541
@muru4541 2 жыл бұрын
Thank you Reza
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Your most welcome
@austennis6759
@austennis6759 2 жыл бұрын
now which method do I choose and why? :) but more importantly, is it possible to make it so that if for some reason there is no internet connection, it will store the changes locally & then upload/submit the changes when the connection returns?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Which method and why? You mean form control vs Patch function? sharepains.com/2020/06/19/patch-vs-submitform-vs-update-power-apps/ If no internet connection, then you need to handle offline storage of data. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/offline-apps
@jillhearne7050
@jillhearne7050 2 жыл бұрын
How do I import Power BI table data into a dropdown on Power Apps? Your help will be awesome.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Check my videos on power bi and power apps.
@EmelineRobidou
@EmelineRobidou 10 ай бұрын
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.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Drop down does not have a search option. Combo box has but it has limits as well. Check kzbin.info/www/bejne/sIGwYYRraLFmqacsi=cAy29ap1pIRee_7b
@LadyRoseCas
@LadyRoseCas Жыл бұрын
Thank you, Reza! May I ask how to fix if the Dropdown Properties Value only has Value, Result is not available.
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@RuchiShah-eu3nf
@RuchiShah-eu3nf 7 ай бұрын
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.
@RezaDorrani
@RezaDorrani 7 ай бұрын
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.
@PratikSoni28
@PratikSoni28 2 жыл бұрын
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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Maybe I showed lookup in this video kzbin.info/www/bejne/f4iogqp9gciKbbM
@PratikSoni28
@PratikSoni28 2 жыл бұрын
​@@RezaDorrani Thank you for this very quick response.
@TracyOsimowicz
@TracyOsimowicz Жыл бұрын
Great video. Ran into a BIG issue though because my data source has more than 500 rows, and since the Distinct( ) function is not delegable (can't pull more than 500 rows), I can't use this function to get my dropdown values distinct. Does anyone know a workaround with functions that ARE delegable for this?
@RezaDorrani
@RezaDorrani Жыл бұрын
Distinct is not a delegable data source with SharePoint. You can change delegation limit to max 2000. I will recommend posting your query on forums in case someone has a solution for this. powerusers.microsoft.com
@TracyOsimowicz
@TracyOsimowicz Жыл бұрын
@@RezaDorrani Good point. Sadly, my data is 3000+ rows so changing the delegable project parameter won't get me there either. I will make a post where you recommend.
Power Apps Dynamic Form Schema | Add Controls on the fly
18:06
Reza Dorrani
Рет қаралды 85 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 25 МЛН
How many people are in the changing room? #devil #lilith #funny #shorts
00:39
Cascading Dropdowns in Power Apps from SharePoint list or Excel
20:42
Creating cascading Dropdown in SharePoint with Power Apps (dependent)
29:48
Power Apps Search and Filter Functions on Large SharePoint Lists
19:41
Cascade Dropdown PowerApps Input Controls using SharePoint List Data
6:23
KeaPoint Tech Tips
Рет қаралды 38 М.
Form Control in Power Apps | Must know features & properties
30:59
Reza Dorrani
Рет қаралды 210 М.
Dependent Dropdown list in PowerApps
7:21
Chetan Khanapure
Рет қаралды 6 М.
Editable Grid in Power Apps | SharePoint List
42:49
Reza Dorrani
Рет қаралды 392 М.
Power Apps: Cascade Drop Down List (Using Distinct)
12:16
PowerApps Tutorial
Рет қаралды 13 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 25 МЛН