PowerApps Cascading Dropdown - See comments for 2021 version

[@carlamahlberg1854]

So easy to understand. I think I will subscribe to your channel, don't know why I went anywhere else to explain dropdowns :-)

[@ShanesCows]

Thank you for the kind words. I am always looking for suggestions for future videos if you have any.

[@rinuurs]

Do one for power Bi offline availability. if you will please. I was looking for a solution for site users who sometime lack internet in there sites. They have to take pictures using their mobile and fill in a form and submit. once they gets WiFi or internet connection it gets uploaded automatically. Can this be done using Power apps ?

[@marciokataoka]

Agree with Carla. Your tutorial is the best ever. I've tried others but none was as well explained as yours. And one good thing: you keep the explanation fun!

[@myzer6474]

@@ShanesCows I can't agree more with the previous comments. Your explanation was by far the easiest to understand. As you mentioned, many of the other resources out there for cascading drop downs were not explained in enough detail or were lacking clarity. That was my experience until I found this video.

[@saigudiboina7685]

@@ShanesCows Hi, May i know how to implement writeback to excel through PowerApps

[@bigjonradio]

Hello Shane! I'm working my way through your videos. They're absolutely brilliant. 20 minutes is a great 'bite sized' chunk & you absolutely don't need to worry that "it's not pretty" - showing the functionality gets straight to the point. Love your style & sense of fun!

[@ShanesCows]

Thanks 😎

[@ShanesCows]

Thank you 😊

[@cztop54]

Shane! As always --THE BEST! I just worked through another cascading video created by another well-known author. Could NOT figure it out and it was presented as "oh -- so very easy"! As usual, I knew right where to come when I was stuck. What you do best is teach us how to thing through these things in the most clear, concise, non-intimidating, funny and kind way! Don't know what we'd do without you! Thanks ever and always so much!

[@ShanesCows]

Cindy thank you. :) I am glad my content is working well for you. Keep kicking butt at PowerApps.

[@nharzic9248]

So helpful and clearly explained. Thank you. On the Refresh button, I added a reset of the two dropdowns so that the form would clear out any existing choices. This will be an ideal solution for choosing locations in a help desk form.

[@ShanesCows]

Cool. Glad you are getting it.

[@dallas76100]

Great vid, sir! How has this been out here for TWO YEARS, and I just came across it now? Love your blend of authenticity and information. You have a great delivery.

[@ShanesCows]

Much appreciated!

[@karamqusai]

was amazing, your solution inspired me to think of another one you have a field you want to be filled from a selected item from a drop-down menu here is what you do 1 create a dropdown button 2 let the field default value be the dropdown button selected value 3 put the dropdown button above the field to look like the field itself is a dropdown menu

[@tordsonander]

This channel is like finding a gold ore! All the "what if i could build an app to help with that at work" is suddenly within reach with PowerApps. Together with your work there is an epiphany every. single. evening! Thanks Shane!

[@ShanesCows]

Glad it is helping. 😀

[@prasanthgeddam2249]

How update a label depending on cascading drop down: Example: 1st drop down HR is selected; cascading dropdown - manager is selected ; Now one flexible label should appear no.of new joinees this month; in similar way if IT is selected and in 2nd drop manager is selected label should tell no.of project hours this month and values entered in text boxes against that labels should go to that particular column in sharepoint list or excel - Thank you in advance and appreciate your high energy classes

[@ShanesCows]

The the label's default property to be a lookup using the second dropdowns value.

[@Andressamagalha]

I'm really grateful for you sharing your knowledge! I've been learning a lot. Your sense of humor makes the videos lighter and your straightforwardness for explaining the contents is quite valuable.

[@ShanesCows]

I appreciate that!

[@keimomomon]

Watching in the year 2022, thank you for this tutorial! It helps with my current project right now!!!

[@marcsavoie7865]

You are a life saver! The Distinct() trick helped me with filtering data based on a dropdown list that was made in SharePoint, on which I had no control on what choices the user had.

[@ShanesCows]

Awesome! 🤠

[@angiferguson7867]

Shane, You're AMAZING! Thank you so much for explaining how to get the cascading dropdowns to work, from the beginning. It's so helpful!

[@ShanesCows]

