PowerApps filter gallery by dropdown 

Shane, Love your videos. To the point and with some humor. Learned so much from your work. Thanks!

Thank you Shane, for giving people who have no idea what they are doing the opportunity to impress other people that have no idea what they are doing! Making me look like a rock start!

Awesome stuff Shane!!! I couldn't finish this app without all of your help!

Thank you for hard work you´re has been doing to the rest of the mortals. From two week´s ago, you´re my "Master of Powerapps" (like He-Man was of the universe!). Hugs from Córdoba, Argentine to Cincinnatti.

Thank you for leaving the moments where you have no idea what's going on...I think we spend most of our time in PowerApps in that state! It helps a lot 😊

Awesome Shane, thanks so much for sharing. I've just used this to add filtering to a form in Project Oakdale.

Excellent work as usual, Shane!!

Random comment but I find it funny that every PowerApps teacher on RU-vid always says: "But first, here's the intro!". Its the only time time I've every seen someone introduce an introduction.

Thanks Shane for another great tutorial. I'm developing a big app with power apps using your videos.

Thank you Shane! This was very helpful!!! I appreciate all you do.

Thank you Shane for sharing this link. You rock and I have learned a lot from your videos.

Searched all afternoon for how to do this. Thanks for the great video!

Thank you Shane! I understand the logic behind all this! Thank you!

Thanks so much! Your channel is my usual go-to for power apps and related. All excellent videos.

Thank you, i learned a lot, there maybe some new techniques but i keep on watching your other Videos based on filtering and make my notes. It took me 90min to write down everything and combine that with screenshots. I have a very good docu to your video which i put on my favorite list.

Thanks a lot🤝, much needed video indeed. Keep sharing your wisdom!!

Thank you so much. Had everything I needed :)

Thank you so much Shane, this just saved me hours of figuring out the filter.

Another great video Shane. I do this all the time but I have a slightly different approach. I do the two collections to add the All, but then for each dropdown I have a hidden label with the dropdown result based on the IF. If(Dropdown?.Selected.Result = "All","",Dropdown?.Selected.Result )The my items filter uses Startswith() based on the Labels. I have one Gallery with over 25000 records that has three dropdowns and three Text Input fields. Two of the Text Input are ID fields. This approach allows for a filter for the Gallery to be based on one or all of the fields. I use an IF to use the ID Fields in isolation.

You are a life-saver!

Seriously Shane, thank you! Also, my favorite line that I now use of yours “Why are you mad?!”

Wow wow wow.... finally I prepared my own application with the help of your video... Thanks, Much bro.. Had so many difficulties in between, but I was able to resolve though...

Thank you for sharing ... God bless you man!

Just what I was looking for taking my first baby steps in PowerApps

This is so awesome. Takes a while to wrap the head around it, but it's beautiful. But lots and lots of dropdown filters is complicated.

Thank you for this, I enjoy practicing on your Vedio and I learn a lot. I appreciate how you follow simple approaches and add functionalities gradually, it makes my practice less overwhelming. thank you so much.

I see you went ski/snowboarding recently! Thanks again for this amazing video!

eres un gran profesor ¡GRACIAS!

Brilliant as always. This is exactly the solution I needed

I am building out the option for 3 dropdowns and has seemed very straightforward. It was mentioned at about 23:09 of the video about needing 9 combinations. I can only find 8 combinations and so was inquiring what combination I might be missing. I am having trouble with all data returning for the "All", "All", "All" option, but all other scenarios work. What I have is a label that's doing a SUM of the gallery for a distinct column of data, and so the SUM is not gathering all of the data in the gallery of this column which has been my test for each of the scenarios to make sure it's working.

Great video, Shane. I have (almost) exactly this situation in my app, except a toggle instead of the 2nd drop down. I built the app a few months ago by piecing together content from your other videos and (gasp!) Microsoft’s documentation. It works pretty well, but I look forward to getting back into it to clean it up with the nuggets in this video. Thanks,

Shane this has helped me so much thank you !!

Your videos lead to great learning :)

Thank You Shane! It was very useful for me :)

Awesome video Shane!

This is gold, really liked this video, really helped me alot. Keep up the great content.

You are the best! Thanks!

Thanks Shane... very nice video and fun to watch

Thanks mate, Great video!

Thanku so much Shane, for all your powerapps tutorial

Great as always. Thank you for your job from Ukraine!!!! ))

LOVED THIS!!!!!!!!!!!!!!!!!

