cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bizzo 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

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 Kudo Kingpin
Kudo Kingpin

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

Highlighted
Bizzo Kudo Kingpin
Kudo Kingpin

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

ppande Advocate II
Advocate II

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 Kudo Kingpin
Kudo Kingpin

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 Advocate II
Advocate II

Re: Is there any way to do a timestamp?

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

Bizzo Kudo Kingpin
Kudo Kingpin

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 Advocate II
Advocate II

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
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,739)