Happy to help! 🐶 There is a newer version of this video with even more stuff. kzbin.info/www/bejne/iXywqJSvm8SWq68

[@jimfitch]

I try to be on time, but here I am joining this party 2 years later -- almost to the day! Great video, Shane, as always. The main topic may be Cascading Dropdown controls, but I really like the bonus tips here. They may be little things, but it's the little things that are the finishing touches that make a truly professional-looking app, isn't it?

[@ShanesCows]

Agree Jim. That is why I try to sneak them in. 😀

[@none1615]

Please stick to same way of explaining things .. It's just so plain and easy to grasp and helped a lot .Thanks for doing it .

[@ShanesCows]

Will do. Been doing it this way for 15 years and don’t plan to stop. 😻

[@vinayayinapurapu]

Bold Shane!!! from Bold Zebras. Your content always excites me. Great work Shane. Now i know why you are MVP... :)

[@ShanesCows]

I appreciate that!

[@FM-lu9hu]

Direct, Concise, Useful; your stuff is great for folks that want to get in, get it done, and get on to the next thing. Two big Thumbs Up.

[@ShanesCows]

Thank you. :)

[@FM-lu9hu]

Any PowerApps vids for Data Entry coming up? I.E. Something like; Open App, Select Workcenter, Select Defect, entry QTY defects, enter qty processed, save entry.....I've setup an Excel file on OneDriveForBusiness w/ similar features, but not drop-down or auto-fill (like autofill date entered)

[@agytkumar]

Thank you for the awesome explanation. Your videos are the best source of information on PowerApps I found till now. Thank you for helping the community.

[@ShanesCows]

Glad to help. 😻

[@carolevandenberg1474]

Thanks, Shane - this was great! So much out there, but your video was the most straightforward, clear, and directed at what I need than the rest.

[@ShanesCows]

Glad to help 😻

[@benpearce4313]

Thanks for the video Shane, very helpful. Using Selected.Result rather than Selected.Value worked for me

[@ShanesCows]

Cool

[@tausifjamkhandi1597]

I had created two cascading list using infopath form which was very much time consuming n also had to create multiple list with lookup columns, PowerApp is a great tool n thanks for ur explanation It was easy to understand👍 Keep posting new vdos, u r doing a great job👌🏻

[@ShanesCows]

Thank you for the kind words.

[@comcroa]

I'm only beginning to use Power Apps. Thanks so much for your videos. You explain so well. Cheers!

[@ShanesCows]

Glad to help. 😀

[@eprock4549]

Thank you for your information regarding cascading dropdowns, was having the hardest time making them work. Your video helped me make my application much easier to use. Thank you!

[@ShanesCows]

Awesome!

[@EmmaManetta]

Thank you very much for all your work on these videos. I was about to just forget about Powerapps all together because I was frustrated trying to learn and you helped give me hope again. :)

[@ShanesCows]

Awesome Bruno. 😀

[@GSoftagon]

Shane, Please write a book and make its Kindle version available. Again, this is really great. Thank you very much for your hard work.

[@ShanesCows]

Hey Gideon I have been approached about writing a book but it all changes so fast I don’t think it would be valid long. 😑 Instead I have the classes at training.powerapps911.com to help you learn.

[@almiraizmakova1925]

You explained very clearly than others KZbin videos 👍Keep going like that! I will be seeing only your videos.

[@ShanesCows]

Glad you like it.

[@TheGuyof69]

I AM SHOCKED!! Not about you, Shane. Your videos are great and very helpful! When I started playing around with PowerApps and started watching your videos, some things were a little odd. I was constantly getting syntax errors and did not understand why. Today I found out. Microsoft, for reasons I cannot understand, decided that it was a good idea to use different characters within the formulas, depending on the used browser language!! So if your browser is set to English (strangely no language selection inside the PowerApps portal and ignoring the language set in the user account settings in Office 365) comma is used, so RGBA(255, 255, 255, 1) in German semicolon is used, so RGBA(255; 255; 255; 1) No wonder my formulas were not working! And due to my screen resolution, I didn’t see the little dot over the comma before today. But why?? I realize that this must come from Excel. Same thing there, BUT Excel is very very old and for compatibility reasons they never changed that, although using localized characters - and even more shockingly - function names, was never a good idea. Anyway, PowerApps is not Excel. So why continue a bad practice in a new tool?? Do you have any idea?

