SharePoint Document Issues

Fix SharePoint Lookup Column Not Finding Documents in Library

Rana GarciaRana Garcia Oct 29, 2026 871 views

Question details

Users are unable to see or search for files when using a SharePoint lookup column linked to a document library, despite the column being created successfully.

How to Fix SharePoint Lookup Column Not Finding Documents in a Library
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Attempting to link or search for documents in a SharePoint list using a lookup column pointing to a document library.
Observed behavior
The lookup column displays no files or returns inconsistent search results based on modified date, although linking to the document ID column works as a fallback.
Before you start

Verify that you have the appropriate permissions to view the target document library and that the documents are checked in and published.

Solution 1Recommended

Contact Microsoft 365 Support for Investigation

Since this is a reproducible backend behavior in SharePoint Online where lookup columns fail to display filenames, the issue requires intervention from Microsoft.

This issue is a known behavior where lookup columns linked to a document library fail to display items in the list form or Edit Grid view, even in the Classic experience. Changing the lookup to the ID column works temporarily but does not offer a practical user experience for selecting files by name.

1
Verify the Issue Details

Navigate to the list settings and confirm that changing the lookup column to target the 'ID' instead of the filename displays the file ID values successfully. This verifies the connection exists but the text metadata is failing to load.

2
Contact Your Administrator

Reach out to your organization's IT administrator or Microsoft 365 global admin, providing them with screenshots of the empty lookup column dropdown.

3
Open a Support Ticket

Request the administrator to log into the Microsoft 365 Admin Center, navigate to the Support section, and open a support ticket so the Microsoft development team can investigate the lookup column issue in your specific tenant.

Contact Microsoft 365 Support for Investigation
Temporary Workaround: While waiting for a resolution, you can set the lookup column to pull the document 'ID' if users only need a numerical reference to the file.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While waiting for Microsoft to resolve complex SharePoint issues, you can ensure your daily document tasks remain uninterrupted with WPS Office. It is a lightweight, highly compatible alternative that handles all your standard document needs without the hassle.

  1. 1. Download WPS Office: Visit the official WPS website and click the download button for your operating system.
  2. 2. Install the Application: Run the downloaded installer file and follow the simple on-screen instructions.
  3. 3. Open Your Documents: Launch WPS Office and directly open your existing Microsoft Office files without needing any conversion.
Seamlessly open, edit, and save Microsoft Word, Excel, and PowerPoint files without formatting loss.Enjoy a familiar, user-friendly interface that requires zero learning curve.A lightweight application that runs smoothly on almost any device.Completely free alternative for handling everyday office tasks efficiently.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint lookup column show IDs but not filenames?

This is a known issue within SharePoint Online where lookup columns linked to a document library fail to retrieve and display text-based metadata like filenames. The numerical ID column is processed differently in the backend, which is why it continues to display.

Can I fix the SharePoint lookup column issue myself?

Unfortunately, if the column is configured correctly but still fails to display documents in modern or classic views, this is a backend issue. You will need your Microsoft 365 administrator to contact Microsoft Support for a tenant-level investigation.

Are there any alternatives to using a lookup column for documents?

As a workaround, you can use a standard hyperlink column to manually link documents to list items, or use SharePoint's document property features to tag files with list metadata directly, avoiding the lookup column entirely.