Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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. 

Dynamically filtered list

To do this:

  1. 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.

  2. Add another List web part or a 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 web part Web part edit button on the left side 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, 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 Planning Documents library would look like the following:

    Document library with pane open for dynamic filtering options

  9. 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.

Need more help?

Want more options?

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

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×