[Autogenerated] high in this lesson. I'm
going to show you how to filter a
SharePoint list I have here. My employee
lists were on our HR team site and there's
a lot of records in this list. If I go
ahead and scroll all the way down, you can
see that we have quite a few names on this
list. I believe there's something like 100
and 15 people on this list. Now, I wanna
make that a little smaller. I want to
shorten that list. I wantto filter out
everything that I don't need to see all of
the records I don't want. So what I'm
gonna do is I'm going to scroll over here
to the right a little bit more, and I'm
gonna filter by location. I'm gonna just
look for people who work in a particular
location. So we're going to click here on
the little drop down arrow and it opens up
my pop up window Now right in the middle.
You'll see I have the option to filter by.
And when I click there, the filter panel
opens up here on the right, and it says
filter by location, which is exactly what
I want and I can pick any one or more off
these locations. I'm going to start with
one. I'm gonna pick 60159 click, apply,
and you'll see that my fiddler panel here
is opened up now. But let's close that for
right now. And we come here and we see
that we have filtered out a lot of people.
We have a much shorter list now, and they
all are at location 60159 Now, let's open
up that filter panel again. And you see,
it also gives me other options to filter
bike unfiltered by the first name. That's
kind of silly. Last name again. Probably
not very useful. I d numbers again. This
should all be individual. Identify IRS and
then location. Now, it's not showing me
any more options. So this filter panel, if
you have a lot of columns, isn't the best
way to go ahead and make more filters.
What we're gonna do is we're gonna close
that and we're gonna filter again. But
before we do that, I want you to take a
look at the top of our location column.
You see that little symbol? It looks like
a funnel. That lets me, though, that my
list is filtered and it's filtered by this
criteria by this column location. Now, if
I want to apply another filter, let's go
ahead. I want to apply the department
filter. I can go and click here, click on
filter by and choose a department. So
within the location within that store,
60159 I can choose an individual
department. Let's choose customer service.
Click apply, and we see that we have two
people who work in customer service at
60159 And if I close my panel here and
take a look, we see that we have the
filter icon on both of those columns,
letting me know that again this list has
been filtered by these two criteria. Now,
if I want to take one of these filters
off, I can click on the drop down and you
see I have an option to clear filters and
see it only cleared that one filter. I
still have my 60159 filter on, and I can
go over there and clear that filter. Let's
do that again. And it didn't clear it that
time. And now when I go back, look at
this. I don't have a clear option that
happens sometimes. But don't panic. We're
gonna go back here, click on our filter
icon so that we can open up the filters
pain and you see this little icon here
Clear filters as a little. It's very
small, but there's a little tiny X next to
the funnel. If I click that, that will
clear all of the filters all across my
list. Now let's go ahead and let's Let's
do that again. Let's filter again. Let's
filter by department. Let's do sales
associate, Click apply and we see. Yeah,
we have a lot of sales associates. Now,
when I have a filter on, I can also apply
a sort. Let's go ahead and let's sort
within the sales associate. Let's sort by
location and you see, we are now sorted a
sending by location within that filter
again. If we want to go ahead and clear
that filter, we can go here and it takes
it off. But are sort is still on its just
now applied to the entire list. So that's
how you filter a SharePoint list. Thanks for listening, and I'll see you next time