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

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

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

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

Highlighted
Advocate II
Advocate II

Re: Is there any way to do a timestamp?

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

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

Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,802)