How to Show the Email Address of the User Who Changed a Specific SharePoint Field
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.

- 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.
Ensure you have Edit permissions for the SharePoint list and the necessary Microsoft 365 licenses to create and run Power Automate flows.
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.
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').
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.
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.
Add a 'Condition' action. Check if the dynamic content 'Has Column Changed: Target Column' is equal to the boolean expression 'true'.
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.

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. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the software: Run the installer and follow the on-screen instructions to complete the setup.
- 3. Open your files: Launch WPS Office and open your .docx, .xlsx, or .pptx files directly with full compatibility.

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.




