1 00:00:04,200 --> 00:00:05,980 [Autogenerated] high in this lesson. I'm 2 00:00:05,980 --> 00:00:07,930 going to show you how to filter a 3 00:00:07,930 --> 00:00:11,260 SharePoint list I have here. My employee 4 00:00:11,260 --> 00:00:14,220 lists were on our HR team site and there's 5 00:00:14,220 --> 00:00:16,260 a lot of records in this list. If I go 6 00:00:16,260 --> 00:00:18,820 ahead and scroll all the way down, you can 7 00:00:18,820 --> 00:00:21,760 see that we have quite a few names on this 8 00:00:21,760 --> 00:00:24,890 list. I believe there's something like 100 9 00:00:24,890 --> 00:00:28,930 and 15 people on this list. Now, I wanna 10 00:00:28,930 --> 00:00:30,420 make that a little smaller. I want to 11 00:00:30,420 --> 00:00:33,630 shorten that list. I wantto filter out 12 00:00:33,630 --> 00:00:36,190 everything that I don't need to see all of 13 00:00:36,190 --> 00:00:38,130 the records I don't want. So what I'm 14 00:00:38,130 --> 00:00:40,440 gonna do is I'm going to scroll over here 15 00:00:40,440 --> 00:00:42,550 to the right a little bit more, and I'm 16 00:00:42,550 --> 00:00:44,790 gonna filter by location. I'm gonna just 17 00:00:44,790 --> 00:00:47,640 look for people who work in a particular 18 00:00:47,640 --> 00:00:50,120 location. So we're going to click here on 19 00:00:50,120 --> 00:00:53,040 the little drop down arrow and it opens up 20 00:00:53,040 --> 00:00:55,810 my pop up window Now right in the middle. 21 00:00:55,810 --> 00:00:58,770 You'll see I have the option to filter by. 22 00:00:58,770 --> 00:01:01,360 And when I click there, the filter panel 23 00:01:01,360 --> 00:01:03,190 opens up here on the right, and it says 24 00:01:03,190 --> 00:01:05,320 filter by location, which is exactly what 25 00:01:05,320 --> 00:01:09,850 I want and I can pick any one or more off 26 00:01:09,850 --> 00:01:11,690 these locations. I'm going to start with 27 00:01:11,690 --> 00:01:16,790 one. I'm gonna pick 60159 click, apply, 28 00:01:16,790 --> 00:01:19,510 and you'll see that my fiddler panel here 29 00:01:19,510 --> 00:01:21,820 is opened up now. But let's close that for 30 00:01:21,820 --> 00:01:25,520 right now. And we come here and we see 31 00:01:25,520 --> 00:01:29,010 that we have filtered out a lot of people. 32 00:01:29,010 --> 00:01:31,120 We have a much shorter list now, and they 33 00:01:31,120 --> 00:01:35,890 all are at location 60159 Now, let's open 34 00:01:35,890 --> 00:01:38,290 up that filter panel again. And you see, 35 00:01:38,290 --> 00:01:40,120 it also gives me other options to filter 36 00:01:40,120 --> 00:01:42,480 bike unfiltered by the first name. That's 37 00:01:42,480 --> 00:01:45,980 kind of silly. Last name again. Probably 38 00:01:45,980 --> 00:01:49,130 not very useful. I d numbers again. This 39 00:01:49,130 --> 00:01:52,010 should all be individual. Identify IRS and 40 00:01:52,010 --> 00:01:54,610 then location. Now, it's not showing me 41 00:01:54,610 --> 00:01:57,510 any more options. So this filter panel, if 42 00:01:57,510 --> 00:02:00,430 you have a lot of columns, isn't the best 43 00:02:00,430 --> 00:02:04,090 way to go ahead and make more filters. 44 00:02:04,090 --> 00:02:05,520 What we're gonna do is we're gonna close 45 00:02:05,520 --> 00:02:08,290 that and we're gonna filter again. But 46 00:02:08,290 --> 00:02:10,130 before we do that, I want you to take a 47 00:02:10,130 --> 00:02:12,910 look at the top of our location column. 48 00:02:12,910 --> 00:02:14,720 You see that little symbol? It looks like 49 00:02:14,720 --> 00:02:17,230 a funnel. That lets me, though, that my 50 00:02:17,230 --> 00:02:20,730 list is filtered and it's filtered by this 51 00:02:20,730 --> 00:02:25,000 criteria by this column location. Now, if 52 00:02:25,000 --> 00:02:28,100 I want to apply another filter, let's go 53 00:02:28,100 --> 00:02:30,510 ahead. I want to apply the department 54 00:02:30,510 --> 00:02:33,460 filter. I can go and click here, click on 55 00:02:33,460 --> 00:02:37,610 filter by and choose a department. So 56 00:02:37,610 --> 00:02:40,490 within the location within that store, 57 00:02:40,490 --> 00:02:44,290 60159 I can choose an individual 58 00:02:44,290 --> 00:02:47,640 department. Let's choose customer service. 59 00:02:47,640 --> 00:02:51,840 Click apply, and we see that we have two 60 00:02:51,840 --> 00:02:55,690 people who work in customer service at 61 00:02:55,690 --> 00:03:03,060 60159 And if I close my panel here and 62 00:03:03,060 --> 00:03:05,510 take a look, we see that we have the 63 00:03:05,510 --> 00:03:10,510 filter icon on both of those columns, 64 00:03:10,510 --> 00:03:12,590 letting me know that again this list has 65 00:03:12,590 --> 00:03:16,790 been filtered by these two criteria. Now, 66 00:03:16,790 --> 00:03:18,670 if I want to take one of these filters 67 00:03:18,670 --> 00:03:22,400 off, I can click on the drop down and you 68 00:03:22,400 --> 00:03:26,330 see I have an option to clear filters and 69 00:03:26,330 --> 00:03:28,910 see it only cleared that one filter. I 70 00:03:28,910 --> 00:03:33,780 still have my 60159 filter on, and I can 71 00:03:33,780 --> 00:03:40,820 go over there and clear that filter. Let's 72 00:03:40,820 --> 00:03:45,010 do that again. And it didn't clear it that 73 00:03:45,010 --> 00:03:46,680 time. And now when I go back, look at 74 00:03:46,680 --> 00:03:49,430 this. I don't have a clear option that 75 00:03:49,430 --> 00:03:51,960 happens sometimes. But don't panic. We're 76 00:03:51,960 --> 00:03:54,900 gonna go back here, click on our filter 77 00:03:54,900 --> 00:03:56,940 icon so that we can open up the filters 78 00:03:56,940 --> 00:03:59,960 pain and you see this little icon here 79 00:03:59,960 --> 00:04:03,000 Clear filters as a little. It's very 80 00:04:03,000 --> 00:04:05,130 small, but there's a little tiny X next to 81 00:04:05,130 --> 00:04:07,980 the funnel. If I click that, that will 82 00:04:07,980 --> 00:04:12,100 clear all of the filters all across my 83 00:04:12,100 --> 00:04:16,870 list. Now let's go ahead and let's Let's 84 00:04:16,870 --> 00:04:21,240 do that again. Let's filter again. Let's 85 00:04:21,240 --> 00:04:27,910 filter by department. Let's do sales 86 00:04:27,910 --> 00:04:32,440 associate, Click apply and we see. Yeah, 87 00:04:32,440 --> 00:04:35,800 we have a lot of sales associates. Now, 88 00:04:35,800 --> 00:04:39,070 when I have a filter on, I can also apply 89 00:04:39,070 --> 00:04:43,140 a sort. Let's go ahead and let's sort 90 00:04:43,140 --> 00:04:47,110 within the sales associate. Let's sort by 91 00:04:47,110 --> 00:04:57,220 location and you see, we are now sorted a 92 00:04:57,220 --> 00:05:07,420 sending by location within that filter 93 00:05:07,420 --> 00:05:09,620 again. If we want to go ahead and clear 94 00:05:09,620 --> 00:05:12,580 that filter, we can go here and it takes 95 00:05:12,580 --> 00:05:15,770 it off. But are sort is still on its just 96 00:05:15,770 --> 00:05:22,460 now applied to the entire list. So that's 97 00:05:22,460 --> 00:05:33,000 how you filter a SharePoint list. Thanks for listening, and I'll see you next time