SharePoint list view filter not working

How to filter SharePoint lists dynamically

By João Ferreira Feb 2, 2021 Office 365, SharePoint 0 Comments

SharePoint List web part available in modern SharePoint pages is provided with a filtering option that allows you to dynamically filter the data from one list using data stored in another list.

In this article I will show you how you can take advantage of this feature with, explaining all the steps using a predefined scenario to filter the company offices based on their location.

1. Start by adding two List web parts to a SharePoint page
   
2. In one of the web parts select the Office lists and in the other one select the Locations list
3. Edit the web part showing the Office list and turn on the Dynamic filtering option
4. Select City in the Column in Offices to filter
5. Select Locations in the List or library containing the filter value
6. Select Title in the Column containing the filter value
   In the following image you will notice that my title column has been renamed to City, this was made to make the relation between both lists easy to understand. If you dont know how to rename the default title column have a look here.
   
7. Click Apply and save your page

In the following animation you can see how the Location list filters the data in the Offices list dynamically on click.

Now that you understood how the dynamic filtering works, adjust the scenario to your requirements and start filtering the data in your lists.