SharePoint Document Issues

How to Fix SharePoint Gallery View Disappearing with Lookup Columns

Aamir Naveed AkramAamir Naveed Akram Oct 23, 2026 869 views

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.

How to Fix a SharePoint Gallery View That Disappears with Lookup Columns
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.
Before you start

Ensure you have full control or design permissions for the SharePoint site so you can create new test lists and modify view settings.

Solution 1Recommended

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.

1
Create a test list

Navigate to your SharePoint site homepage, click 'New', and select 'List' to create a blank test list.

2
Recreate the lookup columns

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.

3
Test the gallery view

Click the view options menu in the upper-right corner, select 'Create new view', choose 'Gallery', and include the lookup columns.

4
Rebuild the affected list

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.

Create a Minimal Test List and Rebuild
Data Migration Notice: Rebuilding a list containing substantial information used by others can be difficult. It should only be done if immediate resolution is required while waiting for official support.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and download the free version for your operating system.
  2. 2. Install the application: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
  3. 3. Manage your files: Open WPS Spreadsheet or Document to easily track data and manage files offline or via seamless cloud sync.
Highly compatible with Microsoft Office formats including Word, Excel, and PowerPoint files.Lightweight desktop application that avoids complex cloud rendering bugs.User-friendly interface that requires no advanced backend configuration.Completely free for everyday document creation and data management.
microsoft office alternative - wps office

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.