How to Fix SharePoint Gallery View Disappearing with Lookup Columns
Question details
The user's SharePoint gallery view completely disappears or fails to render when an automatically populated lookup column is added to the view.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Customizing a SharePoint list with a gallery view that includes automatically populated lookup columns linked to other lists.
- Observed behavior
- The gallery view disappears when specific lookup columns are included, even though the standard list view displays the columns correctly without any issues.
Ensure you have full control or design permissions for the SharePoint site so you can create new test lists and modify view settings.
Create a Minimal Test List and Rebuild
Create a fresh test list to determine if the rendering issue is isolated to the structure of the original list.
Since the issue often affects specific lists with complex histories or structures, building a clean, minimal test environment helps isolate whether the problem is a universal tenant bug or a localized list corruption.
Navigate to your SharePoint site homepage, click 'New', and select 'List' to create a blank test list.
Add the exact primary lookup column and the automatically populated secondary columns (e.g., 'Programme name' and 'Assigned') that are failing in your main list.
Click the view options menu in the upper-right corner, select 'Create new view', choose 'Gallery', and include the lookup columns.
If the gallery view works perfectly on the test list, the original list structure is likely corrupted. Recreating the list and migrating the data can serve as a functional workaround.

Escalate to Microsoft Support
If the issue persists or rebuilding the list is too disruptive, contact Microsoft Support for a backend fix.
A Free, Lightweight Alternative for Document Management
While SharePoint lists can sometimes present complex rendering bugs and require administrative support, WPS Office offers a streamlined, lightweight, and highly compatible alternative for handling your everyday data tracking, spreadsheets, and document creation without the hassle.
- 1. Download the installer: Visit the official WPS Office website and download the free version for your operating system.
- 2. Install the application: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
- 3. Manage your files: Open WPS Spreadsheet or Document to easily track data and manage files offline or via seamless cloud sync.

Frequently Asked Questions
Why does my lookup column work in List View but not Gallery View?
SharePoint uses different UI rendering mechanisms for List and Gallery views. A known backend issue can cause automatically populated lookup columns to disrupt the specific JSON formatting required to render gallery cards, even though standard tabular list views handle them fine.
Can I fix the disappearing gallery view without recreating the whole list?
Sometimes simply toggling the column visibility off and on in the view settings can temporarily refresh the view. However, if it's a structural bug, you will likely need a SharePoint administrator to escalate the issue to Microsoft Support for a permanent fix.
What are automatically populated lookup columns in SharePoint?
These are secondary columns linked to a primary lookup column. When a user selects a value in the primary column from another list, SharePoint automatically fetches and displays the related data in these secondary columns.




