Forum Discussion
Add date completed when status is changed
tomscrace yes this can be done with a simple flow in Power Automate. You MUST make sure that versioning is activated in your list settings.
In this example we'll change the status of Bedar to Completed:
This is the trigger:
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)
Next, add a condition to check it's the Status column that has cahnged AND the status is Completed
If that is the case then update the item in the list with the current date and time in the Completed date/time column:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
I just wanted to note that this flow works most of the time, but I came across an issue where the condition "has column changed" will run as false if more than just the Status field is updated (in my case, updating the Hours field as well). SharePoint will record each change as a separate version, and if they occur close enough together (I'm guessing within the same minute?), the flow will only consider the second update. I've solved this issue by updating the Since expression to look at the last 2 versions, rather than 1. I don't see any future issues with doing that, but is there a more elegant way to address the problem?
Hi, Thanks for this - really useful.
The only issue i have is that the "completed" date that appears always updates to the current date.
For example, the date today is 27th March. If i had closed a ticket on the 23rd March, it now says that the completed date is 27th March (Today). How do i stop this from happening?
Thank you
RobElliott my update item is not the same as what you have shown. I have followed the steps but in the end I'm not getting the option to setup date when the status changes to Completed.
- It works for me... thanks a lot.. just clarify the step of the update Item...
Ejgp_72 What piece you didn't understand in the update item action?
Values for ID and Title properties are coming from the trigger outputs (when an item or file is modified).
And for Completed date column, RobElliott is passing the utcNow() 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 & 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.
Good day
I 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 and once I started testing it, it removes information from email "title column"
Here is my flow:
Would you know why this flow would be deleting information from another column? "Email title" in my case.
Thank you.
Di.
