How to create Cascading (Dependent) Dropdowns in Power Apps

Подписаться 128 тыс.

Просмотров 156 тыс.

50% 1

This video is a step-by-step tutorial on how to create Cascading Dropdown / Combo box controls in Power Apps using SharePoint list as a data source. We will utilize the PowerApps cascading dropdown experience inside a Form Control & also look at how to Patch the cascading information to a SharePoint list.
We will build the PowerApps dependent dropdown experience from scratch.
Video covers the following:
✅ How to create Cascading Dropdowns in PowerApps
✅ Cascading Dropdown controls & Patch function
✅ Cascading Dropdown / Combo box within a Form Control
Cascading Dropdowns in Power Apps from SharePoint list or Excel:
🔗 • Cascading Dropdowns in...
Table of Contents:
00:00 - Intro
00:30 - Cascading / dependent dropdowns
01:38 - Create cascading dropdown controls in Power Apps
07:43 - Patch cascading information to SharePoint List
09:03 - Cascading dropdowns in Form Control
13:24 - Build cascading combobox control
17:13 - Subscribe to Reza Dorrani's channel
#PowerApps #SharePoint #CascadingDropdowns #RezaDorrani

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 454

@RezaDorrani 10 месяцев назад

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 10 месяцев назад

@labelleza7065 8 месяцев назад

Thank you!

@dlucci43 7 месяцев назад

Hi Reza, Great Video! Is there an additional step to create Multi Select Dependent Cascading Dropdown?

@RezaDorrani 7 месяцев назад

@@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 6 месяцев назад

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.

@moniso2277 2 года назад

I can't get tired of saying this: Thank you! So helpful, clear and concise. Great success awaits you, Reza,

@RezaDorrani 2 года назад

You're so welcome!

@anastasianikolovski8337 2 года назад

Thank you, Reza. Your work is extremely important for everyone out there learning Power Apps development from scratch. Thumbs up!

@ivsbanks Год назад

100% Agree!

@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 Год назад

You're most welcome!

@zakw3637 2 года назад

Excellent, quick, and to the point. Thanks for making these.

@RezaDorrani 2 года назад

Thank You so much

@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 2 года назад

Thank You & Happy New Year!

@peterhober5681 2 года назад

This was exactly what I was wondering about but didn't know what to search for. Thank you once again!

@RezaDorrani 2 года назад

Great! Thanks for watching.

@pawanmishra6549 2 года назад

Thank you! wish you and your loved one's a healthy and prosperous year.

@RezaDorrani 2 года назад

Thanks Pawan! Wish you the same.

@tmccann887 5 месяцев назад

Best 17:20 I've spent all week. This tutorial was exactly what I needed. Thanks Reza!

@RezaDorrani 5 месяцев назад

Wow! Thanks so much for watching

@esterraful Год назад

how many days i struggled with that! and solution was right here! thank you @Reza, you are the one and only.

@RezaDorrani Год назад

Glad to hear that! Thanks for watching and liking the video.

@user-dw9hz9kf9q 4 месяца назад

Finally!! I found the way to do it. Thank you Reza .

@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 2 года назад

Thank You for the awesome feedback. Much appreciated!

@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 2 года назад

Thank You and wish you the same.

@SaniGarba 2 года назад

Clear and concise. Thanks, Reza and Happy New Year.

@RezaDorrani 2 года назад

Thanks Sani. Wish you a Happy New Year.

@joelcaro691 2 года назад

Thank you Reza, you always bail us out! regards!

@RezaDorrani 2 года назад

Happy to help!

@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 2 года назад

Thanks Vishal & Happy New Year!

@sueamin2788 2 года назад

This is very useful information. Explained extremely well. Thank you for sharing your knowledge!

@RezaDorrani 2 года назад

You're very welcome!

@zmbman1122 2 года назад

Happy New Year Reza and your Family. Thank you for this great video!

@RezaDorrani 2 года назад

Thanks Yuji. Wish you & your family a Happy New Year!

@kavitacherian3167 2 года назад

This video is very informative! Thank you!

@RezaDorrani 2 года назад

You are so welcome!

@OpusMagnoCards 2 года назад

Nice video and explanation, helped a ton, thanks for sharing Reza!

@RezaDorrani 2 года назад

Your most welcome!

@rajasekar5069 2 года назад

Happy new year and Thanks for Useful video ...!

@RezaDorrani 2 года назад

Happy New Year & thanks for liking the video.

@mohameddomairy3327 11 месяцев назад

