Others

Fix "Cannot Read Properties of Undefined" Error in Microsoft Lists

WPS Content Manager Sep 30, 2026 869 views

Question details

Users need to resolve a JavaScript error that prevents them from viewing or accessing their data in Microsoft Lists.

How to Fix "Cannot Read Properties of Undefined" in Microsoft Lists

Product: Microsoft Lists
Device & OS: not provided
Scenario: Attempting to access or apply filters in the modern Microsoft Lists experience.
Observed behavior: The list fails to load and displays a "Cannot read properties of undefined (reading forEach)" error when a filter for blank or empty values is applied to a field.

Before you start

Before attempting to fix this issue, verify whether you have owner or administrator permissions for the list, as you may need elevated access to modify a broken default view if it locks you out.

Solution 1Recommended

Remove the Blank Value Filter from the List

Removing the filter that targets empty or blank values is the most direct workaround to resolve this known bug in the modern list experience.

This error is primarily triggered by a bug in the new style of Microsoft Lists when attempting to parse fields with no content. Clearing the problematic filter will immediately restore access.

Open the affected list

Navigate to your Microsoft Lists dashboard and open the list that is displaying the error message.

Access the filter pane

Click on the filter icon located in the top-right corner of the list view to open the active filters panel.

Clear blank value filters

Locate any filters that are explicitly set to show 'Empty' or 'Blank' values. Click 'Clear all' or uncheck the specific blank criteria.

Save the view

Once the list populates successfully, save the view to ensure the error does not return on your next visit.

Remove the Blank Value Filter from the List

List Access Restored: After removing the empty value filter, your list data should become immediately visible without triggering the JavaScript error.

Solution 2

Switch to an Alternative View

If the default view is broken and triggers the error immediately upon loading, switching to a different view can help you bypass the issue.

Solution 3

Request Administrator Intervention

If the error prevents the list from loading entirely and standard users are locked out, a SharePoint or IT administrator must intervene.

Free Microsoft Office alternative

Manage Your Data Smoothly with WPS Spreadsheet

While Microsoft Lists can experience disruptive bugs with blank value filters, WPS Spreadsheet offers a highly stable, lightweight, and completely free alternative for tracking data, managing lists, and sorting records. Enjoy a familiar interface and seamless compatibility without the recurring subscription costs.

1. Download WPS Office: Install the free WPS Office suite on your preferred operating system.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet to create a new data list or import your existing Excel files.
3. Filter data effortlessly: Use the robust built-in Data Filter tools to sort and manage your records, including blank values, without encountering JavaScript errors.

Stable data filtering and sorting tools optimized for error-free list managementSeamless compatibility with Microsoft Excel (.xlsx, .xls) and CSV formatsLightweight desktop application that runs smoothly on Windows, Mac, and LinuxFamiliar user interface that requires zero learning curve for Office users

microsoft office alternative - wps office

Frequently Asked Questions

Why does the "reading forEach" error happen in Microsoft Lists?

This is a known bug in the modern Microsoft Lists experience. It triggers a JavaScript error when the system attempts to process a view that filters a specific field for blank or empty values.

What should I do if the error completely locks me out of the list?

If the error crashes the page and prevents you from accessing the filter menu, you must ask a site owner or IT administrator to access the list settings directly via a SharePoint backend URL to edit or delete the problematic view.

Will Microsoft release a permanent fix for this filtering bug?

Since this has been identified as a bug within the modern list interface, Microsoft is expected to release a patch. In the meantime, avoiding filters on blank values or switching to the classic experience are the best workarounds.

Office Quick Solutions