SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I have calculated column and another column named "Project status", which the latter is of the type "Choice".
What I want to do is when Project status is changed to "Finished", the calculated column will generate the date for when the value "Finished" is chosen. I would want this date to be fixed as well, so it hopefully could be used in a Power Automate Flow later on.
Any help would be appreciated as. Thanks :)
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 utcNow().
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.
Once the Finish Date column is populated, you can use it in your calculated column or anywhere else to perform actions based on that date.
