Fix SharePoint Bulk Edit Not Showing All Metadata Columns
Question details
Users are unable to view or edit specific document-set metadata columns in the bulk edit pane of modern SharePoint document libraries.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to update multiple documents simultaneously using the bulk edit properties pane in a modern SharePoint library.
- Observed behavior
- Certain metadata columns fail to appear in the bulk edit pane, despite being available for sorting. This issue may occur in specific libraries even if identically configured libraries on the same site work correctly.
Ensure you have Site Owner or Full Control permissions for the affected SharePoint library to access content type settings and library configurations.
Verify Document Set Content Type and View Settings
Check the library configurations to ensure the required site columns are properly inherited and not set to hidden in the affected library.
Inconsistencies often occur when a site column is not properly pushed down to the specific library's content type. Comparing the affected library's settings with a working one can isolate the discrepancy.
Navigate to the affected document library, click the Settings (gear) icon in the top right, and select 'Library settings', followed by 'More library settings'.
Under the 'Content Types' section, click on the Document Set content type to verify that the missing columns are listed and their status is not set to 'Hidden'.
Open the settings of a functioning library in a separate tab. Compare the inherited site columns, column ordering, and default view settings to identify and correct any differences.

Use Edit in Grid View as a Workaround
Bypass the bulk edit properties pane by editing the metadata directly in the list view.
Escalate to Microsoft Support
If all configurations match a working library perfectly and grid view is not an acceptable long-term solution, the issue may be a backend synchronization bug.
Handle Your Documents Smoothly with WPS Office
While SharePoint backend bugs can occasionally disrupt metadata management, local document editing shouldn't be a hassle. WPS Office provides a seamless, robust environment for editing your downloaded or synced documents with full Microsoft compatibility.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Open Synced Documents: Navigate to your OneDrive or SharePoint synced folder on your PC and open the files directly using WPS Office.
- 3. Edit and Save: Make your edits locally. When you save, the synchronization client will automatically upload the updated compatible formats back to SharePoint.

Frequently Asked Questions
Why do some columns appear in SharePoint sorting but not in the bulk edit pane?
This can occur due to content type synchronization delays, custom JSON column formatting that isn't supported in the properties pane, or if the column was inadvertently set to 'Hidden' within the library's specific content type settings.
Does the 'Edit in grid view' feature always show all metadata columns?
Yes, 'Edit in grid view' will display and allow you to edit all columns that are currently added and visible in your active library view, making it a reliable alternative when the bulk edit pane fails.
Can custom Power Apps forms affect the bulk edit pane in a SharePoint library?
Yes, if a document library form has been customized using Power Apps, it can sometimes interfere with or override the default rendering of the bulk edit properties pane, causing certain fields to disappear.




