With dynamic filtering, you can filter one list based on a selection made in another list. In the following example, the Planning Documents library is filtered by a selection in the Project Information list. The "Marketing" value in the Project Team column is selected, so only documents owned by the Marketing team are displayed in the Planning Documents library.
To do this:
-
On your page, add a List web part or a Library web part and select the list or library with the values you want to filter by.
-
Add another List web part or a Library web part and select the list or library that contains the information you want to filter.
-
Select the list or library web part you want to filter, and select Edit web part on the left side of the web part.
-
Under Dynamic filtering, slide the toggle to the On position.
-
Select the column you want to filter in the field Column in [your list name] to filter.
-
Under List or Library containing filter value, select the list or library you added to your page in Step 1.
-
Under Column containing the filter value, select the column that has the values you want to filter by.
-
Select Apply.
Using the example image at the beginning of section, the Dynamic filtering options for the Planning Documents library would look like the following:
-
When you’re done, click Save as draft at the top of the page, or if you're ready for your audience to see the page, select Publish at the top right of the page.