[@ShanesCows]

I got nothing. I agree the , vs ; is very annoying for everyone. 😑

[@tundeoyelana]

I am new to PowerApps though but I hope to develop apps using your tutorilas.. this video is so cool and explanatory

[@karthikindianchennai]

Hi Shane, You make it so simple, thanks. You have a unique style which makes the whole learning so much fun & easy.... i am already your fan.... love & respect....

[@ShanesCows]

Thanks 😊

[@theinkweaver]

FYI - For using a SharePoint list instead of an excel table, I found that in the second dropdown, the data type also has to be Result (instead of Value). (It also then requires a value in each dropdown, auto-selecting the first available row instead of leaving it blank for the user to select an option. Not sure yet how to fix that issue, but I'm still learning.)

[@ShanesCows]

Glad you are getting it.

[@kevinsale8098]

Straight to the point. Easy to understand.

[@ShanesCows]

Thank you

[@nbincompliance6436]

Shane I love all you Powerapp Video!! i'm now onto PA #5 and doing some really cool stuff. These videos are soo good to come back to for reference - THANKS

[@ShanesCows]

Awesome!

[@apartmentexpertsdrh]

Great video, much better than all the rest out there that I've watched.

[@ShanesCows]

Thanks 😎

[@meghanstokes5019]

Shane, thank you so much! Your video's are so helpful and you explain it where a beginner, like myself, can understand!

[@ShanesCows]

Glad to help. 😀

[@bryansones4831]

Day one of learning PowerApps. So glad I found this video. Subscribed immediately as this is exactly what I need to build a powerful estimating tool. Thanks! Let me know if there are any videos that can combine this idea with adding values created in drop-downs continually while it builds an estimate in the background.

[@ShanesCows]

Repeating tables like Infopath is about building an expense report. But that is the same concept. 😀

[@Emmaxson]

Thanks Shane... You've made my learning and use of PowerBI very simple and very interesting. Thank you.

[@ShanesCows]

Cool. Glad to help.

[@Richkotite1]

WOW, Thank you very much. You made it very understandable and now I know how to create cascading drop downs.

[@ShanesCows]

Awesome. 😍

[@irenegunning3693]

Thank you, I was having an error with one of the tutorial I'm reading. This gave me an idea.

[@ShanesCows]

You are welcome! This is a later video on the same topic with more ideas. kzbin.info/www/bejne/iXywqJSvm8SWq68

[@mangeshmehendale4139]

Hi Shane - your videos are awesome! There is so much that I learn not just from watching them, but also they way you explain and demonstrate the concepts. I had a really noob question - if Im an external consultant developing an app from a customer, which account should I use? I would not be part of the Office 365 list - so would they have to make a separate account for me which they are then forced not to close (even after I exit); or is there just another way. My request is for you to make a video from a developers perspective in terms of setting the various environments, security groups and policies and finally rolling out the app. I know you have covered a some of these concepts in separate videos - but an integrated video would be terrific! Thanks again for sharing your extensive information and knowledge. Much appreciated!

[@ShanesCows]

I make most apps in the customer tenant. I have them create the app so they are the owner then give me co-owner. That way I can build it and they can delete my account after I am done.

[@mangeshmehendale4139]

@@ShanesCows Thank you once again for your reply Shane - your channel is totally awesome. I am watching your videos wherever and whenever I get a chance - on my computer, on my ipad and even on my iphone! I just cant get enough of what you put up. Waiting for your next!

[@noonessss76]

I am grateful to find this!!!

[@ShanesCows]

Happy to help. Have a great day.

[@grover810]

Hi Shane, thanks for your great work.putting in front of us in a simple mannner and I am sure you have learned hard way .Lots of research has gone into it. Thanks

[@ShanesCows]

Very welcome

[@nitzan300]

so simple, you are explaining it in such a great way, thanks a lot for the effort and all the great videos ,BIG LIKE!

[@ShanesCows]

Thanks 🙏

[@MachSpeedFBA]

Your videos are the best! They help me learn how to use powerApps!

[@ShanesCows]

That is awesome!

[@NWUK1]

Just wanted to say a massive thanks for this, I have just started to teach myself powerapps and I have been getting no where until I found this video.

[@ShanesCows]

Thanks. 😻 Let me know if you have ideas for other videos or need a nudge.

[@NWUK1]

Will do thanks, I have a small internal project I am trying to achieve which will hopefully help me learn and be productive at the same time. I am in the process of creating a sales order form, that once submitted gets sent for approval, and once approved sends an email to the accounts team and saves the form in a folder on O365 Sharepoint.......might be a little ambitious as a starter project, but worth having a crack.

[@ArronMilsom]

Hi Shane, Thanks for the Great videos / Tutorials, there really easy to follow and understand, I only started this week using Powerapp and you have helped me out a hell of a lot so far :) Please can you do a video to show how to create a PowerApp to collect information then store the details on a local device until the devices has a WIFI connection and then have an option to sync the data once the device is on WiFi.

