SharePoint Document Issues

How to Find Who Changed a SharePoint Library Column

Partner Editor Sep 28, 2026 870 views

Question details

The user needs to find out which specific user modified the settings or properties of a column within a SharePoint document library.

How to Find Who Changed a SharePoint Library Column

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Tracking changes to library schema, such as a managed metadata field being altered or multiple values being disabled in a column.
Observed behavior: Standard SharePoint audit logs often do not clearly identify who changed a document library column, requiring alternative methods to track the modification.

Before you start

Ensure you have Site Owner or Administrator permissions in SharePoint, as standard users cannot access full library settings or compliance audit logs.

Solution 1Recommended

Check Item or Library Version History

Use SharePoint's built-in version history to track modifications to specific list items or files and see who made the changes.

If a specific document's metadata was changed because of a column update, you can often trace the user responsible by looking at the version history of affected items in that library.

Navigate to the library

Open your SharePoint site and navigate to the document library or list where the column change occurred.

Select an affected item

Hover over a document or item that has the modified column data, click the three dots (Show actions) next to the file name.

Open Version History

Select 'Version History' from the context menu to open a dialog showing all past versions.

Review the modifications

Scroll through the versions to identify when the metadata field changed. The 'Modified By' column will display the name of the user who made the change.

Version History Limitations: Version history tracks changes to list items and files. It may not explicitly log structural changes to the column settings themselves, but rather the resulting data changes.

Solution 2

Search the Microsoft Purview Audit Log

Run a targeted audit log search to identify schema or list setting changes made by administrators or site owners.

Free Microsoft Office alternative

Manage and Edit Your SharePoint Documents with WPS Office

While SharePoint handles your server-side document storage and library settings, you need a fast and reliable office suite to edit those files locally. WPS Office is a powerful, free alternative to Microsoft Office that lets you handle all your document tasks seamlessly.

1. Download and Install: Visit the official WPS Office website to download the free installer for Windows, Mac, or Linux.
2. Open Downloaded SharePoint Files: Launch WPS Office and drag-and-drop the files you downloaded from your SharePoint library directly into the workspace.
3. Edit and Save: Make your edits using the familiar interface and save the document. You can then upload it back to SharePoint with original formatting preserved.

Easily open, edit, and save documents downloaded from your SharePoint document libraries.Fully compatible with Microsoft Office formats, ensuring perfect formatting for .docx, .xlsx, and .pptx files.Lightweight installation with incredibly fast startup times compared to traditional office suites.All-in-one software that combines Word processing, Spreadsheets, Presentations, and PDF editing in a single tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I see column changes in standard SharePoint site settings?

SharePoint's native site settings interface does not maintain a visible log of schema changes (like adding or modifying columns). You must rely on Microsoft Purview Audit logs to track these structural administrative changes.

Do I need special permissions to view version history?

To view version history for a file or list item, you generally need at least 'Read' permissions for that specific item. However, investigating structural column changes via the compliance portal requires administrative roles.

Can I see who deleted a column in a document library?

Yes, if audit logging is enabled for your Microsoft 365 tenant, deleting a column is recorded as a list modification event. You can find this action and the user who performed it by searching the Purview Audit log for 'Updated list' activities.

Document & File Issues