web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion milliseconds to date a...

Power Automate - General Discussion

Answered

milliseconds to date and time format

Like (0) Share

Report

Report

Posted on 19 Oct 2022 21:26:13 by benben777

12

Hello Everyone

I'm trying to get data from worksheet and send it by email but part of this data is a date and it come as milliseconds

and i want to convert it back to date and time format

i created a test flow to test the code but so far no luck here SH

Input

output

Thank you all for the help

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

benben777 12 on 20 Oct 2022 at 12:11:38

Like (0)

Report

Re: milliseconds to date and time format

Thank you all for the quick response and the help
I was able to resolve that with your help and here is my final code

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on 20 Oct 2022 at 02:39:47

Like (1)

Report

Re: milliseconds to date and time format

@benben777 ,
You are nearly there.
Just add formatDateTime to your Compose output.
formatDateTime(outputs('Compose'),'dd-mm-yyyy')

Was this reply helpful? Yes No
benben777 12 on 19 Oct 2022 at 23:51:06

Like (0)

Report

Re: milliseconds to date and time format

Thank you @ekarim2020

I tried that but still not the right format

Is there different format i can use?

Thanks

Was this reply helpful? Yes No
Ellis Karim 11,202 Super User 2025 Season 2 on 19 Oct 2022 at 21:51:22

Like (1)

Report

Re: milliseconds to date and time format

Hi @benben777 ,

Try setting the DateTime Format to ISO 8601. This will convert Excel integer dates for you:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Responsible AI policies for the Community

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans