SharePoint Document Issues

How to Fix SharePoint People Column Filters Not Working

Aamir Naveed Akram Sep 30, 2026 868 views

Question details

The user needs to fix a multi-selection People column in a SharePoint list that has stopped filtering data properly.

How to Fix SharePoint People Column Filters Not Working

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Filtering data records within a specific SharePoint list using a multi-selection People column.
Observed behavior: The filter fails to apply or return correct results on the original list, even though the exact same filter setup works perfectly on newly created lists.

Before you start

Ensure you have 'Edit' or 'Full Control' permissions for the affected SharePoint list so you can modify view settings and create test columns.

Solution 1Recommended

Create a Test People Column to Isolate the Issue

Determine if the filtering problem is isolated to the specific column's configuration or if the entire SharePoint list is corrupted by creating a new test column.

By duplicating the column setup within the same list, you can verify if the backend indexing or column metadata is broken for that specific field.

Add a new column

Navigate to your affected SharePoint list, scroll to the right of your column headers, and click on 'Add column'.

Select Person or Group

Choose 'Person or Group' (the People column type) from the dropdown menu and click Next.

Enable multiple selections

Name the test column, toggle 'Allow multiple selections' to 'Yes' so it matches the broken column, and click Save.

Test the filter

Populate the new test column with user data in a few rows, then click the column header to apply a filter. If filtering works, compare its exact settings with the original broken column.

Create a Test People Column to Isolate the Issue

Check List Settings: If the test column also fails, the issue is likely tied to the overall list configuration, such as exceeding the List View Threshold (5,000 items).

Solution 2

Recreate the List Configuration

If testing confirms the original list is bugged and cannot be fixed by adjusting column settings, migrating the list data may be required.

Free Microsoft Office alternative

Manage Your Exported SharePoint Data Easily with WPS Office

While resolving backend SharePoint list errors may require Microsoft Support, you can seamlessly open, manage, and filter your exported list data offline using WPS Office. As a lightweight and highly compatible alternative to Microsoft Office, it handles complex datasets and filtering with ease.

1. Export from SharePoint: Export your broken SharePoint list to a CSV or Excel file using the Export button in the command bar.
2. Open in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet module, and load your exported SharePoint data file.
3. Filter your data: Navigate to the Data tab and click 'Filter' to easily sort and search through your exported People column records.

Fully compatible with Microsoft Excel (.xlsx) and CSV files exported from SharePoint lists.Advanced offline filtering and data analysis tools to manage your multi-selection column data.Lightweight installation with a familiar, easy-to-navigate tabbed interface.Completely free for everyday spreadsheet, document, and presentation tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why do multi-selection columns often fail to filter in SharePoint?

Multi-selection columns use complex backend data structures in SharePoint. Filtering can break due to list view threshold limits (over 5,000 items), indexing restrictions, or backend database caching errors after list modifications.

Can I index a multi-selection People column to fix filtering?

No. SharePoint does not allow multi-value columns, including multi-selection People columns, to be indexed directly. This inherent limitation is often the root cause of filtering issues on large lists.

How do I report a persistent list bug to Microsoft Support?

If a new column and new list both fail to filter correctly, gather sanitized details of your list configuration, column settings, and the number of items in the list. Submit these details through your Microsoft 365 Admin Center to open a support ticket.

Document & File Issues