To achieve your requirement, using Power Automate, here's how you can set it up:
Create a new column of type
Date and Time called
Finish Date or any name you prefer.
Create a new Power Automate flow in the Power Automate portal.
Set the trigger to
When an item is created or modified for the SharePoint list where the columns reside.
Add a condition to check if the value of the
Project Status column is equal to
Finished. You can use the 'Condition' action in Power Automate to achieve this.
If the condition is true, add an action to update the
Finish Date column. You can use the 'Update item' action to update the corresponding item in the SharePoint list.
Set the value of the
Finish Date column to the current date and time using the expression
Save and test the Power Automate flow.
Now, whenever the
Project Status column is changed to
"inished for an item, the Power Automate flow will automatically update the "Finish Date" column with the current date and time.
Finish Date column is populated, you can use it in your calculated column or anywhere else to perform actions based on that date.