PowerApps filter gallery by dropdown

In this video, you will learn how to filter your gallery using one dropdown, two dropdowns, and a search box. Lots of fun to be learned here. We also cover the distinct function and the collect function along the way.
Power Apps training at training.PowerApps911.com

[@andrewcunning1680]

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

[@ShanesCows]

I didn’t know anyone did it besides me? 100+ videos of doing it most of my viewers expect it. 🐶

[@TheGoodBook777]

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!

[@ShanesCows]

Awesome Peter! 🤩

[@darkmatter2484]

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

[@ShanesCows]

Thanks Martin. 😎

[@louiscutmore]

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 😊

[@ShanesCows]

You’re welcome. Several people have told me that my issues help them connect the dots. 😎

[@johnpoulin807]

Oh yes... I totally agree!!!

[@MrEk5150]

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

[@ShanesCows]

Glad it helps Eric!

[@dvk003]

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.

[@ShanesCows]

Thanks Diego. I loved that cartoon🐶

[@NicholasBrady87]

Excellent work as usual, Shane!!

[@ShanesCows]

Thanks!

[@alexmcla]

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

[@ShanesCows]

Nice Job Alex.

[@DavideGalloni]

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

[@ShanesCows]

Awesome

[@CohoChaos]

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

[@ShanesCows]

Glad I could help!

[@jaredt.4048]

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

[@ShanesCows]

Glad it was helpful!

[@MrBijusammathew]

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

[@ShanesCows]

My pleasure!

[@jt9228]

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

[@ShanesCows]

Great to hear!

[@moserbua]

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.

[@ShanesCows]

Happy to help!

[@johnharris2353]

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

[@PaoloMiguelCPajadan]

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

[@ShanesCows]

Glad to help. 😀

[@Drew7795]

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

[@ShanesCows]

Glad it helped you!

[@kireetiyakkali]

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

[@ShanesCows]

My pleasure 😊

[@enzym2004]

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.

[@ShanesCows]

I have a better way now 🤩 kzbin.info/www/bejne/fKTXnGNpmJ6Xmck

[@georgehill4514]

Thank you so much. Had everything I needed :)

[@ShanesCows]

Glad it helped!

[@latrobe15]

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.

[@ShanesCows]

Thanks for sharing Mark 😎

[@jonathanchen6652]

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

[@ShanesCows]

Glad to help. 😀 Need more sunscreen 😀

[@darranpage9569]

Shane this has helped me so much thank you !!

[@ShanesCows]

Happy to help. :)

[@emraansense9478]

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

[@SLVRFX-lx5lm]

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

[@ShanesCows]

Thanks. You might like this later video that shows and even easier way to do it. :) kzbin.info/www/bejne/fKTXnGNpmJ6Xmck

[@robertorodriguez8186]

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

[@qqqqhuz]

You are a life-saver!

[@ShanesCows]

Happy to help

[@josephdsilva4941]

Your videos lead to great learning :)

[@ShanesCows]

Glad you like them!

[@tiffanyharris711]

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

[@ShanesCows]

Awesome 😍

[@RekikA]

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.

[@ShanesCows]

Glad it was helpful!

[@sytzebuz]

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

[@ShanesCows]

Glad to help. 😀

[@milinprkh]

Awesome video Shane!

[@ShanesCows]

Thanks!

[@jimfitch]

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,

[@ShanesCows]

Glad to help Jim

[@mlaurie4064]

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

[@ShanesCows]

Glad I could entertain 😂

[@DENtvCork]

Brilliant as always. This is exactly the solution I needed

[@ShanesCows]

Awesome sauce!

[@DENtvCork]

@@ShanesCows I ran into one small problem since I added the dropdowns. When a user filters the items and then clicks and goes to the details screen and comes back, the text search is still there but the dropdown's are back to All. Would I need to set a variable and pass it in as the default value or is there a simple tip. Or maybe I set something wrong somewhere when creating?

[@DENtvCork]

@@ShanesCows I just seen the solution further down in the comments by Joseph.

[@reemapandit3330]

Thanku so much Shane, for all your powerapps tutorial

[@ShanesCows]

My pleasure!

[@chanchaijongpreechaharn2052]

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.

