SharePoint Document Issues

Fix SharePoint Lookup Column Not Showing Items in a Form

Natalie Taylor Oct 10, 2026 869 views

Question details

Users report that SharePoint lookup columns are blank or fail to display selectable items in standard forms, even though the data appears correctly in grid view.

How to Fix SharePoint Lookup Column Not Showing Items in a Form

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: A user is trying to select an item from a lookup column dropdown within a standard SharePoint form.
Observed behavior: The lookup column works in grid view, but the dropdown shows no selectable items in the form. Permissions and list structures remain unchanged, and new lookup columns exhibit the exact same issue.

Before you start

Before escalating the issue, verify that your user account has at least 'Read' permissions for the source list and clear your browser cache to rule out local rendering problems.

Solution 1Recommended

Contact Microsoft 365 Admin for Backend Support

If permissions are correct and the issue persists across different users and newly created columns, it is likely a tenant backend service issue requiring Microsoft Support.

Forum support and local troubleshooting cannot inspect or resolve tenant backend environment issues. If the lookup column fails to render selectable items strictly in forms while grid view functions normally, an administrator must intervene.

Identify your Microsoft 365 Admin

Reach out to your organization's IT department or the designated Microsoft 365 administrator who has access to the admin portal.

Access the Admin Center

Ask the administrator to log into the Microsoft 365 admin center using their administrative credentials.

Navigate to Support

On the left-hand navigation menu, have them click on 'Support' and then select 'Help & support'.

Create a Support Ticket

Submit a new service request detailing the SharePoint lookup column issue, specifying that it works in grid view but fails in the standard form despite correct permissions.

Contact Microsoft 365 Admin for Backend Support

Information: Providing your Microsoft Support representative with details about when the issue started and confirming that new columns have the same problem will speed up the troubleshooting process.

Solution 2

Verify Source List Permissions

Perform a preliminary check to ensure that a recent permission change on the source list isn't preventing the form from fetching lookup items.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

Dealing with complex Microsoft 365 and SharePoint backend issues can disrupt your daily workflow. If you need a reliable way to manage your offline and cloud documents without heavy backend dependencies, WPS Office provides a lightweight, highly compatible, and user-friendly alternative.

1. Visit the Official Site: Go to the official WPS Office website on your computer or mobile device.
2. Download the Installer: Click the 'Free Download' button to get the latest lightweight installer.
3. Install and Work: Follow the on-screen instructions to install the software and open your Microsoft Office documents instantly.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Lightweight application with fast loading times and a familiar user interface.Integrated cloud storage options to easily collaborate without complex SharePoint setups.Completely free to download and use for essential office productivity tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint lookup column work in grid view but not in the form?

Grid view and standard forms utilize different methods to query and render data. A backend service sync issue or a temporary Microsoft 365 service degradation can cause the form to fail when fetching the lookup items, even while grid view reads the raw list data successfully.

Can I fix a backend SharePoint lookup column error myself?

No. If the issue stems from the Microsoft tenant backend environment and persists across newly created columns and different user accounts, local troubleshooting will not work. You must contact your Microsoft 365 Administrator to open an official support ticket.

Does the list item threshold affect SharePoint lookup columns?

Yes, if the source list you are querying exceeds the SharePoint list view threshold (typically 5,000 items), it may block lookup columns from displaying items in standard forms. Checking your source list size is an important preliminary troubleshooting step.

Document & File Issues