cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bizzo
Level 8

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

Re: Is there any way to do a timestamp?

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

Re: Is there any way to do a timestamp?

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

Bizzo
Level 8

Re: Is there any way to do a timestamp?

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

Bizzo
Level 8

Re: Is there any way to do a timestamp?

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. 🙂

Highlighted
ppande
Level: Powered On

Re: Is there any way to do a timestamp?

Thanks for your solution.

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

Bizzo
Level 8

Re: Is there any way to do a timestamp?

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.

ppande
Level: Powered On

Re: Is there any way to do a timestamp?

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

Bizzo
Level 8

Re: Is there any way to do a timestamp?

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.

ppande
Level: Powered On

Re: Is there any way to do a timestamp?

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,939)