[@ShanesCows]

SaveData and LoadData. Yeah, I need to cover those. I just haven't yet. One day I hope.

[@bbcoachlara]

great job man! I'm just starting out with Power Apps and you explained this very well. You just got another subscriber :)

[@ShanesCows]

Awesome, thank you!

[@scfo]

Hi Shayne, this will be very helpful when we map clients chart of accounts (or Product List) for example: Account Code/Name: 2000/000 - Motor Vehicles @ Cost Report Type: Balance Sheet (or Income Statement) Level 1: Assets (Liabilities ; Equity) Level 2: Non-Current Assets (Current Assets) Level 3: Fixed Assets And then after the account has been mapped it pulls through to a SQL Table that is imported in Power BI. Also after the account is mapped it gets removed from the dropdown in PowerApps. This is very handy for reporting purposes for things like mapping products in product category and - subcategories, or projects or employees in different groups. Would be great if you can do a video like that

[@francinepowell9296]

Just what I was looking for, Thanks!

[@ShanesCows]

Awesome :)

[@DaveMcGarry]

2 mins in and you already get a thumbs up for the reset button :D

[@ShanesCows]

Thank you. 😎

[@mugdhashetge-gallagher5797]

This tutorial really helped ! Thank you Shane !

[@ShanesCows]

Thanks 🙏

[@madihasalman1]

Hei shane! Good video. I have one question. i have sharepoint list in which i have two dropdowns which i want to update for example from power apps .If i want to add more items in tht particular column of list .is tht possible ?

[@saanisirajulhaque375]

Awesome you made my day . one small query i have two excel from one excel i am making cascading and in another excel i am saving i am able to save the value but the cascading value is not getting saved which i am fetching from another excel can you help me in this please

[@ArnoNoxFordSteyn]

Great video Shane I already found a use for this in a invoicing system I've built

[@ShanesCows]

Awesome!

[@miguelangeljimenez114]

Man, you're helping me a lot! Thanks for your dedication on this

[@ShanesCows]

You are welcome 🐶

[@andreachristy3724]

This video was super informative! Helped me a lot with my App. Thanks a lot Shane Young

[@ShanesCows]

Awesome!!!!🤩

[@Hydrarian]

Hi Shane, thanks for your videos, they're very helpful. Can you please show us how can we navigate into screens by selecting the dropdown items? Thanks

[@ShanesCows]

There is a property for the Dropdown called OnChange. Put your navigate function there.

[@deanajera6339]

Greate video! Do you have a video where show how combine dropdowns with another gallery? The idea is for example show all the jobtitles regarding IT department . Thanks

[@ShanesCows]

Like so? kzbin.info/www/bejne/jJ_ElX6NnsueqJo

[@kwilliams1130]

This works great, except for the value in my 2nd dropdown is not saving to my main SP List. The first dropdown selection saves without any issues.

[@kwilliams1130]

I fixed it. For the card default instead of Parent.Default, I did ThisItem.FieldName

[@ShanesCows]

Glad you got it. 😀

[@anassid4879]

This is really a great description. I have tried with a database same as shown in this video with the table consisting 3 columns and i put three dropdowns in the app. The first two dropdowns are working perfectly with all the commands described in the video but i am still unable to find a way so that i could connect the third dropdown as well which will be dependent upon the selected values of first two dropdowns. If you could help me in some way then it will be really helpful.

[@ShanesCows]

Remember you can use And in your filter. 😀

