Column with mutiples status - automatic today's date when status is changed to "completed"

Eloise Bmail 0
Viewed 29

I have a Microsoft List with a column named "Status" which is a column type with multiples choices. I want the user to have today's date when he chose a certain choice from the column "Status". For instance, when the status is "completed", then the column "Date of completion" shall display automatically today's date.

What would be the formula, and should it be entered in the column "Date of completion" parameter > column validation in the field "formula" ? Or do I need to use power automate ?

Thanks for your help,

formula sharepoint power-automate list
1 Answers

I would use column formatting for this.. I would use Power Automate for this.

Create a flow like below.

  1. Use the When an item is created or modified trigger action.

  2. In the Settings add a trigger expression like below (again change it to use the internal column names).

    That expression checks if the Status field value is Completed and if the Date of Completion field is still empty.

    @and(equals(triggerOutputs()?['body/Status/Value'], 'Completed'), empty(triggerOutputs()?['body/Dateofcompletion']))

  3. In the Update Item use UtcNow for the Date of Completion field

    utcNow()

enter image description here

enter image description here

Expiscornovus0
Related