cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rafaelresende
Advocate I
Advocate I

Convert utcnow to Unix Timestamp

Hi guys,

 

I've been using MS Flow for several months. One new HTTP integration expects me to send the date in a unix timestamp. I've been researching and trying several things but so far I was not successfull. 

 

Is there a way to convert utcnow to timestamp using Microsoft Flow?

Regards,

Rafael

1 ACCEPTED SOLUTION
4 REPLIES 4
v-yamao-msft
Community Support
Community Support

Hi @rafaelresende,

 

Microsoft Flow uses UTC format by default, it seems that there is no function can be used to convert UTC format to unix timestamp.

Please consider submitting a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GabrielStJohn
Community Champion
Community Champion

Hello, @rafaelresende!

 

If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.

 

Thank You!

 

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



SkyeEyks
Regular Visitor

There isn't a function for it but you can calculate it manually

 

div(
  sub(
    ticks(
      utcNow()
    ), 
    ticks(
      parseDateTime('1-1-1970')
    )
  ), 
  10000000
)

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,454)