Perfect , it is easy and to the point . thank you so much.

@RezaDorrani 11 месяцев назад

You're most welcome!

@merdwerkz 10 месяцев назад

Man... This is fantastic... Thanks!

@RezaDorrani 10 месяцев назад

Thanks so much for watching

@god_hacker581 2 года назад

Thanks for the your knowledge sharing as always. Clean and concise. Happy new year, Sir.

@RezaDorrani 2 года назад

Thanks & Happy New Year!

@oluwatobiyusuf 2 года назад

Happy new year Reza. Another knowledge gained

@RezaDorrani 2 года назад

Thanks 🙏

@causaposer 2 года назад

Great video as always.. Thanks Reza..

@RezaDorrani 2 года назад

Thanks for watching

@StephanOnisick 2 года назад

Really Awesome Example. I need to duplicate to completely grasp your great explanation.

@RezaDorrani 2 года назад

Glad you liked it

@gerryscat Год назад

Awesome tutorial, all the important details are here

@RezaDorrani Год назад

Thank You!

@jonathancastro1135 3 месяца назад

Thank you very much Sir!

@RezaDorrani 3 месяца назад

Most welcome!

@edilturdumambetov389 Год назад

Useful content Reza, thanks.

@RezaDorrani Год назад

Glad you think so!

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

@aderibigbeadeyinka7136 2 года назад

Thanks Reza, happy new year.

@RezaDorrani 2 года назад

Happy new year!

@moyura2 2 года назад

Thanks for sharing and 🎄Happy New Year 2022🎄

@RezaDorrani 2 года назад

Thanks Moyura and Happy New Year.

@antoncastillo5664 Год назад

Thx! muchas gracias 🎉

@RezaDorrani Год назад

Most welcome

@Thor_Underdunk_Caballerial Год назад

Great tutorial, Thanks for sharing.

@RezaDorrani Год назад

Glad you liked it

@bongasibiya8368 Год назад

Thanks alot ma man!

@RezaDorrani Год назад

Most welcome

@ECERaagulLD 2 года назад

Hi Reza, Thanks for your videos keep doing.

@RezaDorrani 2 года назад

Thank you, I will keep trying my best!

@harrisonhenao6454 Год назад

Thank You Reza

@RezaDorrani Год назад

Most welcome

@daniellapcosta 2 года назад

Thank you, Reza!!!!

@RezaDorrani 2 года назад

You are most welcome

@thilegia1020 2 года назад

Thank you

@RezaDorrani 2 года назад

👍

@saojoaomeriti 2 года назад

Awesome!

@RezaDorrani 2 года назад

Thank you! Cheers!

@FCSSOFTWAREDEVELOPMENT 2 года назад

sir great function well done.

@RezaDorrani 2 года назад

Thank You

@satyasaichaitanya1265 2 года назад

Thankyou so much sir

@RezaDorrani 2 года назад

Your most welcome

@DeeBooTV 11 месяцев назад

thank you sir

@RezaDorrani 11 месяцев назад

You’re most welcome

@lakshayhanda9261 4 месяца назад

Thanks

@RezaDorrani 4 месяца назад

Thank You

@prashanth2341 2 года назад

Thanks reza...

@RezaDorrani 2 года назад

👍

@dianezpilon2805 Год назад

Thanks!

@RezaDorrani Год назад

Wow! Thanks so much.

@dianezpilon2805 Год назад

@@RezaDorrani You're welcome. Your channel is a life saver. Thank you for all that you do 🙂

@RezaDorrani Год назад

@@dianezpilon2805 Most welcome

@PowerPlatformDiv 2 года назад

Wish you very happy new year 🥳 Rezza

@RezaDorrani 2 года назад

Same to you :)

@spen2431 2 года назад

Happy New Year Reza 💥💥👍👍

@RezaDorrani 2 года назад

Happy new year!

@augustofilho4220 2 года назад

Very good

@RezaDorrani 2 года назад

Thanks

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

@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 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

@gauravsiyal3256 Год назад

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 Год назад

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

@user-qy3du2pb2v 7 месяцев назад

Hi Reza, Thanks for your videos, do you have one that explains the cascading multi-select combo box?

@RezaDorrani 7 месяцев назад

I do not have one with cascading combo boxes

@aysanhaghani5271 2 года назад

Hi Reza, Thank you for this great video, for the city, how we can enable the multiple-choices?

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

@prema6887 Год назад

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 Год назад

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

@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 2 года назад

Reset the controls using Reset formula.

@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 Год назад

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