[@adonismorales1059]

Hey Shane, loving your content so far. What do you suggest for Cascading Dropdown with a source of 2000+ options?

[@adonismorales1059]

Nvm :) for those with same question -> kzbin.info/www/bejne/i5KlnomLht2SfM0

[@ShanesCows]

Glad you got it figured out.

[@GSoftagon]

Shane, You are awesome. Thanks for this presentation.

[@ShanesCows]

You are welcome 😊

[@mauricemchugh8702]

Brilliantly explained - I had several "Aha" moments

[@ShanesCows]

Awesome 😎

[@ShanesCows]

Make sure you check out the updated version of this video kzbin.info/www/bejne/iXywqJSvm8SWq68

[@mauricemchugh8702]

I just watched this again - 2 years later - Thanks again - still brilliant

[@udit1989]

Thank you for posting this. I am a beginner and your videos have really helped a lot.

[@ShanesCows]

Glad that it helped you.

[@robertolondonovargas]

Thank you Shane, your videos are very descreptive and i learning so much from that!! thanks

[@ShanesCows]

My pleasure!

[@erikacepero9668]

Hope all is well, may I say your videos are very easy to follow. I appreciate how you stick with mechanics only. I have one question, within your cascading dropdowns I notice that you only display 2 fields/columns to display. I have 3 columns that I need to filter by, I am having trouble with the 3rd dropdown, it only references the 2nd dropdown. I need the 3rd dropdown to filter from 1st and 2nd dropdowns: columns (1st DD = Program Type, 2nd DD = Expense Type, 3rd DD = Expense Description). I tried using the "And" function also "&", "&&" and neither of them worked properly. Please advise if I need 2 distinct functions or an If statement, I have tried them and didn't work either.

[@ShanesCows]

Filter(datasource, column1 = dd1.selected.result And column2 = dd2.selected.result) should be it.

[@billscott9300]

Shane, Great video, hoping you can help. So I have a pair of SP lists in the same site. I am trying to use the first list which has a list of our resource in 3 different roles (eg: PC, GPA, ISA). The basics of the table are Role, First, Last, Full Name and details about the resource. Second table is for projects and depending on the services aligned to it a PC, GPA and or ISA will be assigned. For each of the assignments I have a drop-down list which I want to have a filter to reduce the available options . The formulas I have tried include: - ShowColumns(Filter('ICI - Team',IsDCMGPA = "Yes"),"FullName") - No results (Get blue icon with the >500 error/notification.) - Distinct(Filter('ICI - Team','ICI - Team'.Role=PC_Label.Text),'ICI - Team'.FullName) - No results (Get blue icon with the >500 error/notification.) I have also tried a number of other formulas all of wihch have resulted in no results. I am not sure what I am doing wrong.

[@eufemiopagan1268]

Diddo what everyone is saying about great videos. I'm just getting started & learning a lot. I followed your steps & have an excel sheet in OneDrive with 2 fields -- DDFilter & DDOptions. I need to create multiple criteria for multiple dropdowns. For example if DropDown1 = "Yes" then Filter the DDOptions field from the sheet to XYZ from the DDFilter field. If it says "No" then filter the DDOptions from the sheet to ABC on the DDFilter field. However, when trying to do your basic dropdown option as described in this video, it won't even recognize the fields from the data source. I type Filter(DDOptions but it doesn't recognize DDOptions as a field unless I add the table name DDList. to the front of it. I then have the same issue when entering the DDFilter field name in the logical test, but then it won't accept .Selected.Value. Any thoughts on what I'm doing wrong with this step? And is there a way to use a string (i.e. "Yes") in a filter? Thanks!

[@ShanesCows]

Step 1 make sure you have added all of the Excel tables as data sources to the app. Step 2 you have something like follows Items = If(Dropdown1.Selected.Value = "Yes", XYZ.DDOptions, ABC.DDOptions) That isn't the exact code but the concept.

[@hitasajil3869]

Request: Can we have tutorial for Cascading Dropdowns in PowerApps SharePoint Lookups. And power apps should shows the selected items in edit mode not just the beginning one.

[@ShanesCows]

Like this? PowerApps SharePoint LookUp Column kzbin.info/www/bejne/amTInJ1rgtGBgLc

[@ConsulthinkProgrammer]

Nice. For an alternative we could use google apps script to build dependent dropdown webApp form

[@ShanesCows]

I guess? I am not a fan of the Google tools for this stuff

[@ConsulthinkProgrammer]

@@ShanesCows Thanks for your feedback :)

