Forum Discussion

rbutgins21's avatar
rbutgins21
Brass Contributor
May 05, 2020
Solved

Updating a list date column

I am using an issue tracking list on my sharepoint site - I need to be able to update the resolved date when the status changes to resolved.

8 Replies

  • rbutgins21 You can do in multiple ways and easier option using MS Flow or SharePoint Workflow on updates of the list item check if the status equals to resolved then set then set the resolved date column to today's date. Just make sure you set the date once to that use a additional column something like resolved date updated =Yes. This helps you to prevent updating this column any further updates to the column.

     

    Let you have three columns and status is In Progress.

    Status         | Resolved Date | Resolved Date Updated

    In Progress | EMPTY             | NO

    ------------------------------------------------------------------

    Once the status is changed to resolved

    Status         | Resolved Date | Resolved Date Updated

    In Progress | Today's Date   | YES

     

    So when you are checking the logic make sure check Resolved Date is empty and Resolved Date Updated==No to make the logic error proof.

     

    Hope this helps.

     

    • rbutgins21's avatar
      rbutgins21
      Brass Contributor

      That is similar to what I was trying, I have attached a couple of screen shots of my flow, am I going down the correct path? 

      ā€ƒā€ƒ

      Vikram_Samal 

      • rbutgins21's avatar
        rbutgins21
        Brass Contributor

        I have my flow working, just not sure how to load the current date into the Resolved Date list column using and update item action.  Any suggestions would be greatly appreciated!!!

         

         

Resources