Hey Shane, great video once again and I was keen to see this one as I am currently working on a gallery that I want to give users the ability to filter in a number of ways. I would love to know the steps of creating a gallery that is filtered with a combination of dropdowns and a combobox and possibly search as well. So essentially you have two dropdowns where you filter by fields when you only want to select a single record, but then use a combobox for a field where you want to see items relating to multiple records. As an example based on this video, imagine you had a company that had multiple work sites. Here you not only want to find out what an employees favourite colour was and which department they worked in, but you also wanted to know which work site they belonged to. So you could quickly see all the employees in the IT department at say work sites A&B (and not sites C&D) and see what their favourite colours were.....Hope that makes sense

I hit on the like and follow button on duration 22:52. You made it is just not a tutorial, it's you know the student reaction is when he can made it by himself.

Thanks for this. Useful at this date.

I watched timestamp 13:45 to 14:30 on 0.75 speed and it was hilarious. This video saved my butt today. Thank you!

thx mr. shane it is exactly what i looking for :)

Thank you Shane!

Very usefull tutorial. Changed my life

I just want to comment that I had a very hard time with this but it was also due to my own fault, lol. I'm using a region and location from a different source but I'm using the location as the filter. On the OnVisible Property, instead of using Collect for the static record, I had to use another ClearCollect as "All" is already being used in my filter using Distinct. Surprisingly, I didn't have to modify the if statement (after several tries, mind you, lol). Also surprising, I watched this video a little while ago but it didn't HIT me that maybe I should pay closer attention until I decided to tackle the delegation as there's no reason for the icon to show (got that from your other videos). All in all, I was able to successfully add the functions into my app. Anyways, love your videos, they've helped me immensely, and I've shared with fellow app makers your feats. Thanks again!

Wow! Exactly what I was looking for. Thanks Shane. I'm sure Chewy had a hand (paw) in it though. Although, it doesnt work with the OnVisible ClearCollect since my dropdown is based on a choice field 'Category'. Filtering works fine using the first section because you can pull in fieldname.value. Using the ClearCollect OnVisible doesn't seem to offer the 'value' part of the expression. Surprise!! I have to use Choices('listname'.choicefield) so this doesnt work in the OnVisible property in order to setup for "All" SO, for anyone interested or those that have the same issue, this little variation works: [OnVisible] ClearCollect(colCategory, {Value:"All"}); Collect(colCategory, Choices('Grocery Items'.ITEM_x0020_CATEGORY)) [GALLERY ITEMS} If(ddCategory.Selected.Value = "All", 'Grocery Items', Filter('Grocery Items',ITEM_x0020_CATEGORY.Value = ddCategory.Selected.Value)) Obviously I now have to figure out the sorting part.

Great video!

love u sir!. i have been fed up i didn't find any solution. here i fix it.

i really love your videos just wow

Thank you. This is exactly what i was looking for.

Hi Shane . Problem solved. I had to 'un pack' and fine tune my code further 'bit by bit' ( as you suggested), and eventually I got it right. Thanks for your support and tips . Kind Regards Martin

Thanks Shane !

Awesome and very helpful video!! (You got another sub)

Shane-Thanks so much for making this video. This is exactly what I was looking for! Implemented and tested and works exactly as you have described.

Great video Shane! Would love to see how to create a filter experience for users that allows the user to filter their gallery data using 3+ columns. Right now the approach I would use for this scenario uses a lot of IF statements and the logic gets a bit unwieldy. I'm not sure I want to go there.

That was brilliant thank you very much Shane and say hello to your dog Chewy :)

Thanks you, you're the best.

Hi Shane, I'm using a shorter solution that I hope you'll find interesting. Here is an example with 3 Dropdowns : Filter( Requests, If(IsBlank(Dropdownstatus.Selected.Value), true,Dropdownstatus.Selected.Value = Status), If(IsBlank(Dropdowntype.Selected.Value),true,Dropdowntype.Selected.Value = Type), If(IsBlank(Dropdowncustomer.Selected.cre86_name),true,Dropdowncustomer.Selected.cre86_name = Customer.Name) ) Thank you for your videos .

you are the best!

Great video , very helpful

Thank you sir!

Sharing another tactic to show "all". I was able to avoid building a collection to show "all". Instead I used a IF(ISBlank(dropdown),"Standard Filter Gallery without dropdown","Standard Filter Gallery with dropdown". Don't know if better because it doubles the formula length, but accomplishes same functionality.

Thank you for your video :)