[@jacquelinedavis2789]

My Item is Distinct(Filter('ARO Drop Downs', DDLocations=Dropdown2.Selected.Result),DDLocations) Nothing comes up in the drop-down - any thoughts? PS - Your videos have been TREMENDOUSLY helpful!

[@ShanesCows]

Take the distinct out and see if the filter returns data. Start there.

[@rajeshpolinati7515]

This is really helpful..In this same scenario can we do it in reverse way. Like, If user selects the value from "Job Titles" dropdown it should show "Department" values..(It should work in both the ways).If possible please let us know

[@ShanesCows]

I have never done both ways. Possible but I don't have code for it.

[@LuckVagner]

Hi Shane, Great work indeed. Just a few update, instead of ".Value", mine worked as ".Result"

[@ShanesCows]

Glad you got it. 😀

[@rjayabharath]

I am getting used to your introooo... great work.. ur my ready reckoner ... thank u

[@ShanesCows]

Glad to hear that

[@anthonyleduc]

very useful and inspiring. Thanks shane.

[@ShanesCows]

Glad you enjoyed it!

[@armkritsada]

Thank for your teaching, I try very hard to find this way >>>>> Thank again ;) Respect

[@ShanesCows]

Glad to help. 😀

[@rochellenicholson6372]

Another great video thanks. I was wondering if you are connecting to a sharepoint, how do you achieve the blank line that you mention. Thanks in advance

[@ShanesCows]

The dropdown control now allows you to to set the property AllowEmptySelection to true. :) No more blank line needed.

[@anasmohammed9770]

Thanks Shane. very well explained. Any chance of putting a video about the repeating table behavior of infopath in powerapp

[@ShanesCows]

Great idea. I will add it to the list.

[@luis996]

Hi Shane, your videos are great! A question, is it possible to show in one column of the Sharepoint's list the option selected on the drop down menu?

[@ShanesCows]

Yes but I am not sure I follow your question.

[@ilikeshineys]

Thanks Shane, Great Vid. Subscribed.

[@ShanesCows]

Awesome, thank you! There is a more recent version here if it helps 😁 kzbin.info/www/bejne/iXywqJSvm8SWq68

[@iulianburlacu]

Hi Shane! Is it posible for the JobTitles dropdown to have a Default value of an blank option (empty string) that comes first and then the rest of the options, after we selected the department?

[@charlesbonfante9188]

Super useful! Really easy to follow. Thanks

[@ShanesCows]

Glad to help. 😀

[@priyadharshinigunasekaran3959]

Hi Shane, Here is the scenario. There are 2 SP lists as follows. 1. Department list (Holds Department and Job Title) 2. Job list - Customized this list with PowerApps and there comes a cascading drop down. Department and Job Title(multi select) columns. Created a data source to Department list to populate the values in these 2 drop downs. I was able to select multiple values in the Job title drop down but the values are not saved in the SharePoint list. Could you please let me know what formula should I use in the Update property of the Job Title column to save multiple values in SP list?

[@ShanesCows]

Look for my video on patch complex SharePoint columns. I cover it there. 🤓

[@shivashanker9581]