[@ShanesCows]

Thank you, glad it helped. 😎

[@rudyversteeg1]

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

[@ShanesCows]

Glad you enjoyed it

[@jesus.moreno]

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

[@ShanesCows]

Glad it helped you. 😎

[@antoniokimble5286]

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!

[@ShanesCows]

Glad you got it and thank you for sharing with others so everyone learns. 🐶

[@POLEW1]

Thanks mate, Great video!

[@ShanesCows]

Glad to help. 😀

[@johnpoulin807]

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.

[@ShanesCows]

Great to hear!

[@mikematthews4150]

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

[@ShanesCows]

Glad it was helpful!

[@mikematthews4150]

@@ShanesCows Is there a way to use the text searchbox filter and the dropbox filter but change the text searchbox to allow partial search? for instance i previously used this "Filter('NTF Lookup',TextSearchBox1.Text in Title1,"Title")" when only using my searchbox and it would partial text search, but i have been unable to convert this into the format you used at the end of the video for using a searchbox and some dropboxes. My current search that does not allow partial looks like this "Search(Filter('NTF Lookup',Resolved.Value = dropdown1.Selected.Value),TextSearchBox1.Text,"Title")"

[@mikematthews4150]

now that i am looking at that i think fiddled with it so much the original working search in script looks like it is no longer the same that i had before.

[@brendanc3705]

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

[@ShanesCows]

It does. I will have to think about a future more complex video. The In function will help you in the meantime

[@jeffersonromero366]

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

[@ShanesCows]

🙏

[@peterli8326]

Great video!

[@ShanesCows]

Glad you enjoyed it

[@mellocamilo]

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

[@ShanesCows]

Thanks a million! 🐶

[@kharchenko28]

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

[@ShanesCows]

Happy to help

[@Negi_From_Pauri]

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

[@ShanesCows]

Glad I could help

[@raphaeloalves]

You are the best! Thanks!

[@ShanesCows]

Thanks 😊

[@ergo9763]

Very usefull tutorial. Changed my life

[@ShanesCows]

Awesome

[@anasimg1210]

i really love your videos just wow

[@euclidesdejes]

Thanks for this. Useful at this date.

[@ShanesCows]

Awesome 😎

[@carlw]

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.

[@ShanesCows]

Thanks for sharing!

[@jeremyweaver2908]

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.

[@AgarPointOfficiel]

Thanks you, you're the best.

[@ShanesCows]

You're welcome!

[@dianapineda3196]

eres un gran profesor ¡GRACIAS!

[@ShanesCows]

De nada 😀

[@jonathancopin8093]

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 .

[@jonathancopin8093]

I didn't see Derek Shannon used quite the same solution ^^'

[@ShanesCows]

Very nice. Thanks for sharing. 😀

[@RudyBaroudi]

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

[@ShanesCows]

Thanks and will do!

[@Duthay]

Thank you Shane!

[@ShanesCows]

Glad to help.

[@martinargimon730]

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

[@ShanesCows]

Good job Martin. I am proud of you for breaking it down. 🐶

[@billkuhn9886]

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.

[@ShanesCows]

One day I will cover it. One day. 😑 So many videos I need to do. 😀

[@AhmedBalfaqih]

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.

[@ShanesCows]

Maybe this will help? kzbin.info/www/bejne/oJ7LaZibhrt0f8U

[@fari658]

Hi I am using a sharepoint dropdown field in my PowerApps Dropdown but it is not able to pick up this sharepoint field (it is picking up other text fields though). How can I solve this? Thanks

[@njabuloskosana785]

Great video , very helpful

[@ShanesCows]

Glad to hear it!

[@hkk3681]

you are the best!

[@ShanesCows]

Thanks 😊

[@carlosabella6583]

Thanks Shane !

[@ShanesCows]

Happy to help

[@hernanrodriguez8382]

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.

[@ShanesCows]

I would use flow for that. Sounds like a great video.

[@hazelservilla4296]

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!

[@belitadsouza3839]

Thank you for your video :)

[@ShanesCows]

You are welcome 🙏

[@carieandree3933]

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?

[@haleysparkspereira]

Thank you so much for this! You are my favorite person on KZbin. 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!!!

