Others

How to Filter Custom Columns in Microsoft Lists Board View

Rana Garcia Oct 9, 2026 869 views

Question details

The user needs a way to filter items by custom columns while working within the Board view in Microsoft Lists, as the default filter panel only supports a limited set of built-in fields.

How to Filter Custom Columns in Microsoft Lists Board View

Product: Microsoft Lists
Device & OS: not provided
Scenario: Attempting to filter task cards or list items in the Board view using specific custom fields.
Observed behavior: Individual custom column filter buttons are missing by design in the Board view, with built-in filters limited to fields such as Assigned to, Status, Priority, and Start date.

Before you start

Ensure you have the necessary edit permissions for the list views and identify the exact internal field name of the custom column you wish to filter.

Solution 1Recommended

Configure Filter Settings in the List Views Menu

The most permanent way to filter a Board view by custom columns is to modify the view's underlying configuration settings.

By modifying the backend view settings, you can permanently apply custom filter criteria to your Board view without relying on the front-end filter panel.

Open List Settings

Click the gear icon in the top-right corner of Microsoft Lists and select 'List settings'.

Select the Board View

Scroll down to the 'Views' section at the bottom of the settings page and click on the specific name of your Board view.

Set Custom Filter Criteria

In the 'Filter' section, select 'Show items only when the following is true'. Choose your custom column from the dropdown list, set the condition (e.g., 'is equal to'), and enter the required value.

Save the View

Click 'OK' at the top or bottom of the page to save your changes. Your Board view will now load with the custom filter applied automatically.

Configure Filter Settings in the List Views Menu

Solution 2

Use URL Parameters to Pin the Custom Filter

You can manually apply custom filters using URL parameters and pin them directly to the Board view filter panel for quicker access.

Solution 3

Switch to a List-Based View for Immediate Filtering

If you need to filter custom columns quickly without changing backend settings, switch temporarily to a standard list-based view.

Free Microsoft Office alternative

Manage Data Efficiently with WPS Office

While Microsoft Lists is built for specific list management scenarios, tracking and analyzing complex datasets is often easier in a dedicated spreadsheet. WPS Office provides a free, highly compatible alternative to Microsoft Office, featuring robust spreadsheet capabilities for detailed filtering, sorting, and data visualization.

1. Export Your List: In Microsoft Lists, click the 'Export' button and select 'Export to Excel' to download your dataset as a CSV or Excel file.
2. Open in WPS Spreadsheet: Launch WPS Office and open your exported file to access advanced, highly customizable column filtering options.

Fully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formats.Advanced spreadsheet filtering and pivot table tools to handle complex custom data.Lightweight desktop and mobile applications that use minimal system resources.Familiar user interface requiring zero steep learning curves for rapid deployment.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I filter custom columns directly in the Board view UI?

By design, Microsoft Lists restricts built-in Board view filters to specific fields such as Assigned to, Status, Priority, and Start date. Native front-end filter buttons for custom columns have not yet been implemented for the Board view.

What custom field types work with the URL filtering workaround?

The URL parameter workaround is confirmed to work reliably with People, Text, and Choice columns. However, managed metadata fields or highly complex calculated columns may not remain pinned in the filter panel after applying the workaround.

How do I find the exact internal field name for my column?

You can locate a column's internal name by opening List settings, clicking on the specific column's name, and inspecting the URL in your browser. The internal name is the text located at the very end of the URL, directly after the 'Field=' segment.

Office Quick Solutions