Unanswered

Flow reads datetime always in UTC

(0) Share

Report

Posted on by AbulHassan

The list I use have a datetime column that has a default value set as Today() in the list setting in SharePoint online. So when an item is created, it saves the correct time - currently in British Summer time. I have a flow that sends an email picking that datetime value - when it sends, the time is sent an hour less than the stored value. I don't if its being sent as UTC or GMT, I guess both are same?

I have verified the site regional settings and Flow settings - both are correctly set with UK time. Am I missing something or is it a bug?

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi AbulHassan,

Please check this thread for a reference:
https://powerusers.microsoft.com/t5/General-Flow-Discussion/Flow-send-email-with-option-UTC-hours-return-in-mail-validation/m-p/17055/highlight/true#M4032

In this thread, staff @Jaden mentioned that Flow currently returns dates from SharePoint items in UTC, unless you apply a transformation. Please consider to use workflow definition language formatDateTime to convert the date time value:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Besides, it seems that conversions to specified time zones, as a function or as an extra action will be released in the future.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
anhthuch4ng Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AbulHassan,

Were you able to successfully adjust your Flow per @v-yamao-msft's suggestions above?

If yes and you find that solution satisfactory, please go ahead and accept it as a solution.

Cheers,

-AT

Was this reply helpful? Yes No
AbulHassan 46 on at

Like (0)

Report
Copy link

Link copied!

No I am afraid. It shows only in UTC and this workaround doesn't work unfortunately.

Was this reply helpful? Yes No
JonL Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hey Abul, Great news.

We now have a time zone converter service. Let me know if this helps you out.

Was this reply helpful? Yes No
anhthuch4ng Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Great recommendation @JonL!

@AbulHassan - have you had a chance to try out the time converter service to adapt your Flow?

If yes and you find that solution satisfactory, please go ahead and mark this thread as "Solved". 🙂

Happy Flowing,

-AT (Community Admin)

Was this reply helpful? Yes No
PatrykO 7 on at

Like (0)

Report
Copy link

Link copied!

Good morning,
Got same problem,
Tried to use "Convert time zone" service in my Flow, but it still send me my date -2h (I'm GMT+2 and it always change to UTC).

Can anyone help me to solve my problem?

Thanks in advance

Was this reply helpful? Yes No
Dorul 340 on at

Like (2)

Report
Copy link

Link copied!

Hi @PatrykO
This worked for me:
convertTimeZone(body('Start_an_approval')?['responseDate'],'UTC','E. Europe Standard Time','dd/MM/yyyy HH:mm')
Adjust it to your needs.

Was this reply helpful? Yes No
PatrykO 7 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Dorul, that helped me a lot!

Used:
convertTimeZone(triggerBody()?['MyCustomField'],'UTC','E. Europe Standard Time','dd/MM/yyyy HH:mm') and working for me 🙂

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello, @AbulHassan!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @Dorul‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No