Power Apps Dropdown Control - Cascading, Filtering, Allow Empty, Outputs, and more
Вставка
- Опубліковано 5 вер 2024
- Back to basics! Nothing too crazy, just going through the PowerApps dropdown control in nerdy detail to answer a bunch of common questions I get when using this critical control. We do have some fun with a complex collection along the way also. Enjoy PowerApps Cascading dropdowns a couple of different ways.
Power Apps Training training.power...
Bullet tooth Tony was here but 2 years later. Nice one and nice Snatch reference. I was trying to learn to use dropdowns using co pilot but it was confusing. Learned the filter and distinct functions as well from this video.
Thank you, Shane, I try to watch all of your videos, even basic concepts like these, help us to improve our practices. Sometimes due to lack of experience, we use a lot of intermediate variables and excessive processing for things that can be made in an easy and simple way... Sometimes I look back at older apps I've made and almost feel shame for my older self... 😅 Thank you for your hard work and sharing these tutorials, keep it up!
My pleasure Fernando! I agree about looking at old apps. I am in one of mine and it gives me the creeps how much I don't like the way it works. :)
Hi Shane Perrywinkle Blue is the color Brad Pitt wanted for his mom's caravan in Snatch. Nice one. That's one of my favs as well.
Love it when people get my dumb references! 😍
Ya like DAGS
Your videos are always very helpful!! I love how you have fun with it and also show us how to troubleshoot any errors that pop up! Thanks for everything!!
You are welcome Brian. Hope you have a great week.
Man you're the Power Apps GOAT !!!
Thanks 🐶 = 🐐 😂
Super tute man. You simplified and solidified some things I had stumbled upon but I also learned some new stuff too. Lots packed into this vid. Subscribe.
Thanks. I appreciate the support.
There you go. The king og PowerApps with his crown :). Mary christmas to you, Nicola an Chewy
Merry Christmas Frank! 🎅🐶🎄
Thanks, Shane.. You are the Best Teacher!
Thank you Manoj!
“And me ma still needs a caravan. I like to look after me ma. It's a fair deal. Take it.” ~ Mickey/Snatch 🤣
😂🤣😂🤣😂
Great video again thanks Shane, always good to cover over some of the basics. Oh, and Snatch is also one of my favourite movies!
Nice!
Can you please create similar video for cascading dropdown using modern controls?
Kid: "Ya like dags?" Dad: "Ya, I like dags..."
😂
Your videos are so helpful! Thank you so much!!!
Glad to help. 😀 🐶
Great Snatch reference! Fantastic XD Oh, video was fantastic too, but I got very distracted, haha
Thank you Shane! Have a very merry Christmas!
🎅🎄🐶 Thanks and you also!
Thanks Shane nice crown have a blissful Christmas
Thanks Sundra. 🎄🎅🐶🎉😍
Great video Shane. Can you make a video demonstrating how to work with columns that have a nested table and show the relationship.
I have thought about this topic. It is so confusing hard to make a good video on it but I will think more about it.
As usual great video with nice explanation Shane ☺️ Thank you Shane and Have merry Christmas 💐
Thank you and Merry Christmas back at you 🎅
Hi Shane, thanks for all of your clips. I would like to learn how to show all list based on 3 or more drop down list select blank. Many thanks.
ua-cam.com/video/YYizaX6gXW0/v-deo.html
thanks for making these man.
Happy to help
Good one. Keep it going mate
Thanks 🤩
The drop downs used through a canvas app have a LOT of depth and flexibility. Im finding that this is not that case when building a stock model driven app. What do you reckon?
Merry Christmas dude!
Thanks and right back to you! 🐶
I have the cascading log ic working on my form. However, the child value is not being stored in the form or in the Sharepoint list after I save the form.....
Thank you, Shane!! Have a question- Is it possible to extract the selection the user makes and store as a text variable? So if a user selects cat, need to extract that and store as a text variable.
Hi Shane, very helpful video, I was wondering if you had a solution to using Cascading dropdowns with multi-select, using the example from this video could I have it so I could select Blue and Green and have it show all of the secondary colors from both. Thanks!
Yes, but you would have to then use the in operator. This video talks about in ua-cam.com/video/9d3R336y-j8/v-deo.html or this video is more complex concepts ua-cam.com/video/YYizaX6gXW0/v-deo.html with in
Awesome video! Could you make a video on how to fill a dropdown from a datasource ?
is it possible to have a parent ID for multiple types? For example select red but get shades of red and blue and still have the shades of blue when you select blue? Thanks!
can you please do a video for combo boxes as well?
This is probably the best one I have on the topic. ua-cam.com/video/AXAbmy9zYTU/v-deo.html
Thank you so much! Your videos are great!! I have a question. Can a drop down be created referencing a SPOL list where selecting the data will bring in an entire record from the SPOL. For example, I select 1a. from a drop down and it brings in 15 other columns for editing. Any assistance would be greatly appreciated.
15:41 Has umm different... "Data Types" 😎
🤪
Shane, thanks so much for all your great content...you're my first choice whenever I have a problem to solve for my PowerApps tasks
Wondering if there's a setting for a DropDown (for example of a list of countries), so that once I've clicked the down arrow, if I type "S" it will go quickly to the "S" Countries within that dropdown, etc.?
Haven't found mention of it anywhere and wondered if you'd ever needed that in your Apps?
Hi, how do you do the inverse. Change the dropdown default/ value showb based on the text label value? Thanks
Hey u, Shane. I want to give u a kiss !!!!! Thanks for sharing that, man. :D
Happy to help. 🐶
Hi Shane, I am stuck, I have cascading dropdowns and I have the same value in each of the columns, but I don't want users to be able select the same answer twice. How do I remove the ability to select the same value across two lists?
Hi Shane, I'm trying to return an image based on a dropdown selection. In the list the dropdown selection is a Text single line and the image data type is Image. I have too many images and they change too often to create a table in the app itself. I would like it such that, when a dropdown value is selected it returns the image in the image column (this is on the edit form). I would also like the image to appear in the gallery and detail screen as well. Is that possible?
Please tell how can I do this dynamically, because I don't need to give hardcoded
Hi, how can I do that in reverse, as I want my dropdown to be filtered based on a data card value loaded
Hei Shane, I am having problems with the defaul value of the dropdowns when using a form, I dont get any values when having this on default: If(EditForm1.Mode = FormMode.Edit, BrowseGallery1.Selected.Hovedprosess), this only happens when i have a filter on the item of the dropdown, do you know why? item: Filter(Hovedprosesser, VirkID = Dropdown1.Selected.ID)
Hi Shane, i would like to add an extra column so i get 4 levels of cascading, is that even possible? Every filter of distinct i tried, i get error's.
Thanks for the video!
Hoe to get Mouse Hover Dropdown?
It is the Tooltip property for you control. This really old video has the concepts ua-cam.com/video/1tJk7LxgocA/v-deo.html
@@ShanesCows Thanks
Awesome, excelent video!! I have a problem, when I am working with a sharepoint List and try to write the name of a column with complex type of data (multiple choice), a signal error appears, it is not possible to work with complex columns??
ua-cam.com/video/gsk14D-CYRE/v-deo.html 😎
I have watched several of your videos, which by the way are really good and informative, I have also subscribed to your channel bc of this.
I have a question for you bc I am getting closer to finding a resolution by combining a bunch of your videos into one but I haven’t gotten there yet. I think what I want to do is doable but I am very new to Power Apps, as in this is my first time new.
I have been given the task to create a directory of transportation vendors for our users to use. I need to be able to give the user the ability to search by state (I guess dropdown) then by county then by zip code then by mode of transport, and in the results I need them to be able to see the data cards for each vendor that meets the above said search/filtered criteria. They will need to be able to see each vendor that matches the criteria’s name, phone number, email, mode of transport, if they can transport COVID patients, if they are active or not and the vendors hours of operation.
I thought about using the dropdown and cascading feature but the amount of data that needs to be in the selection field is enormous like it would mean entering in 100s of options, especially with the zip codes as this is nationwide. Is there a different way to do this or a different way to get the options in the app? Do you have videos that would help me be able to accomplish this? Also do I create a gallery first and then do the Screens or where do I start? Again very, very new at this.
I do need to use SharePoint as the data source since our 100s of transportation vendor profiles have been loaded in there.
Am creating drop-down for sate and country and when am select state I need to get country name like its reverse cascading is this possible?
I would guess yes. Depends on how your data is organized but I think you could lookup the country for the state
Hi @shaneYoung - Please can you help answer this question for me? I've exhausted Google, and I think the answer in it's standard form, is no.
Three SharePoint lists for three levels of an organisation. Let's say:
National Teams List -> Regional Teams List -> Individual Team Lists
National List just has 1 column with names,
Regional has two columns, 1 with names, 1 with lookup for National
Individual has two columns, 1 with names, 1 with lookup for Regional
In the canvas app I would like to produce three cascading dropdowns that will only show options for based off of the previous option. However, it does not seem possible to filter based off of a dropdown column in SharePoint.
Is this the case?
Thanks :)
You can filter off a dropdown. Filter(Employees, FavoriteColor.Value = "Red") is how I filter by my Choice column. :)
@@ShanesCows Thanks Shane! I appreciate the swift response. The dropdown is based off of a lookup in a SharePoint. The formula errors if you type it all, or if you try and use auto-complete, it does not show the option for the dropdown that is already filtered on a list lookup.
Can you make a video for this case: someone look up in a list an specific gif for example shoes, click and this add in a list .Then choose t- shirt, etc. But all the item was choosen could show all in a list and then keep.
This is a start ua-cam.com/video/aOcQIMvdWW4/v-deo.html it is on my list to remake this topic though :)
The length of my dropdown items are long and doesn't fit in the screen, is there an option to scroll the dropdown or at least wrap the items so they be populated one below the other but the entire item is visible.
Hi! The shortcut doesn't work anymore.. ["Yes", "No", "Maybe"] This is how it typed it,
But it gives me a error
That is exactly what goes in the Items property. Are yo sure you put it in the correct spot.
Yes i followed every single click you did, It works if I only do ["Yes"] but a soon as a enter a , next to it, it gives an error
Hi Shane. I'm hoping you can help. I have a Sharepoint list with the columns laid out with 10 columns. Some columns have more items in than others. So in column 1 some of the values are blank.
When I use the method you've given here, when column 1 appears in Dropdown2, I have some blank values from the "cells" that are blank. I can't seem to find a way of filtering that out as the !IsBlank doesn't work with the Filter function?
Hi @Shane Young, i need your help, is there a video where you created repeated data involving dropdown box, i tried to a repeating form with a dropdown box, but i ccouldnt get pass the ClearCollect part
I haven't done that in a video. Make sure you set the Default for the dropdown and you are storing dropdown.selected.columnname
How do you pick a particular value in a drop-down based on some other action in the screen? e.g. you click a button that says "Dog" and dog appears in a drop-down, click another button that says "Cat" and cat is selected. I'm not asking how to set the default value of a drop-down. If this was JavaScript I'd simply set the SelectedIndex property of a Select object to be a number but I haven't figured out how to do this in PowerApps....
You would set the Default of the Dropdown to be a variable. Then you would set the value of the variable OnSelect of the button. Power Apps is Declarative based not Imperative so you can’t directly change a control.
@@ShanesCows What confuses me is that in the Microsoft docs for Power Apps it says "Default - The initial value of a control *before* it is changed by the user" (my emphasis) yet what you're saying is that Default also changes the value of the crop-down at any time (including after it has been changed by the user).
You are right (I tried what you suggested and it works - thanks!) but the Microsoft docs are confusing. At least they are confusing to me! :-)
Hi Shane, I am new to power apps and struggling. I have two drop downs I would like to cascade, the first I am able to make work, using this formula: Sort(Distinct(reserve_inputs, Business_Unit), Result) the second, using the depends on feature, ends up blanking out my choices: Distinct(Filter(reserve_inputs, Business_Unit = Dropdown_Business_Unit.Selected.Result), GPI_Key) - any idea what I am doing wrong? When I remove the distinct and just try filter, that also doesn't work
Hi , May i know how to add power bi column in that dropdown, any one know please let me know.
Not that I know of
Thanks but this doesn't work for Dropdowns when they're called "datacards" - in other words, I created a PowerApp from a SharePoint list. The dropdowns are called datacards. Why won't it work?
Thanks Shane, When i use the code you showed the cascade works in the form, but nothing submits in the SharePoint list that is associated with the form. Is there something I am missing?
Do you need to update the Update property of your Datacard mabye.
Hi Shane: Thank you for very informative video, However, I have a quick question: I have a dropdown with Question Nos. 1 to 10. Is it possible to select only question numbers that are not answered or are not already selected from that dropdown? Meaning, can we control the dropdown items conditionally?
I have an interesting question, is there any possiblity to make 3 or 4 dependent dropdowns? I mean making 2 is easy but what about 3, or 4?
Yes. Have to creat the logic but it possible. ua-cam.com/video/kLGglidmPxg/v-deo.html
Great video Shane, thank you! I've been able to use these methods successfully with a text input search providing the answer in the dropdown field but I'm struggling with one issue. Power apps isn't recognizing the column in my Excel spreadsheet with numbers. All the text columns come in fine but the one I need to populate in the dropdown is the one missing: EmployeeNumber. I've tried formatting the Excel column for both text and number to no avail. What do I need to do to be able to pull this column in and select it in Power Apps? Thanks for your help!
Elizabeth I have no idea... I don't know why that column wouldn't show up. Maybe try typing the name in directly and see if that makes it happier. For Items: ExcelTable.NumberColumnName
@@ShanesCows I'll try it! Thank you and Happy Holidays!
Hi Shane, I am just trying to work out if it is possible to have cascading dropdowns that include an "All" button in the secondary dropdown. Taking your example, it would be dropdown = blue, dropdown two = All (with all other options being types of blue). What do you think? Is it possible?
Yes. You would need to create a condition logic to deal with the scenario but should be possible.
@@ShanesCows Thanks for responding so quickly, how do you think it might work? I tried doing an if statement to say If(dropdown one = allPrimaryColours, collectAllSubColours, filter XYZ). However the dropdown doesn't seem to like it. Both elements work and it works for a simple label so I'm a bit confused. Any advise on how to tackle it?
how to input the dropdown values into excel database on onedrive?
Nice video Shane. I have excel spreadsheet imported into Microsoft SharePoint and trying to use PowerApps in order to get a useful dataSource management. For example, first row of the excel spreadsheet is my first selection which contains several values. I would like to create first drop down list using the first row elements (values) of excel. (That is the first dropdown list). And Depending on selected value (lets say A50, which is header of the excel table), then I want all the values under that header to appear (e.g. A51, A52, A53, etc...) as drop down list on the second drop down list. And I have some more drop down lists I need to create. I have been struggling to do it. Any help??? Thanks...
Figured it out myself :) It took me couple hours though.....
Glad you got it!
ne, I'm trying to create an app which simply has several dropdown boxes in which I choose a different thing from each one. I'm only just starting out with power apps so know nothing about it really. I have managed to create a layout I want, however I have to type in everything I want in each box, not dropdown selection. Can you point me to a video that will help me create a simple dropdown box app please?
Many thanks
Sorry I am behind on comments. Did you get it figured out? If you want the user to type in values then you will most likely want to use a Text Input, Dropdowns are for selecting predetermined values.
@@ShanesCows I'm getting there I think. Thanks.
Hello Shane, I am Lautaro from Argentina. Could you do a Power App video with the following subject?
Subject: Power Apps form to create new items in a SharePoint list embedded into a SharePoint Site
Maybe this one? ua-cam.com/video/Badj3_T8zAw/v-deo.html
Hi Shane, What a useful video again :-) ... I tried this new tool in one of my applications. The cascading works well and I am able to select the correct item but when I update the record by Submit function, the value of the field is not updated in my SharePoint list (this "Contact" field in the list where I post my recod is a lookup field based on another list). Do I have to go through a PATCH? Have a very merry Christmas with all people you love !
You don't have to use Patch. ua-cam.com/video/fqH1U0_TanI/v-deo.html That old video might be helpful. YOu will have to use what you learned here with the concept there but I think that should do it for you.
@@ShanesCows Hi Shane, first of all I wish you all the best for you and your family for this new year 2021 !!! I saw the viedo you advised to me but this one don't bring me the solution. As explained, the filter of the dropdown work well but even if I select an item in the list, the update don't work at the time of the subit of the form. The updating should update a lookup field in a sharepoint list adn I expect that is the problem. In the update setting of the datacard, I am not able to put "Dropdown1.selected.value" because "value" is not available. After "Dropdown1.selected." powerapps propose the name of all field of the sharepoint list where the record should be created. But if I choose the field where I have to post the value of the dropdown1, the formulas become not valid. I expect I have to work with the ID of the idem choosen in the dropdown1 but I don't know how :-(
Handy 🛠
Thanks 😊
NO WAY!!! You have a wife......out shopping?
Not me. 😂