SharePoint Document Issues

How to Show the Email Address of the User Who Changed a Specific SharePoint Field

Adam DavisAdam Davis Nov 2, 2026 869 views

Question details

The user wants to automatically record and display the email address of the specific person who edited a particular column in a SharePoint list, rather than relying on the default item-level Modified By tracking.

How to Display the Email Address of the User Who Modified a Specific SharePoint Column
Product
SharePoint
Device & OS
not provided
Scenario
Tracking individual column edits in a SharePoint list to identify exactly who entered or changed specific cell values.
Observed behavior
SharePoint natively tracks who modified the entire row (item) using the 'Modified By' field, but lacks a built-in feature to track who modified a specific column.
Before you start

Ensure you have Edit permissions for the SharePoint list and the necessary Microsoft 365 licenses to create and run Power Automate flows.

Solution 1Recommended

Use Power Automate to Track Column Modifiers

Create an automated flow in Power Automate to detect changes in a specific column and record the modifier's email address in a designated column.

Since SharePoint does not natively support column-level user tracking, Power Automate is the standard method to capture this data.

You will need to create a dedicated column for the email address and configure a flow that triggers whenever an item is updated, checks if the specific column was altered, and writes the editor's email into the new column.

1
Create necessary columns in SharePoint

In your SharePoint list, ensure you have your primary data column (e.g., 'Target Column'). Then, add a new 'Single line of text' column to store the email address (e.g., 'Modifier Email').

2
Create a new Power Automate flow

Navigate to Power Automate, select 'Create', and choose 'Automated cloud flow'. Select the trigger 'When an item or a file is modified', and connect it to your SharePoint site and list.

3
Get changes for an item or a file

Add a new action called 'Get changes for an item or a file (properties only)'. Configure it using the 'ID' and the 'Trigger Window Start/End Token' dynamic content from the trigger step to accurately detect what changed.

4
Add a Condition control

Add a 'Condition' action. Check if the dynamic content 'Has Column Changed: Target Column' is equal to the boolean expression 'true'.

5
Update the SharePoint item

In the 'If yes' branch, add the 'Update item' action. Select your Site and List again, provide the 'ID' from the trigger, and map the 'Modifier Email' field to the 'Modified By Email' dynamic content. Save and test your flow.

Use Power Automate to Track Column Modifiers
Prevent Infinite Loops: Because the flow updates the item, it will trigger itself again. Using the 'Has Column Changed' condition ensures the flow only proceeds when the target column is edited, safely stopping the loop.
Free Microsoft Office alternative

Edit and Manage Your Office Documents with WPS Office

While SharePoint lists require complex Power Automate flows for detailed tracking, managing your everyday spreadsheets and documents doesn't have to be complicated. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your offline and cloud document needs.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package.
  2. 2. Install the software: Run the installer and follow the on-screen instructions to complete the setup.
  3. 3. Open your files: Launch WPS Office and open your .docx, .xlsx, or .pptx files directly with full compatibility.
Fully compatible with Microsoft Excel, Word, and PowerPoint file formats.Track changes and collaborate on documents seamlessly.Lightweight application that loads quickly on Windows, Mac, and Linux.Free to download with an intuitive, familiar tabbed user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Can I track column changes natively in a SharePoint list without Power Automate?

No, SharePoint does not natively support column-level 'Modified By' tracking. The default system only tracks changes at the row (item) level. You must use Power Automate to capture the user who modified a specific field.

Why does the default 'Modified By' column not work for tracking specific fields?

The default 'Modified By' column updates whenever any field in the entire row is changed. It cannot isolate changes to one specific column, meaning it will overwrite the previous editor's name even if they didn't touch the target column.

Can I hide the helper columns in my SharePoint list view?

Yes, you can hide helper columns from the default list view to keep the interface clean. Click 'Add column', select 'Show/hide columns', and uncheck the helper columns. Power Automate will still be able to access and write to them in the background.