Thank you so much for this! You are my favorite person on RU-vid. I've studied this video repeatedly over the past week, and almost have my app functioning perfectly. One problem I'm having is that the collections I built to populate the drop-down menus are wiped when I publish the app (to be clear, it's a connection copied/pasted for each of the drop-downs, then used to build into the "ALL" connections on the Screen's On Visible). Is this because of the ClearConnect function? And if so, how I can fix it? Thank you so much for all of your super helpful videos!!!

I finally managed to do everything you did and more. I am blown away by the way you explain things. Absolutely brilliant. I had difficulties at the start following the steps as my Dropdowns use Complex Columns, and for a newbie like me, it was so hard to figure out. Have your covered relational database like training? Because that will be interesting. Thank you very much.

Pure genius.

Thanks Shane, I would like you to make a video in which you explain how to create an alert to the mail or with push notifications in which you warn that there is some time to reach a deadline, that is, an alert that notifies an upcoming date, greetings from Chile.

awesome！Love your vide！

Thank's alot!!!!!

Thank you sensei

I think I've watched this video every month for the last 6 months, and get a little more out of it each time. Thank you. I am at the point where I might be so bold as to critique. That last Filter with the "And"... I believe multiple logical-tests in a filter are AND-ed, so you could put the two logical tests separated by commas, rather than combined with an And. Maybe there are delegation or performance ramifications?

Love your clear and complex videos! Would it be possible to display the number of persons in each position in the company, next to the combobox label? Example: All (78), IT (2), Executive (1)

Hi Shane, thanks for this tutorial but need some help as im stuck in the collection. When i try to use the CollectVideo to Dropdown Items it doesn't work and shows no data. Hope you could help. Thanks!

I have spotted a couple comments below suggesting an easier method of doing the multiple filters rather than IF testing for All/All, All/Selected, Selected/All and Selected/Selected (which becomes 9 possibilities for 3 dropdowns) using IF statements within the Filter function, but I have got a method that just uses logical functions. Try: Filter(Employees, Department=ddDepartment.Selected.Result OR ddDepartment.Selected.Result="All", 'Favorite Color'.Value=ddColor.Selected.Result OR ddColor.Select.Result="-" ) Essentially each criteria/line of the filter returns True if the column matches the dropdown or the dropdown is All (or "-" or blank [use IsBlank]). Each additional dropdown or search box only adds one more criteria to the filter, don't know if there is a limit but even then you could put each criteria in parentheses with AND between each. I even included the text search function in my app within the filter - actually I forgot about Search when I did it - by adding a third criteria: TextInput2.Text in FirstName OR TextInput2.Text in LastName OR IsBlank(TextInput2.Text) I have got so many tips from your videos, I thought I would give one back.

Thank you

Thank you so much sir ❤️

Hi Shane, great video, really helped me a lot! One last thing I am trying to accomplish is the Search box you included at the end. I have a column called Voyagenumber which contains integers and not text and that's why I can't get it to work. So far I've got the Search( If( //This is for all vessels and all status DDVessel.Selected.Value = "All" And DDStatus.Selected.Value = "All",Voyages, //This is for all vessels and selected status DDVessel.Selected.Value = "All" And DDStatus.Selected.Value "All", Filter(Voyages,Status.Value = DDStatus.Selected.Value), //This is for selected vessel and All status DDStatus.Selected.Value = "All" And DDVessel.Selected.Value "All", Filter(Voyages,Vessel.Value = DDVessel.Selected.Value), //This is for selected vessel and selected status DDVessel.Selected.Value "All" And DDStatus.Selected.Value "All", Filter(Voyages,Vessel.Value = DDVessel.Selected.Value And Status.Value = DDStatus.Selected.Value) ), TextInput1.Text, and this is where it fails. Any tips on how to search on the Voyagenumber column? Much appreciated!

Hi, great video! Unfortunately I'm having difficultly right at the beginning. When I add the dropdown and select my datasource (items=my sharepoint list), it appears that none of my "choice" columns from my sharepoint list appear in the "value" for me to select. For example, I have sharepoint columns = status (new, in progress, closed, on hold), column = priority (critical, high, medium, low), etc...but none of these columns appear for me to select to tie to the dropdown. Any idea what I'm missing?

Hi Shane - this is amazing.... Thank you for always sharing your knowledge with us. CAn you also put some light on using this with SORT function as well. Thanks

Hi! Thank you so much for the video .. Would you happen to know how could I sort the available choices within the drop-down field alphabetically?

