Convert utcnow to Unix Timestamp

[rafaelresende]

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

[v-yamao-msft]

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

[GabrielStJohn]

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

[rafaelresende · Accepted solution]

Just opened in new Ideas.

https://powerusers.microsoft.com/t5/Flow-Ideas/Convert-Tima-Date-format-to-UNIX-Timestamp/idi-p/1457...

[SkyeEyks]

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

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