How to Detect Changes to SharePoint Modified Dates After Approval
Question details
The user needs a way to compare a SharePoint item's current Modified date with its approval date and automatically highlight the row or trigger an alert if changes occur post-approval.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Tracking timesheet or document approvals where list items or files might be modified after being officially approved.
- Observed behavior
- SharePoint does not provide a built-in rule or setting to automatically compare the Modified date with the approved date and highlight the entire row based on that comparison.
Ensure you have Site Owner or Member permissions in SharePoint to create new columns, modify list views, and access Microsoft Power Automate for creating custom automation flows.
Use Power Automate to Detect Modifications and Reset Approval Status
Create a Power Automate flow that triggers when an item is modified, checks if it was previously approved, and alerts stakeholders or resets the status.
Power Automate is the recommended approach for detecting date changes because it can actively send alerts or revert approval statuses, ensuring compliance and proper tracking of modified timesheets or documents.
In your SharePoint list, click 'Add column' and create a Date and Time column named 'Approval Date' to natively store the timestamp of when the item was approved.
Click 'Integrate' > 'Power Automate' > 'Create a flow' from the top command bar of your SharePoint list.
Use the 'When an item or a file is modified' trigger. Add a 'Condition' step to check if the 'Modified' date is strictly greater than the 'Approval Date'.
In the 'If yes' branch, add an action to 'Send an email (V2)' to notify the manager, or use the 'Update item' action to change the Approval Status back to 'Pending'.

Apply JSON Column Formatting to Highlight Modified Rows
Use SharePoint's built-in JSON formatting to visually highlight list items where the modified date exceeds the approved date.
Manage Your Documents Seamlessly with WPS Office
While complex SharePoint list automation requires specific Microsoft tools like Power Automate, managing and editing your actual documents, spreadsheets, and presentations is incredibly efficient with WPS Office. As a free and lightweight alternative to Microsoft Office, WPS Office offers robust formatting tools, perfect compatibility, and a highly familiar user interface.
- 1. Download and Install: Visit the official WPS website to download WPS Office Free and install it on your PC or mobile device.
- 2. Open Office Files: Launch WPS Office and directly open your existing Word, Excel, and PowerPoint documents downloaded from SharePoint with full formatting compatibility.
- 3. Edit and Collaborate: Use the familiar interface to edit documents, utilize Track Changes for reviews, and easily export final approved versions to PDF.

Frequently Asked Questions
Can SharePoint automatically highlight modified items without writing JSON code?
No, SharePoint does not provide an out-of-the-box UI rule to compare two date columns and highlight the entire row. You must use custom JSON view formatting to achieve row-level highlighting based on date comparisons.
How do I access Power Automate for my SharePoint list?
From your SharePoint list, click on 'Integrate' in the top command bar, select 'Power Automate,' and then choose 'Create a flow' to start building your automated modifications tracker.
Why doesn't the Modified date trigger my approval flow automatically?
The 'Modified' column updates automatically every time any field on the item is changed. To prevent endless loops or unwanted triggers, you must add specific trigger conditions or a Condition control in Power Automate to only act when the Modified date is newer than the Approval date.
Can I lock a SharePoint item from being edited after it is approved?
Yes, you can use Power Automate to change the item-level permissions immediately after approval. By removing edit rights for standard users and granting them only read access, you can prevent any further modifications to the item and its Modified date.




