how to create a closed time column in Sharepoint list

Question

Hey,

I'm trying to create a column in a Sharepoint list like "Created On" Date column for my "Closed On" column. I want the date to automatically populate once I change status from Active or Pending to Closed.

Is it possible?

Answer 1

Hi @Lihi Zin,

Thank you for posting in this community.

If you are using SharePoint Online, then we can create a power automate flow to update the date.

Here are steps:

1.I create a list which has a "status" column and a "Closed On" column. "status" column is a choice column (Active, Pending and Closed) and "Closed On" is a date column.

2.Open Power Automate portal.

3.Create > Automate cloud flow.

4.Input your flow name and select your flow's trigger: When an item is created or modified.

5.Action1 When an item is created or modified:

Select your List in Parameters tab.

Add a Trigger condition under the Setting tab to ensure that the flow is triggered only when the item is modified.

@not(equals(triggerBody()['Created'],triggerBody()['Modified']))

6.Action2 Get item:

Get information about the item you just modified by ID.

7.Action 3 Condition:

Determine if the value of your item's Status column is Closed. You can select the column by clicking on the little lightning bolt icon as in the previous step.

8.Action4 Update item:

Creates the action under the condition of True. Again select the ID of the item you want to modify and the values of the other columns you don't need to change via the lightning bolt icon. For Closed on columns please add the function by using the function button a couple of clicks down.

formatDateTime(utcNow(),'MM/dd/yyyy')

The first parameter of formatDateTime is to get the current date, the second is to set the date display style, you can define the display style you want.

9.Save the flow and now you can test this flow in your list.

10.The first time you run the flow it will take a little longer, you can wait a minute and then refresh the page to see the date is automatically filled.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

I don't have a Title field in Action4 Update Item, without it an error appears in my Flow. Can you please help me with this? Am I doing something wrong?