cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arnie
Frequent Visitor

Outlook connectors: Exported email timezone

First of all a huge thanks to the Flow team for releasing the Outlook connectors - it's a feature that a lot of our clients are going to love!

 

We have started working with email connector to upload a copy of an email to SharePoint when it has been flagged, and set the requisite metadata i.e. To, From, Subject, Received Time etc.

 

The problem we have come across is the "Time Received" in the exported email is showing UTC.    When we view the original email from Outlook it displays the time using our current timezone.

 

Both in SharePoint and on our PCs we have the timezone set to AEST +10 Brisbane in our regional settings, however when viewing the exported email in SharePoint it appears to be displayed in UTC.

 

Any ideas on how to get the exported email to show the time based on the current timezone?

 

Example below.

 

Original Email Time Received: Wednesday, January 31, 2018 4:59 PM
Exported Email Time Received: Wednesday, January 31, 2018 6:59 AM

 

Greenshot 2018-02-13 17.10.40.png

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
faustocapellanj
Memorable Member
Memorable Member

Hi @arnie

 

By default, all dates and times in Flow are in UTC. You will have to convert the date and time to your time zone with the "Date Time - Convert time zone" action. Below you can find a link where the Flow team discusses how to work with dates and times in Flow. You can also find a screenshot of a test I was just doing with your time zome. Just make sure to add your Email Date and Time in the Base time field.

 

Working with Dates and Times inside of your flows:

https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

 

DateTime.JPG

 

Regards,

Fausto Capellan, Jr

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

13 REPLIES 13
faustocapellanj
Memorable Member
Memorable Member

Hi @arnie

 

By default, all dates and times in Flow are in UTC. You will have to convert the date and time to your time zone with the "Date Time - Convert time zone" action. Below you can find a link where the Flow team discusses how to work with dates and times in Flow. You can also find a screenshot of a test I was just doing with your time zome. Just make sure to add your Email Date and Time in the Base time field.

 

Working with Dates and Times inside of your flows:

https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

 

DateTime.JPG

 

Regards,

Fausto Capellan, Jr

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

Thanks for your reply Fausto.  Great to know about the timezone action, will definitely have to use that one in the future!

 

We ended to the bottom of our problem, which turned out to be a SharePoint issue and not Flow at all. 

 

As you said exporting the email in UTC.  The problem was in the email preview in SharePoint Online.  It was displaying the date in UTC and not using the site collection or user specific timezone settings.

 

Thanks again for your help!

Hi i have the same issues. when i exported the email and store at SPO. The .msg message preview and show the time is UTC. i would like to know the coverted time zone task is doing before "Export email" Task or after it. Thanks

Hi @josephpoon0506

 

Do you mind posting some screenshots of the flow you have so I can take a look?

 

Thanks.

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

Hi 

 

anyone can help ?

Hi @josephpoon0506

 

Looking at your screenshot, you're only using the output from the Convert Time Zone in your .msg file you're creating. It's not manipulating the date and time inside the email message you are exporting? Are you trying to do the latter?

 

Thanks

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

hi Faustocapellanj, 

 

i would like when the email is arrived to specific mailbox and then exported a copy of email and store on SPO document library. 

So what is the correct workflow to do it ? is it export the email and then used "convert time zone" flow ?

Hi @josephpoon0506

 

From your screenshot, it looks like you have the correct steps to export the email message and then save it in an SPO document library. A quick breakdown on the Convert Time Zone step: what it's doing is getting the value of the Received Time and then converting it from UTC to your local date and time in Beijing using the format yyyyMMdd-HH:mm:ss. If you need to extract the email message to save it to the SPO library, you don't need the Convert Time Zone step in your flow, unless you want to name the email message with the date and time you are getting from the Convert Time Zone output. If I misunderstood your previous message, please let me know so I can assist you better.

 

Regards,

Fausto Capellan, Jr

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

hi Faustocapellanj, 

 

you're correct. i would like to rename the exported email's file name with my local time. Also, it seems there are something wrong the email preivous in SPO with UTC not my local time. by the way, Arnie told me that if we download the exported time and open it on local PC. it will show the correct local time instead of UTC. anyway, thank you for your help.

 

Regards

Joseph

repeated post

repeated post

Rey_Ganado
Frequent Visitor

Hi, 

 

I have the same problem. Can you share how to fix it?

 

Thanks!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,706)