Applies To
SharePoint in Microsoft 365

With dynamic filtering, you can filter one list based on a selection made in another list. In the following example, the Marketing 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 Marketing Documents library. 

Dynamically filtered list

To do this:

  1. On your page, select Edit and add a List web part or a Document library web part then select the list or library with the values you want to filter by.

  2. Add another List web part or a Document library web part and select the list or library that contains the information you want to filter.

  3. Select the list or library web part you want to filter and select Edit properties Screenshot of the properties icon. in the upper-left of the web part.

  4. Under Dynamic filtering, slide the toggle to the On position.

  5. Select the column you want to filter in the field Column in [your list name] to filter.

  6. Under List or library containing filter value, select the list or library you added to your page in Step 1.

  7. Under Column containing the filter value's properties, select the column that has the values you want to filter by.

  8. Select Apply.

    Using the example image at the beginning of section, the Dynamic filtering options for the Marketing Documents library would look like the following:

    Document library with pane open for dynamic filtering options

  9. When you're done, click Save and close at the top of the page, or if you're ready for your audience to see the page, select Republish at the top right of the page.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.