1
00:00:03,940 --> 00:00:05,190
[Autogenerated] hi And this lesson, I'm

2
00:00:05,190 --> 00:00:07,580
going to show you how to filter library

3
00:00:07,580 --> 00:00:10,260
items. We're gonna go ahead and we'll go

4
00:00:10,260 --> 00:00:12,940
to our documents library here in our

5
00:00:12,940 --> 00:00:16,170
SharePoint team site. And we have a number

6
00:00:16,170 --> 00:00:18,660
of different types of documents here. We

7
00:00:18,660 --> 00:00:21,500
have all kinds of word documents Excel,

8
00:00:21,500 --> 00:00:25,690
Power Point, even a couple of P d efs. And

9
00:00:25,690 --> 00:00:29,070
we would like to filter out everything in

10
00:00:29,070 --> 00:00:31,820
this document library except the types of

11
00:00:31,820 --> 00:00:34,920
documents that we want to see. We can

12
00:00:34,920 --> 00:00:37,270
filter a document library by any of the

13
00:00:37,270 --> 00:00:40,400
criteria, any of the columns that we have.

14
00:00:40,400 --> 00:00:42,630
We have four columns that we can filter

15
00:00:42,630 --> 00:00:44,550
by. We can filter by the type, which is

16
00:00:44,550 --> 00:00:47,970
this first column. This little icon here

17
00:00:47,970 --> 00:00:50,640
indicates the document type, and we see

18
00:00:50,640 --> 00:00:53,780
the little icons here, next to each name

19
00:00:53,780 --> 00:00:56,830
of the document, weaken filter by the

20
00:00:56,830 --> 00:01:00,570
document name by when they were modified

21
00:01:00,570 --> 00:01:03,860
and who they were modified by. Let's go

22
00:01:03,860 --> 00:01:07,040
ahead and take a look. We're gonna filter

23
00:01:07,040 --> 00:01:11,310
first by the type of document we'll

24
00:01:11,310 --> 00:01:14,160
select. Little icon here will click on

25
00:01:14,160 --> 00:01:17,460
that and we get this little window and we

26
00:01:17,460 --> 00:01:20,030
see that we have the option here to filter

27
00:01:20,030 --> 00:01:23,250
by. We're gonna click there and it opens

28
00:01:23,250 --> 00:01:26,180
up our filter panel and we see the four

29
00:01:26,180 --> 00:01:28,500
different document types we have. We see

30
00:01:28,500 --> 00:01:31,680
its filter by type. Let's say we simply

31
00:01:31,680 --> 00:01:35,100
want to filter by power point documents.

32
00:01:35,100 --> 00:01:36,960
We're gonna go ahead and select that and

33
00:01:36,960 --> 00:01:41,320
click apply. And now we see that our

34
00:01:41,320 --> 00:01:44,570
document library has been filtered and all

35
00:01:44,570 --> 00:01:48,130
we have left that we see our power point

36
00:01:48,130 --> 00:01:51,100
presentations. We look up here at the top.

37
00:01:51,100 --> 00:01:53,400
We see all of these file extensions these

38
00:01:53,400 --> 00:01:56,170
air the different types of power point

39
00:01:56,170 --> 00:01:59,170
presentations that SharePoint recognizes

40
00:01:59,170 --> 00:02:02,970
as being part of this filter. Now, when we

41
00:02:02,970 --> 00:02:06,260
come to the top of our document library

42
00:02:06,260 --> 00:02:10,030
the top of our type column you'll see this

43
00:02:10,030 --> 00:02:12,790
little icon here, this little filter. It

44
00:02:12,790 --> 00:02:14,850
looks like a little funnel, doesn't it?

45
00:02:14,850 --> 00:02:17,080
That's the filter icon that lets us know

46
00:02:17,080 --> 00:02:19,770
that this document library has been

47
00:02:19,770 --> 00:02:23,510
filtered by that criteria. In this case,

48
00:02:23,510 --> 00:02:28,420
it is type we also see when we put on a

49
00:02:28,420 --> 00:02:30,530
filter that are filter. Panel opens up

50
00:02:30,530 --> 00:02:33,500
over here and we see that we have other

51
00:02:33,500 --> 00:02:36,280
filters available to us as well. We have

52
00:02:36,280 --> 00:02:39,440
filters for modified by who The person was

53
00:02:39,440 --> 00:02:42,120
who modified these documents. We can go

54
00:02:42,120 --> 00:02:44,730
ahead and filtered by those. We can also

55
00:02:44,730 --> 00:02:48,010
filter by the date we have a date and time

56
00:02:48,010 --> 00:02:50,250
filter here. But if you look, none of

57
00:02:50,250 --> 00:02:52,580
these have been modified any longer than

58
00:02:52,580 --> 00:02:54,910
an hour ago, so this really isn't gonna do

59
00:02:54,910 --> 00:02:58,620
much for us. But if we had documents that

60
00:02:58,620 --> 00:03:01,020
have been modified, say, a year ago, six

61
00:03:01,020 --> 00:03:03,280
months ago, three months ago, we would be

62
00:03:03,280 --> 00:03:06,340
able to go ahead and use the slider and

63
00:03:06,340 --> 00:03:08,620
filter out that way as well. Or we could

