News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows unix time to GMT in po...

Power Automate - Using Flows

Answered

unix time to GMT in power automate

(0) Share

Report

Report

Posted on by wqdqdqqwdwq

29

I have an API which gives output in epoch time, I have to convert this into GMT including hours, minutes and second, so far I am able to convert into a date using below expression:

addDays(formatdatetime('1970-1-1','yyyy-MM-dd'),int(div(variables('epoch'),86400)))

where epoch is variable storing epoch time.

I am looking output with date and time. Appreciate your help.

TIA

Arjun

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

wqdqdqqwdwq 29 on at

Like (0)

Report

Re: unix time to GMT in power automate

figured out, here if the expression for other's help:

formatDateTime(addSeconds(addDays(formatdatetime('1970-1-1','yyyy-MM-dd'),int(div(variables('epoch'),86400))),mod(variables('epoch'),86400)),'dd/MM/yyyy hh:mm tt')

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,668 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans