Forum Discussion

Pat_Tepen's avatar
Pat_Tepen
Copper Contributor
Jul 01, 2020

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

  • Robwgriff's avatar
    Robwgriff
    Copper Contributor
    Hi
    This would be really useful, surprisingly can't find any references to it.
    • RobElliott's avatar
      RobElliott
      Silver 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

Resources