How To Filter a SharePoint Online List

This tutorial will show you how to filter a SharePoint list. Specifically, this SharePoint tutorial will show you how to filter a SharePoint Online list using the quick filter, the filter pane, and by editing or creating a SharePoint view. This SharePoint tutorial will also show you how to remove a filter from a SharePoint list and how to filter a SharePoint list based on multiple conditions or criteria. Filtering a SharePoint list based on multiple columns or conditions allows you to build sophisticated queries to reduce your SharePoint list to a specific data set. This tutorial will also show you how to filter a SharePoint list when working in the modern SharePoint experience and the Classic SharePoint experience.

🔔GO FROM SHAREPOINT LIST AMATEUR TO EXPERT IN 90 MINUTES🔔

Timeline
0:00 – Start
0:50 – Filter a SharePoint list using the quick filter in modern SharePoint experience
1:40 – Remove a filter from a SharePoint list in modern SharePoint experience
3:27 – Filter a SharePoint list using the filter pane in modern SharePoint experience
6:15 – Filter a SharePoint list based on multiple columns or criteria in modern SharePoint experience
9:45 – Remove a filter from a SharePoint list Filter view
10:00 – Filter a SharePoint list based on multiple columns or conditions
13:40 – Filter a SharePoint list in classic SharePoint experience
15:30 – Filter a SharePoint list based on multiple columns or criteria in classic SharePoint experience

#SharePoint #Microsoft365 #sharepointonline

-MORE ABOUT ME-

LETS BE FRIENDS:

GOT A VIDEO IDEA? FILL OUT THIS FORM:

:
📧 PRODUCTS THAT I USE TO CREATE MY YOUTUBE VIDEOS:

SOFTWARE THAT I USE TO CREATE MY YOUTUBE VIDEOS & CONTENT:

OTHER SERVICES THAT I USE:

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

[ernest]

Lui, this is the most niche topic ever, and I thank you sincerely for making it.

[yvonnemairose]

Love this vid! Do you have a recommendation on how to add a search box to a list when using it in teams?

[yvonnemairose]

Great video, would you have one to help to re-instate filters to a list when users have removed all filters available for a list view?

[freddie]

Thanks Lui, do you also know how to set a filter on a mulitvalue column using 'contains' ? I have this column which can contain multiple values. I'd like to have a view filtered, showing all records containing a certain value.

Thanks!

[luqetdo]

Thank you! this is the best video online to date!!

[rubalsingla]

Hello sir I have one query. How I filter charts using dropdown in sharepoint with list data

[johnbrennan]

Great video I have heard you can only filter 20 thousand rows in Share Point Lists is this true ?

[binhannguyen]

Thank you sir,
Can you show how to change the order of the item? Not fiter it, I just want to change the order.

[sophiaromano]

Hi Lui, I am having an issue with my filter. I am working in the modern online SharePoint list where I am filtering the vendor column. Without the filter on, there are multiples rows with a particular vendor name I am looking to search for. When I select the vendor filter to filter for that particular vendor, nothing comes up. When I select two vendors names at the same time only then will the first vendor I selected then come up. It seems to only be doing this with this vendor name in particular. All the other vendors seem to be working correctly. Any ideas what it could be? I haven't had much luck finding anything online.

[richardteniente]

Sir, I want to add a filter to sort out items that are [Today]+90 and [Today]+60 how do i do this?

[yogalayang]

Hello Lui, thanks for the helpful video. I actually tried to apply some of your filtering methods but unfortunately I encountered this problem in my SharePoint List where it displays "null" when I'm applying filters. The filter function itself still works properly, but weirdly it shows null in the filter information just after the list name. How can I solve this issue so it will display the proper filter I'm applying?

If I am to illustrate it, it looks something like this in my Sharepoint List.

Correct Display
MyListName > Date > Shift (Shift 1, Shift 2, Shift 3)

But instead it displays as
MyListName > null > null

[musicandmountains]

How do we Select All w/o programming??