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
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