[@pauladams3907]

Pure genius.

[@ShanesCows]

Thanks Paul

[@christophkeunecke3644]

Thank's alot!!!!!

[@M87user]

Hi Shane. I have a dropdown based on a choice column (status for production). My dropdown items hence is set to: Choices('Production Calendar'.Status) , this returns 3 values. Not Results. How should I modify the: 'ClearCollect(collectStatus, {Result: "All"}); so that the dropdown list 'All' as well?

[@sivakumar04]

Greattttt...

[@rivernet62]

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?

[@ShanesCows]

You are correct about the , and the And being the same thing. I don’t believe one way or the other affects anything though. I believe they are the same

[@redwinmedia]

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?

[@clare5967]

awesome！Love your vide！

[@ShanesCows]

Thanks 😊

[@stephanebouillon2538]

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 ?

[@tengnbiiga]

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)

[@leroimendez2650]

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?

[@edgarabud2721]

Excelent!

[@ShanesCows]

Thanks

[@bobleach]

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

[@ShanesCows]

Distinct is not delegable 😕

[@piyushlamba1134]

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

[@ShanesCows]

Put SortByColumns around the filter part of the formula.

[@piyushlamba1134]

@@ShanesCows thank you 👍🏾

[@mikepoirier2897]

@@ShanesCows Could you provide the syntax on how to do it? I'm just starting out with PowerApps, and these tutorials are teaching me a lot.

[@karolinaunderwood1039]

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

[@millievanilli3695]

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"?

[@ShanesCows]

You might have to in order to make search work

[@joeffischer9241]

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

[@L84DNR]

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!

[@ShanesCows]

Hey Mike I think you are headed the right way. Good luck. 😀

[@mattprice1459]

Hey Shane. I am having this issue, I initialize a collection On Visible, and I also have the All added. I am even able to filter through stuff using the combo box. However, the drop down has the correct number of slots, and each does what it should, except there is no text, so you have no idea what you are clicking on. Any idea what I may have done wrong, or how to fix this?

[@gelagabrielamarinescu6888]

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!

[@ShanesCows]

Yikes, not sure i have a quick answer for that one.

[@randyarmy03]

Thank you sir!

[@ShanesCows]

Happy to help

[@youngcarlsbad]

Hi Shane, Wondering how you were able to pull the employee profile pictures into the gallery. Is there a video available where you cover this? Thanks in advance!

[@gabrielmens4956]

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!

[@ShanesCows]

I think you could put the LookUp formula in the Item property of the gallery. Makes sense in my head. Hope you got it figured out already.

[@frenske2002]

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

[@ShanesCows]

Yes everything I show should work exactly the same on collections or any table from any datasource

[@yespeekayarts]

hi shane, i could see the clearcollect not triggering propely on onvisible of screen. Any workaround for this

[@stephanedebarbanson1706]

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!

[@ShanesCows]

You can only Search text columns 😕

[@debarbansondataconsultancy]

@@ShanesCows many thanks for the swift reply and such a shame it’s not possible. I’ll let them search on some other variables then to decrease the gallery overview results. Thanks!

[@michaelbsog]

When I use the first drop down box, and build the function in OnVisible as you have, the collection evaluates with "All" under the "Result" column and nothing in a "Value" column for that row. The is has my choices in the "Value" column of the next few rows, with nothing in the "Result" column.

[@bomluccah1997]

Hi @Shane ~ tried to use your example but somehow even though my fields do not have single quotation in the excel file that was later converted to a SharePoint List, whenever I try to use the same formula, it was giving errors due to having single quotation on both side of each column (i.e. Column1 changed into 'Column1') ... whenever I tried to remove the single quotation ... well the red line was all over the forrnula. Thank you!

[@franknielsen3219]

Remember one or your videos where you said "Now you can see my phone number, so you all can phone me and tell me how awesome I am". Don´t need til call you for that, i´ll just putt it in here ;)

[@kellymccolgan3603]

Hi, I don’t know if this is possible... I am trying to create a search but essentially using drop down to filter categories. When I try to do this my column from share point doesn’t come up as an option... is it because it is a drop down that lets you select multiples? Therefor is it not possible or do you have a video that covers this? Thanks kelly