SharePoint Document Issues

How to Filter Microsoft Lists Views by Manager or Organizational Structure

Tauseeq Magsi Oct 28, 2026 868 views

Question details

A user needs to configure a Microsoft List on SharePoint so that managers can view tasks assigned to their direct reports, with the view updating dynamically as organizational roles change.

How to Filter Microsoft Lists Views by Manager or Organizational Structure

Product: Microsoft Lists
Device & OS: not provided
Scenario: Filtering task management lists in SharePoint so that leaders can automatically see what their direct subordinates are working on.
Observed behavior: The user requires a dynamic view filter that recognizes organizational structure, updating automatically when employees join, leave, or change teams instead of relying on manual filter adjustments.

Before you start

Ensure you have 'Edit' or 'Full Control' permissions on the SharePoint list, and verify that your organization's Microsoft 365 Azure Active Directory (Entra ID) is accurately populated with reporting hierarchies.

Solution 1Recommended

Add a Manager Column and Use the [Me] Filter

This solution involves adding a specific column to track the manager for each task, allowing you to use SharePoint's built-in filtering to show items relevant only to the currently logged-in manager.

While standard SharePoint list views cannot natively read an Active Directory organizational chart for dynamic filtering, you can achieve a similar result by stamping the manager's name onto the list item and filtering by the current user.

Create a Person column for Managers

Navigate to your Microsoft List on SharePoint. Click on 'Add column', select 'Person', and name the new column 'Manager'. Ensure 'Allow selection of groups' is turned off if you only want individual managers.

Populate the Manager data

Edit your list items to ensure the 'Manager' column correctly reflects the manager of the person assigned to the task. This step can be done manually or automated using a Power Automate flow.

Edit the List View

Click the view selector dropdown in the upper-right corner of your list and choose 'Edit current view' (or create a new view specifically for managers).

Apply the [Me] dynamic filter

Scroll down to the 'Filter' section. Select 'Show items only when the following is true'. Choose the 'Manager' column from the first dropdown, set the operator to 'is equal to', and type exactly '[Me]' in the value box.

Save the view

Click 'OK' at the top or bottom of the page to save. When any manager opens this view, they will automatically see only the tasks where they are listed as the manager.

Add a Manager Column and Use the [Me] Filter

Keeping Data Updated: If an employee changes teams, the 'Manager' field on their existing tasks will not update automatically. Consider using Power Automate to keep this field synced with your organization's directory.

Solution 2

Implement Dynamic Filtering Using Power Apps

For a truly dynamic solution that reads your organization's hierarchy in real-time, build a customized list interface using Microsoft Power Apps.

Free Microsoft Office alternative

Manage Team Data and Tasks Effectively with WPS Office

While automated dynamic organizational views rely heavily on Microsoft 365 ecosystem tools, you can easily track team assignments, manage project rosters, and collaborate on task data using WPS Spreadsheet. WPS Office is a highly compatible, lightweight, and completely free alternative to Microsoft Office.

1. Export your List: From your Microsoft List, click 'Export' > 'Export to Excel' or 'Export to CSV' to download your task data.
2. Open in WPS Spreadsheet: Launch WPS Office, open the downloaded file, and navigate to the 'Data' tab on the ribbon.
3. Apply Filters: Click 'AutoFilter' to enable dropdowns on your headers, allowing you to instantly filter tasks by specific team members, statuses, or managers offline.

Fully compatible with Microsoft Excel formats (.xlsx, .csv) for seamless SharePoint data export and editing.Includes robust Data AutoFilter, Advanced Filter, and Pivot Table features for precise task tracking by manager.Lightweight application that runs smoothly on Windows, Mac, and Linux systems.A completely free core office suite covering Writer, Spreadsheet, and Presentation.

Frequently Asked Questions

Can SharePoint list views natively filter by manager organizational chart out-of-the-box?

No. Standard SharePoint list views do not natively support filtering by an Active Directory reporting structure. You can only dynamically filter by the current logged-in user using the [Me] tag on a Person/Group column.

Does the Manager column update automatically if an employee changes teams?

No, if you are using a static 'Manager' Person column, the data remains as it was originally entered. You must either manually update the column when a team change occurs or set up a Power Automate flow to sync it.

How can I automate the population of the Manager column?

You can create a Power Automate flow triggered by 'When an item is created or modified'. Use the 'Get manager' action from the Office 365 Users connector based on the 'Assigned To' email, and then use the 'Update item' action to fill the Manager column automatically.

Document & File Issues