Fix SharePoint Lookup Column Not Finding Documents in Library
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.

- 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.
Verify that you have the appropriate permissions to view the target document library and that the documents are checked in and published.
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.
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.
Reach out to your organization's IT administrator or Microsoft 365 global admin, providing them with screenshots of the empty lookup column dropdown.
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.

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. Download WPS Office: Visit the official WPS website and click the download button for your operating system.
- 2. Install the Application: Run the downloaded installer file and follow the simple on-screen instructions.
- 3. Open Your Documents: Launch WPS Office and directly open your existing Microsoft Office files without needing any conversion.

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.




