Forum Discussion
How do I capture the modification date for a specific Column in SharePoint List?
My goal is to use a calculated field (for example "Backlog Start Date") that captures the modification date of a specific field in a SharePoint list (for example "Task Status") so that I can leverage the captured info in another calculated field to track the amount of time a record has been in a certain status (for example "Days in Backlog")
I'm referencing the default "Modified" column in my calculated field. This is not ideal since any modification to the record (for example, adding a comment to the record) resets the "Backlog Start Date" and skews the "Days in Backlog" data.
Any recommendations? It would be great if there were a way to capture the modification timestamp of a specific field rather than the entire record, however it is unclear if this is an option in SharePoint?
Thanks
3 Replies
- RobwgriffCopper ContributorHi
This would be really useful, surprisingly can't find any references to it.- RobElliottSilver Contributor
Robwgriff you could use a flow in Power Automate to capture the modification date of a specific column by using the new Get changes for an item or a file (properties only) action. Then if the status (only) column has been changed you'd update the column holding the date with today's date utcNow(). There's a good blog post by Laura Rogers about this at https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/comment-page-1/
Rob
Los Gallardos
Microsoft Power Automate Community Super User- RobwgriffCopper Contributor