cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Kingpin
Kudo Kingpin

Is there any way to do a timestamp?

At certain points, I like to add a timestamp when an action completes, but I haven't found a way to do this. An example of how I would use this:

 

- New item created in sharepoint --> Status column set to "New"

- Kicks off flow

- action completes

- Status column updated to, for example, "Stage 1 complete"

- set, for example, Stage 1 Complete Date column to CURRENT_TIMESTAMP or some sort of equivalent.

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Administrator
Administrator

Hi Bizzo,

Indeed there is!

 

First, make a column in your SP list for the timestamp to be placed.

Second, In your flow, insert a "Compose" action and in the compose card type "@utcnow()"

Third, Insert an action below the compose card "update item" -> connect it to your SP list, and pass the "Output" from the compose card into the corresponding field in your list.

Voila! instant timestamps!

 

Let me know if this helps!

View solution in original post

8 REPLIES 8
Administrator
Administrator

Hi Bizzo,

Indeed there is!

 

First, make a column in your SP list for the timestamp to be placed.

Second, In your flow, insert a "Compose" action and in the compose card type "@utcnow()"

Third, Insert an action below the compose card "update item" -> connect it to your SP list, and pass the "Output" from the compose card into the corresponding field in your list.

Voila! instant timestamps!

 

Let me know if this helps!

View solution in original post

Hi Jon,

 

Thanks for the tip! Haven't actually implemented on a Production flow, but marked it as the solution since it seems like it'll do the trick. 

 

Is there documentation for all the functions available through "Data Operations - Compose"? Might be some other goodies in there that will make my life more better good! Smiley Happy

 

Thanks,

Jason

For anyone else who finds this and uses the solution, please note that you have to have the double quotes. Took me a bit to figure that out. 🙂

Thanks for your solution.

How can I convert this to ET? I don't see any function for ET.

I'm not really sure what you mean by "ET", but this page will give you a rundown of the Workflow definition language date functions.The date functions are near the end of the page.

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

 

Also, since it sounds like you're doing some sort of conversion or formatting of the date, I recommend looking at this post, too.

https://powerusers.microsoft.com/t5/Building-Flows/Formatting-Date-List-Items-from-SharePoint-when-s...

 

EDIT: Fixed link.

Oh I am sorry for confusing you. I mean Eastern Time.

I thought that might be it, but was expecting EST or EDT. 🙂

 

I didn't see anything about choosing a timezone (but I only skimmed the pages). You might have to use the addhours option to add (or subtract) time from the timestamp to convert it to Eastern Time.

For anyone who's looking for this. This is what I did: addhours(utcnow(),-4)

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,768)