Add date completed when status is changed

Question

Is there a way to add Date Completed automatically when the status is changed to "Completed" in a List?

robelliott · Answer

tomscrace&nbsp;yes this can be done with a simple flow in Power Automate. You MUST make sure that versioning is activated in your list settings.&nbsp;In this example we'll change the status of Bedar to Completed:This is the trigger:&nbsp;&nbsp;&nbsp;Next, add the get the changes for an item or a file (properties only) action. In the Since field we need to check what has changed since the previous version, so add the expression:sub(int(triggerOutputs()?['body/{VersionNumber}']),1)&nbsp;&nbsp;Next, add a condition to check it's the Status column that has cahnged AND the status is Completed&nbsp;&nbsp;&nbsp;If that is the case then update the item in the list with the current date and time in the Completed date/time column:&nbsp;&nbsp;&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User

ejgp_72 · Answer

It works for me... thanks a lot.. just clarify the step of the update Item...

ganeshsanap · Answer

Ejgp_72&nbsp;What piece you didn't understand in the update item action?&nbsp;Values for ID and Title properties are coming from the trigger outputs (when an item or file is modified).&nbsp;And for Completed date column,&nbsp;RobElliott&nbsp;is passing the utcNow()&nbsp;via flow expression (by clicking Add dynamic content option you see in the images). utcNow() function returns the current date and timestamp.Please click Mark as Best Response &amp; Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

dianaguseva · Answer

ganeshsanap&nbsp;Good dayI am trying to update "Assigned coaching date" with current date when "Coaching status" column have been changed.I was following the flow https://techcommunity.microsoft.com/t5/sharepoint/add-date-completed-when-status-is-changed/m-p/2636031&nbsp;and once I started testing it, it removes information from email "title column"Here is my flow:&nbsp;&nbsp;Would you know why this flow would be deleting information from another column? "Email title" in my case.&nbsp;Thank you.Di.&nbsp;&nbsp;

ganeshsanap · Answer

DianaGuseva&nbsp;I don't see&nbsp;"Email title" in&nbsp;your update item action. Are you talking about "Title" column?&nbsp;If column is not required/mandatory in the SharePoint list, you don't need to pass any value to that column from update item action - you can keep the blank value.&nbsp;If the column is&nbsp;required/mandatory in the SharePoint list, you can pass the same column value you get from trigger outputs to that particular column - you can set it with the help of "dynamic content" section.Please click Mark as Best Response &amp; Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Forum Discussion

Add date completed when status is changed

8 Replies

Resources