SharePoint Document Issues

How to Fix Blank Lookup Results in Microsoft Lists or SharePoint

Olivia Miller Oct 1, 2026 869 views

Question details

Users need to resolve an issue where lookup fields in Microsoft Lists or SharePoint do not display related results, even though they can access and edit other items.

How to Fix Blank Lookup Results in Microsoft Lists or SharePoint

Product: Microsoft SharePoint and Microsoft Lists
Device & OS: not provided
Scenario: Viewing or editing list items that contain lookup columns linked to other SharePoint lists.
Observed behavior: Lookup fields fail to display related data and appear completely blank for multiple users across several columns.

Before you start

Verify that the source list where the lookup data originates actually contains the expected values and has not been recently deleted or modified.

Solution 1Recommended

Verify Lookup Source Permissions and Column Configuration

Ensure that users have the correct permissions for the source list and that the lookup column is correctly mapped.

For a lookup column to display data correctly, the user viewing the list must have at least 'Read' permissions to the source list. If permissions are restricted, the lookup values will appear blank to those users.

Check source list permissions

Navigate to 'Site contents', locate the source list, and click the three dots to access 'Settings'. Under 'Permissions for this list', ensure the affected users or groups have at least Read access.

Verify column configuration

Go to the settings of the list experiencing the blank fields. Click on the affected lookup column and confirm it is pointing to the correct source list and the correct column within that list.

Confirm source values

Open the source list directly and verify that the items in the referenced column are not blank or corrupted.

Verify Lookup Source Permissions and Column Configuration

Permission Inheritance: If the source list has unique permissions (broken inheritance), you must manually grant access to users who need to see the lookup data in the destination list.

Solution 2

Escalate to Microsoft 365 Support

If the issue affects multiple users and several lookup columns simultaneously, it is likely a tenant-level service degradation requiring Microsoft's intervention.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While waiting for Microsoft Support to resolve your SharePoint and Lists tenant issues, consider using WPS Office. It is a highly compatible, lightweight, and free alternative for managing your documents, spreadsheets, and presentations both offline and via cloud storage.

1. Download and install: Get WPS Office for free from the official website and install it on your device in minutes.
2. Open Microsoft formats: Open your existing .docx, .xlsx, and .pptx files directly without worrying about formatting loss.
3. Save and share: Edit your documents and save them locally or share them via integrated cloud services.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formatsFree to use with a familiar, easy-to-navigate user interfaceLightweight application that runs smoothly on various devicesBuilt-in PDF editing and powerful document collaboration tools

Frequently Asked Questions

Why are my SharePoint lookup columns suddenly showing blank?

This typically occurs due to removed permissions on the source list, a corrupted column mapping, or a backend Microsoft 365 service issue affecting your specific tenant.

Do users need special permissions to see lookup column data?

Yes. Users must have at least 'Read' access to the source list where the lookup data is stored. If they lack these permissions, the lookup fields will render blank.

Can I fix a tenant-wide SharePoint lookup issue myself?

If you have already verified that permissions and column configurations are correct, you cannot fix a backend service issue yourself. A Microsoft 365 administrator must open a support ticket with Microsoft to investigate the tenant logs.

Document & File Issues