64
00:03:08,620 --> 00:03:12,570
select specific dates as you see here. Now

65
00:03:12,570 --> 00:03:14,810
let's close our filter panel. You see the

66
00:03:14,810 --> 00:03:17,980
little funnel icon again. When I click on

67
00:03:17,980 --> 00:03:21,430
that, my filter panel is closed, and now

68
00:03:21,430 --> 00:03:23,760
we can go back in here and let's say that

69
00:03:23,760 --> 00:03:26,000
we want to take the filter off. We click

70
00:03:26,000 --> 00:03:28,990
on the little funnel icon again here, and

71
00:03:28,990 --> 00:03:32,810
you see that we have under filter by clear

72
00:03:32,810 --> 00:03:35,190
filters. I also want you to notice that

73
00:03:35,190 --> 00:03:38,140
filter by has the number one next to it.

74
00:03:38,140 --> 00:03:40,000
That means we're filtering by only a

75
00:03:40,000 --> 00:03:42,900
single criteria. Let's go ahead and let's

76
00:03:42,900 --> 00:03:47,130
clear the filters and we see that we have

77
00:03:47,130 --> 00:03:50,210
all of our documents back, let's go ahead

78
00:03:50,210 --> 00:03:52,920
and do another filter. But this time let's

79
00:03:52,920 --> 00:03:57,120
go and open up our filter panel and do it

80
00:03:57,120 --> 00:04:00,540
from here. This time, let's filter by

81
00:04:00,540 --> 00:04:04,470
type. Let's choose Excel documents and we

82
00:04:04,470 --> 00:04:06,320
can see the Excel documents that Aaron

83
00:04:06,320 --> 00:04:08,870
this document library and let's add a

84
00:04:08,870 --> 00:04:12,360
second filter. Let's go ahead and let's

85
00:04:12,360 --> 00:04:16,340
filter out by who These documents were

86
00:04:16,340 --> 00:04:19,540
modified. Let's go ahead and let's choose

87
00:04:19,540 --> 00:04:24,210
Gary Coulson and we see that Gary modified

88
00:04:24,210 --> 00:04:27,440
these four Excel documents. So we now have

89
00:04:27,440 --> 00:04:30,610
two filters applied on this document

90
00:04:30,610 --> 00:04:33,150
library, and we can see the little filter

91
00:04:33,150 --> 00:04:37,830
icon at the top of those columns. Now, if

92
00:04:37,830 --> 00:04:39,680
I want to go ahead and clear all these

93
00:04:39,680 --> 00:04:42,850
filters at one time, you see the symbol

94
00:04:42,850 --> 00:04:45,670
right here, little filter. And I know it's

95
00:04:45,670 --> 00:04:47,850
very small and very hard to see, but

96
00:04:47,850 --> 00:04:50,920
there's a tiny little X next to it. If I

97
00:04:50,920 --> 00:04:54,310
click there, it takes all of my filters

98
00:04:54,310 --> 00:04:58,280
off. Now I can also filter by multiple

99
00:04:58,280 --> 00:05:01,270
criteria in a single column. Let's go

100
00:05:01,270 --> 00:05:03,120
ahead and let's filter by type again.

101
00:05:03,120 --> 00:05:06,740
Let's say that we want to filter by P. D

102
00:05:06,740 --> 00:05:12,180
efs and by Power Point presentation. So we

103
00:05:12,180 --> 00:05:14,740
want to hide the excel and word documents.

104
00:05:14,740 --> 00:05:18,390
We can click, apply, and we see that we

105
00:05:18,390 --> 00:05:23,410
have those documents there. Now we can

106
00:05:23,410 --> 00:05:27,500
also go ahead and we can sort Ah filtered

107
00:05:27,500 --> 00:05:29,870
list is well, let's go ahead and let's

108
00:05:29,870 --> 00:05:33,680
sort by the name Now it's already sorted

109
00:05:33,680 --> 00:05:35,840
alphabetically from a disease. So let's do

110
00:05:35,840 --> 00:05:38,170
it Descending from Zito A Let's click

111
00:05:38,170 --> 00:05:42,140
there and you can see now that we're

112
00:05:42,140 --> 00:05:45,090
sorted that way and we have our little

113
00:05:45,090 --> 00:05:47,350
sort symbol, our little downward facing

114
00:05:47,350 --> 00:05:51,440
arrow and we have our filter And again we

115
00:05:51,440 --> 00:05:55,580
can go ahead and we can clear those

116
00:05:55,580 --> 00:05:57,600
filters. And you see now it says filter by

117
00:05:57,600 --> 00:06:01,780
two because we have filtered by P. D EFS

118
00:06:01,780 --> 00:06:04,570
and Power point presentations, we take the

119
00:06:04,570 --> 00:06:07,570
filter off. Our sort is still there. And

120
00:06:07,570 --> 00:06:10,810
remember, we will clear our sort If we

121
00:06:10,810 --> 00:06:15,530
leave the document library and come back

122
00:06:15,530 --> 00:06:21,320
to it, you'll see our sort is gone. So now

123
00:06:21,320 --> 00:06:24,370
you know how to filter library items in a

124
00:06:24,370 --> 00:06:35,000
SharePoint document library. Thanks for listening. And I'll see you next time