Answered

Flow send email with option - UTC hours return in mail validation

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

My flow works correctly but my hours information return on email is wrong. Missing one hour on each holiday date. My sharepoint regional setting is on UTC + (Brussel, Paris ..) and my flow environnements is on Europe Region. Please could you help me?

Beste regards

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Jaden Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous Thank you for your message and for using Flow.

Flow currently returns dates from SharePoint items in UTC, unless you apply a transformation. Currently, the only transformations allowed are the ones by formatDateTime as documented at https://docs.microsoft.com/en-us/rest/api/logic/definition-language

We are considering conversions to specified time zones in the future, as a function or as an extra action. Please stay tuned!

Jade

Was this reply helpful? Yes No
Roberts2727 193 on at

Like (0)

Report
Copy link

Link copied!

@Jaden,
what is the proper syntax when using this? I would like to convert Door Time to MST which is -7 shown in the below screenshot.

Was this reply helpful? Yes No
Roberts2727 193 on at

Like (0)

Report
Copy link

Link copied!

Anyone else know the proper formatting for a format date time function?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Don't use ' and ' around the date part of formatDateTime( [SharePoint Date Field], 'o' )

in Expression view, you see something like:

formatDateTime(triggerBody()?['Modified'], 'o')

or you can go fancy with

formatDateTime(triggerBody()?['Modified'], 'yyyy-MM-ddTHH:mm:sszzz')

Was this reply helpful? Yes No