Fantastic tutorial Shane.. I'm not getting the Sort Distinct formula right - instead of "Result" I'm getting only "value" to select . Example: Sort( Distinct('PIA form,Title),value) I'm not getting the" result" option to select instead of "value". Please help

[@jeffkasavan93]

Thanks for this very useful video. When I Patch this to send the results to Sharepoint I get "The type of this argument 'AIsle' does not match the expected type 'Text'. Found type 'Error'." My source for the dropdown is in Excel and the whole table is formatted as text. The Patch command sends the results to a Sharepoint list and the type of that column is 'Single line of text'.

[@jeffkasavan93]

The solution: the Patch format had to be Aisle: AisleTRVDD.SelectedText.Value. Nothing else would work.

[@ShanesCows]

Glad you got it. :)

[@januarycup3413]

Great Video! I wonder if it is possible to make a cascading list while allowing manual text input into it and make them part of the list after.

[@ShanesCows]

Would take a lot of work but I think possible.

[@paulwarneke2186]

Fantastic tutorial Shane and very easy for a PowerApp newbie to follow. Out of interest, could a similar concept be used to connect to the term store to select Category / Product relationships etc? This way we could have a central reference rather than distributing it across multiple locations. Have subscribed and will be back.

[@ShanesCows]

Not sure. I have not used the term store with an app yet. 😕

[@paulwarneke2186]

@@ShanesCows As follow up, we couldn't get them working but have found that the Common Data store is a better solution as it can be used outside SharePoint.

[@pier-jeandurand1055]

Hello Shane, First of all thank you for all your videos! I got a question regarding the sort(distinct(sharepoint list data) function. It does work with my dropdown tool. But the data that I choose are not saved in the sharepoint list which is link to my powerapp. I don't know if I'm clear (hello from France) Thanks for your help

[@swapnabendi234]

Hi Shane, I am learning Powerapps from your videos . Very helpful . Thank You,Much. I have a doudt from this video. Please tell me the use of Reload Icon when the excel which we use is having static data.We might not use it rt?

[@ShanesCows]

The reload is only to refresh the data source. Typically you only need that for testing not the real app.

[@swapnabendi234]

@@ShanesCows Thanks Shane for the reply.I m glad that I m learning Powerapps from your videos.Very helpful for beginners like me.Kudos to u:-)

[@aliciadegouveia3229]

this great. have a question can you point me in the right direction. I am creating an app that has dropdown function with a date. how do i make a date picker of date that is on an excel document filter in a data table.

[@ShanesCows]

Set the date column as the datasource for the dropdown I think is what you are looking for. Maybe include Distinct to avoid duplicates?

[@mplogue]

Great stuff. So, one thing I noticed is that once you selected a Department, The Job Title was automatically filled out with the first item of the list. In order for it to remain blank by default when you select the Department, would you need to include on the spreadsheet for each Department a line with just the Department and a blank Job Title? And of course, then using the same sorting trick you applied to the Department field so that the blank would always show first in the Job Title field when and department was picked....

[@ShanesCows]

Yup. 😀

[@mplogue]

Groovy - Thanks!

[@TheTailson]

Hi Shane, these videos of yours are absolutely fantastic, I find myself stumbling upon your channel very frequently as I learn how to properly use the PowerApps services. The cascading dropdown has been a nightmare for me for a while, and this video was simple and easy to follow, thank you for making it! I've tried to apply a similar method to comboboxes, with limited success. I expect to have a large number of entries in the first dropdown, and would like to be able to search through entries, comboboxes seem to be the way forward. Sadly, the second dropdown (which can be a normal dropdown) gets confused, giving me "squigglies" under the = symbol and .value. Any thoughts on what could be done to fix this? Again, your videos are amazing, thank you so much for making them.

[@ShanesCows]

Combo boxes put out multiple selections while the drop down only does one. Connecting the two may be difficult

[@TheTailson]

Hi Shane, I actually did figure this out eventually after throwing reams of different combinations at it. I'd wanted to use combo boxes because the source it was reading from was going to have about 400 entries, very cumbersome for a dropdown! The combobox's search feature was nice. Basically, needed to be able to choose contacts according to the company I had selected. Eventually, I put this one in and it stopped giving errors. Works well when you restrict the first combobox to only one option. I don't think it will work if it were possible to choose multiple. Distinct(Filter('Company Contacts', DropDown_Companies.Selected.Title = Company), ContactName) It seems like the order of the arguments just needed changing a little bit, which is strange but it works? This works on normal dropdowns and other comboboxes.

[@TomMcGuire]

This is a Great video I have a Sharepoint form for a list that is pulling information from a list with Cascading dropdowns but I cannot get this information to store back to a another list correctly. Basically want to select a company and then the person within the company and store that along with a Date into a new list. I have been looking at Patch but think I am missing something. Is Patch the correct thing to use?

[@ShanesCows]

Patch is the best way to go. kzbin.info/www/bejne/g5TPe5KFbq2pgLM might help

[@JeffersonMartinSynfluent]

Can you type into the dropdown with something like an autofill in order to select a name from a large list? Your videos are very helpful and instructive.

[@ShanesCows]

Yes. Use a combo box. PoweApps Combobox - Search, Filter, Default values, and more kzbin.info/www/bejne/ppvWYY2po6-NjtE

[@JeffersonMartinSynfluent]

@@ShanesCows Thanks. Sounds good.

[@TheAmazeer]

Crystal clear dude.. keep going you'll get more subscribers..

[@ShanesCows]

Thanks 🙏

[@roza2369]

Hi! Sorry, I didn't really understand the difference between the Reset button and the Refresh button. Can you please re-explain? Thanks!

[@ShanesCows]

Reset is used to set a control back to its default value. Refresh is to update your data connection.

[@TheDDogWonder]

I have a question about authentication to this backend data source where the dropdown data is coming from. You used OneDrive in your video which is fine locally but if I do this using a sharePoint list, I have to grant everyone with modify access to the list because PowerApps uses the User context when accessing that data. Is there a way to connect to a datasource using a 'Connect As' option so only my Connect As account has rights to the backend data? We've struggled with this and it's very annoying. Maybe I'm just a noob. Thanks! Great videos!

[@ShanesCows]

Not possible. Sorry

[@tinakronborg8077]

I still love an learn from your videos. I have used cascading drop downs may time with success! Now I have the challenge that I like to also distinct on a Yes/No column is that possible? Distinct(Filter(MicroInstruments;InstrumentCategory=ddInstCategory.SelectedText.Value);Title) - I like to only include title which has a No in their Discarded column (from the MicroInstrument SP list) Maybe I missed it in an other video, I have almost learned everyting from you videos, but can't find anything about this issue. Thanks so much in advance!

[@ShanesCows]

Hi Tina. It involves the In operator which I haven’t covered yet I think.

[@anthonypadilla5853]

Hi Shane, I followed this video and got my dropdowns to work. I want to use the cascading dropdrowns to filter a table. I think my formula is okay, however, I am getting an "operation is invalid" errror. Here is my formula for my table: If( IsBlank(Dropdown1_2.Selected.Result), Filter( 'RCF Processing Detailed PM Table', FacilityID_SystemName = ComboBox2_3.Selected.Result ), !IsBlank(Dropdown1_2.Selected.Result), Filter( 'RCF Processing Detailed PM Table', FacilityID_SystemName = ComboBox2_3.Selected.Result, ReviewDate = Dropdown1_2.Selected.Result ) )

[@ShanesCows]

You need a third option if both are false I am guessing

[@jbizo45]

Hey Shane, First off thank you for the vid super easy to understand. My only problem is about 7:58 into the video where i am editing Dropdown2 code it will give me an error if I type in ".Value" it only gives me the option to type "Result" without an error not sure where my problem is. Thank you in advance!

[@stevegilbey3777]

Yes. Same here. Guess a later release has changed the terminology. It still works though.

[@ShanesCows]

Yeah I think Steve is right.

[@jimmyni1983]

Hi Shane. I started watching your videos today. I am pretty pretty new at Power Apps. So, can you recommend a video where I can learn how to have a dropdown list coming from an excel like in this example, but this excel will fit just for the Company Name dropdown list? In the other side I have a Sharepoint list to be fulfilled with fields: "Company Name", "Date" and "Cash at Bank (K)". So I want to build a simple app with these three fields, but the first one with approach you explained very well here. So, users will choose in the dropdown, then Date and Cash and when hit the button, this values will be recorded in the SharePoint list. Is it possible? So, kind of combine two sources for one solution, in this case fill a Share Point list. Then I will import this list to Power BI and finish with a dashboard. Is there any restriction regarding to total number of lines to be imported to Power BI. Sorry for this long text and if you cannot reply, ok, thanks anyway. Cheers, Jimmy

[@ShanesCows]

This video is exactly that. kzbin.info/www/bejne/nKKrYohmlLmUpKs

[@anthonysaiz1890]

Hello Shane Thank you very much for all your video they help me tu learn about Power Apps! i have a question about two videos you make. one about office365 user and Dropdown. on the first you show a search function on office365, and on this video you take a list personal example. But it is possible to make a dropdown menu with office365user? Thank you for all Anthony

[@ShanesCows]

You could put the users into a collection and then have fun with them.