@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 Год назад

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

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

@sankalpshrivastava2084 Год назад

Thanks Reza, Can you please help for the same when drop-down populated with sql server column ?

@RezaDorrani Год назад

I do not have a video reference for sql. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

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

@sarahsleight2392 Год назад

Hi Reza, great video! I am pretty new to PowerApps. I am wondering if there is a way to populate a mutiple values into one field based on a selection in another field. E.g. we have test packages. I would like someone to be able to select TEST PACKAGE 1, in one field and for it to auto populate another field with the individual tests in that package e.g. Test 1, Test 2 , Test 3. Any videos that could help with this?

@RezaDorrani Год назад

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

@iggyguajardo3463 2 месяца назад

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 2 месяца назад

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.

@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 Год назад

Probably sharepoint is not a good data source for your scenario. You could try using flow.

@kumnegerholdings Год назад

@@RezaDorrani Thank you. I will look into that. I appreciate your reply.

@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 Год назад

Nothing. I believe Result has changed to Value now for distinct function.

@TheRealPinky050 Год назад

@@RezaDorrani Thank you! I gave it another shot and it's working perfectly!

@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 Год назад

You could use Distinct function to not repeat selected items.

@aithavarunraj2747 2 года назад

Hi Reza, can you please provide some more information regarding delegation for distinct function

@RezaDorrani 2 года назад

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

@anjaniniranjan4574 2 года назад

Thank you Reza for explanation, could you please share details if we have multiselect city column. How to patch it?

@RezaDorrani 2 года назад

Patch function - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-g9ChYuTdNd4.html

@anjaniniranjan4574 2 года назад

@@RezaDorrani in recommended video, column 'class' is single selection lookup column, any help for multiple selection lookup column

@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

@JaslynH 2 года назад

Hey Reza, love your videos! I have watched so many while trying to learn how to build apps You're always very clear when explaining things. I am trying to use cascading dropdowns for a vehicle booking app where people select the state then the business site. The SharePoint list uses choices though instead of text fields. This means that there's no "Result" when trying to do the "Depends on" piece, and I'm wondering if/how I can make this work with choice fields? Or do I need to use text fields? Thanks in advance 🙂

@RezaDorrani 2 года назад

Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IWEQwGLcW7Q.html

@JaslynH 2 года назад

@@RezaDorrani Legend! Thanks so much Reza, really appreciate the quick reply 😊

@RezaDorrani 2 года назад

@@JaslynH Please no legend. Reza is good name :)

@rutica Год назад

@@RezaDorrani How is the link you pasted above (titled 'Cascading Dropdowns in Power Apps from SharePoint list or Excel') different than this video (titled 'How to create Cascading (Dependent) Dropdowns in Power Apps')

@RezaDorrani Год назад

@@rutica I have made over 200+ videos and I don’t remember specifics of each. I remembered a video that I thought may help and hence linked it.

@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 2 года назад

@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 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

@TheFearBO Год назад

Hey Reza, hope you are doing well! I had a question. I have multiple dropdowns which are all tied to the same source. I want each dropdown to show a unique default value from that same source (same column). How would I go about doing that?

@RezaDorrani Год назад

This is not something I have tried and have no video references for it. This video is the only option I have. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

@jillhearne7050 Год назад

How do I import Power BI table data into a dropdown on Power Apps? Your help will be awesome.

@RezaDorrani Год назад

Check my videos on power bi and power apps.

@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 2 года назад

Not with JSON formatting.

@PratikSoni28 Год назад

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 Год назад

Maybe I showed lookup in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IWEQwGLcW7Q.html

@PratikSoni28 Год назад

@@RezaDorrani Thank you for this very quick response.

@jiteshmarathe1422 Год назад

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 Год назад

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

@dynamics365series2 2 года назад

Just a quick help? Got a SharePoint list with Lookup columns I created a Canvas App and use this SharePoint list as DataSource. I wanted to create dropdown list controls in PowerApps to the lookup column in the SharePoint list. I tried to use "Choices" function but it only filtering to lookup source itself of the lookup column and not the column in the SharePoint list The expected result is the function to take value from the SharePoint list lookup column not the source of the lookup column. I know that for single line text, we use "Distinct" function and choices column in SharePoint we can use "Choices" function in PowerApps. I tried to use choices but it only filtering to lookup sources itself of the lookup column not column in the table. Please what function or what else can i use since i want the value in the lookup columns from this SharePoint list?

@RezaDorrani 2 года назад