Thank you for all your videos Shane, I've watched so many over the last few months! I'm not quite clear on one part of it though - the Delegable part. Will using you method of Distinct, mean that I have to keep my list below 500/2000, or will this solve this problem as the Distinct is outside of the Gallery and it's only getting the values from the dropdown box

Hi Shane! Thanks for the video! lots of good info in it. I have a question, though: If the gallery to which I want to add the dropdown filters to is a nested gallery filtered by a previous gallery already (like you showed in the Learn to use the filter function video), how do I keep the filter and add new ones to it? Thanks!

Oh wow, this answered TONS of questions I had - thank you, Shane! My one dilemma is... what if the Search box is looking for numbers, because when a numeric value is entered there, only employees with that same or greater numeric value should be found? I did hear you say, "Search function only works with text columns" ... do I need to adjust the column in Sharepoint from "Currency" to "Single line of text"?

hi Shane, this is great tutorial, thank you. However, can you advise if you have a video to do the same for larger set of source data? If not using Distinct - how can I filter my data in the Gallery otherwise

Nice one

Hi Shane, Great video as usual!! I built an app from a SPO list and the default Browse gallery "items" has SortByColumns() with Filter(), the sort and filter are both set to "title". Is there a way to change the StartsWith() inside the Filter() to be 2 other columns from my list? I would like to change title in the filter to both "driver" and "Eval Date" Is this possible? The list can grow to thousands of rows, so I have to worry about the delegation issue...

Hey Shane, thanks for all the videos, really getting me up to speed with PowerApp! Question - I have a two column table that I'm trying to apply 3 dropdown filters on to allow the user to keep refining the filter the more dropdowns they apply. Am I on the right track with filter gallery? I've watched some of your other videos (filter multiple selections - Exact or All options - Try again) and I feel like I'm half in one-half in another :). Really appreciate the Channel, Thanks!

Danke!

Shane, thank you for the awesome video. Very helpful. Question.. Is there a way to skip the gallery? If we can assume 2 dropdowns will return max 1 result, can we create a form that returns different columns of that value (assuming it's connected to an Excel in OneDrive)? I know it's doable through Galleries but was wondering if we could use a lookup function in the form instead, with the condition to be that the dropdowns match. Not sure what the "result" would have to be though. Thanks!

Shane, again a great video! I was wondering if the filtering could also be done on collections? I'm using 2 collections, one with the worknumber and one with articlenumbers. I would like the articlenumber collection to show only articlenumbers which depend on the workorder. I can't seem to getr this working. Thanks

Hi Shane: In trying to create a filter, I can't use a field that is "person or group" type from my SharePoint list as items for my dropdown. Under Properties, when I go to look for that 'value', it's not listed as one of the choices from the list of columns from my SharePoint list. What can I do there?

Hi Shane, I implemented the dropdown and text box that filter a gallery. What I try to achieve is that whenever the content of the gallery changes, I want to select the first item. In other words, I want the OnSelect of the first item to be executed. How can I programmatically "click" the gallery's first item in the onchange event of the controls that influence the items selection of the gallery ?

Very helpful

Thanks, Shane; great video as usual. Currently, I'm on a project and I need 3 gallery filters + text (search) filter over ~1000 records on a SharePoint list. It's great that since the last update more and more functions are delegable, but still, it's a PITA having to make so many workarounds to get the data you need with the restricted functions... I have a different workaround for using multiple filters: Filter( Search( COLLECTION_OR_DATA_SOURCe, txtFilter.Text, // Text Control for Searching... "COLUMN_SEARCH1", "COLUMN_SEARCH2", "COLUMN_SEARCH_N" // Add as many columns or fields as you need to find on... ), If( Gallery1.Selected.Result = 0, // Number Filter for a number field, 0 is formatted and shown as "All Items" in gallery control true, FIELD_TO_FILTER = Gallery1.Selected.Result ) , If( Gallery2.Selected.Result = "(All)", // This is a Text Field and that's the description for all Items in the filter true, FIELD2_TO_FILTER = Gallery2.Selected.Result // Works the same for text fields ) , If( GalleryN.Selected.Result = "(All Items)", // Another Text Field, works for as much filters and galleries as needed true, FIELDN_TO_FILTER = GalleryN.Selected.Result ) ) This way I can have as many gallery Filters as needed with a text control to search... All I have to do is adding a reset filters button to clear all the filters with one click... Thanks for all the teachings, I've been following you the last months and won't miss ANY video. Keep it up!

Excelent!