Approval workflow status is approved update approval date

Question

workflow runs on item created and item changed events.

if workflow is approved, set approved date
If workflow status is completed, set complete date

Here, approved date and complete date are changing to item modified date whenever I modify item.

I don't want to update approved date and complete date once they are set.

Thanks in advance.

Answer 1

According to your description, my understanding is that you want to add approved date to a tasks list via SharePoint Designer.

The steps below can achieve your request:

1. Create a column named “Date” in the tasks list.
2. In SharePoint Designer, create workflow in tasks list, add condition “if any value equals value”, the former value choose Outcome field, the latter value type “Approved”. Then add action “set field in current item”, field choose the “Date” column, value choose current date, in Start Options field, check Start workflow automatically when an item is created and Start workflow automatically when an item is changed, shown as figure below.

As we can tell, there is a OOTB column in the Task list named Outcome which shows the Approved status of Approval workflow. When it turns into “Approved”, then the current date is the “Approved Date” you want. So I use the workflow to get the current date i.e. “Today”. Then we can create a new column in Task list (in my demo, it is Date) to display it.

Could you please have a test per my steps in my first reply? Any question, let me know.