Datetime format

(0) Share

Report

Posted on by MichaelBL

Hi all,

I have this expression in Power Automate:

formatDateTime(triggerbody()['Columname'],'dd-MM-yyyy HH:mm')

The output would be "14-04-2021 15:00" and that works fine.

For some reason however the flow adds + hours to the time and I simply cannot figure out why.

Any ideas?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

meelamri 468 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This is certainly related to the time zone shift. What is your data source?

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @MichaelBL

Power Automate uses UTC for time. You can use the convert time zone action to change to desired time zone.

https://support.microsoft.com/en-us/topic/converting-time-zone-in-microsoft-power-automate-8bce2441-1859-4d76-2f51-985d9c96534d#:~:text=Using%20the%20action,%22Convert%20time%20zone%22%20operation.&text=Base%20time%3A%20The%20datetime%20you,the%20datetime%20is%20currently%20in

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
MichaelBL 58 on at

Like (0)

Report
Copy link

Link copied!

Date source is SharePoint Online.

I was thinking if it might be possible to just hardcode the flow to always add +2 hours ?

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@MichaelBL

Sound like a plan - addHours() function lets you addHours.

BTW does the incorrect time match the UTC time?

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No