@ravidk6706 10 месяцев назад

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 10 месяцев назад

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 10 месяцев назад

@@RezaDorraniSure Thank you.

@RobertPryde-by4lg 5 месяцев назад

Great Content Reza! Is it possible to build cascading drop downs / combo box controls using modern controls?

@RezaDorrani 5 месяцев назад

Should be possible

@neelnilu09 Год назад

Thank You Reza Sir, I wanted to know can we do Cascading depending on two drop down list selection like DR1 and DR2 Then DR3 show result, in my Case DR2 Depending o DR1 and both are showing Distinct value but DR3 is not showing Distinct value because it's currently depending on DR2 only, Could you please help on this?

@RezaDorrani Год назад

I will have to look at your use case in action to provide guidance. I will recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@IsoFallIsoFallDotCom-oc4bs 11 месяцев назад

How r u, Reza? Ismaila here from NYC. This is precisely what I had been looking for. Just wanted to bring to your attention that if 2 countries like the US & Canada had states of the same name, this particular example would be flawed. Is there a way to perfect it taking consideration of that?

@RezaDorrani 11 месяцев назад

Another option would be to design it using lookup column. I do not have a video reference on that scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@LadyRoseCas Год назад

Thank you, Reza! May I ask how to fix if the Dropdown Properties Value only has Value, Result is not available.

@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

@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 2 года назад

Combo box is limited to 2k records. For large list scenarios, use a gallery and allow user to select from gallery.

@kylesef 2 года назад

@@RezaDorrani Thank you!

@sridharreddy1607 9 месяцев назад

Hi Reza, what if combobox has multiselection option n loop through all items selected and cascade it to next combobox ?

@RezaDorrani 9 месяцев назад

Possible scenario but not something I have tried. Ofcourse the complexity increases.

@pramodagarwal1990 8 месяцев назад

Please make cascading dropdown video with Dataverse table as well

@RezaDorrani 8 месяцев назад

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.

@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 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 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 2 года назад

@@EpicBizHero Awesome 👍

@user-kj5jt7xb5x 5 месяцев назад

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 5 месяцев назад

Drop down does not have a search option. Combo box has but it has limits as well. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zPM0Q53L3sE.htmlsi=cAy29ap1pIRee_7b

@Ravixxxx96 Год назад

Hi Reza, any video you have for SQL Database for Cascading dropdown. Much appreciated.

@RezaDorrani Год назад

I do not

@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 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

@ranimaharaj-sharma4332 3 месяца назад

Firstly, thanks for the video.. Very useful.. Does DISTINCT only work with Title column from SharePoint.. Thanks

@RezaDorrani 3 месяца назад

Distinct works with simple column types like text.

@ranimaharaj-sharma4332 3 месяца назад

@@RezaDorrani Thanks for clarity

@pabsmart 7 месяцев назад

Hi Reza, thanks for your video, i'm having an issue creating the cascading drop down, when I input the formula for Distinct(Table,Field) it's giving me this error: "Expected an operand.The formula or expression expects a valid operand...", any ideas why? thanks!

@RezaDorrani 7 месяцев назад

I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@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 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

@viswanathanviswanathan1293 Месяц назад

Sir, In the second method i. e using Form control where we add drop-down/combo controls, what is the formula provided in the Submit button for the new record to be added in the back end list.

@RezaDorrani Месяц назад

All I did on submit button was submit the form

@nurulsyazana5070 8 месяцев назад

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 8 месяцев назад

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

@chreep 3 месяца назад

Do you have a video showing how dropdown option is filtered to show only for the current user?

@RezaDorrani 3 месяца назад

@karolinaunderwood1039 Год назад

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 Год назад

Depends on how your data is structured. Could be possible.

@karolinaunderwood1039 Год назад

@@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 Год назад

@@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

@kiruthikarajan7397 9 месяцев назад

Hi Reza, since we are using distinct , unable to use searchable to true in the combo box.. do you have any workaround for it ?

@RezaDorrani 9 месяцев назад

Im not aware of a workaround for it. As far as I know, it should be an option so not sure.

@sherylwitkovich7610 Год назад

Hi Reza, I'm using Distinct as you explained in your video, but I'm not getting distinct results it's pulling in duplicates. It's pulling in departments from my Sharepoint list, but pulling multiple Customer Services and Accounts Payable. Is there an easy way to fix this? Thanks so much!

@RezaDorrani Год назад

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

@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 Год назад

I have done no work with power pages. I recommend posting your query on forums at powerusers.microsoft.com