Answered

Formatting Date and Timestamp to Excel

(0) Share

Report

Posted on by Celdere

Trying to run a flow for logging my working hours (started using the formatting from the template) and am getting the date and time in weird formats. I'd love the date, when manually triggered, to appear in MM/DD/YYYY format and the time to just appear as HH:MM in a 12 hour format. At the moment the Key-button-timestamp button gives me the date as well as time down to the second and I can't figure out how to format the output.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Celdere,

Do you want to formate the datetime from timestamp with type 'MM-dd-yyyyTHH:mm'?

If you would like to formate the datetime from timestamp with type 'MM-dd-yyyyTHH:mm',you could refer to screenshot below to create the flow:

The expression in the Compose 2 as below:

formatDateTime(outputs('Compose'),'MM-dd-yyyyTHH:mm')

The flow would run successfully as below:

Please let me know if your problem could be solved.

Best regards,

Alice

Was this reply helpful? Yes No
Verified answer

Celdere 15 on at

Like (0)

Report
Copy link

Link copied!

Made it work using the DateTime convert timezone function. Thanks!

Was this reply helpful? Yes No
GrischkePro 287 on at

Like (0)

Report
Copy link

Link copied!

You're a waste of space!

If you got it working, why didn't you say how? Delete this thread!

Was this reply helpful? Yes No