cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Time Zone problem with Create Sharepoint List item action

Hi
I know there are lots of questions on these forums regarding time zones but I can't find one that explains the problem I'm having.
The scenario is that when an email arrives into a shared mailbox I want to create an item on a Sharepoint list and then perform various actions. Screenshot of the flow below.
I'm in London and my timezone is UTC (albeit we are on British Summer time +1:00 currently) so that should simplify things but I'm finding that when I view the time on the SP list it's been changed by 7 hours for some reason. The Regional Settings on the SP site are set to London, however they were set to US Pacific time when the site was originally created for some reason, but I changed it weeks ago, I'm wondering if this could be something to do with it perhaps?
The point in the flow when things change is between the inputs and outputs of the 'Create item' action as you can see below, changing from "2019-09-11T15:27:18+00:00" to "2019-09-11T08:27:18Z"
Anyone any ideas why it's doing this and what I could do to correct it?
Many thanks in advance
James.2019-09-11 16_31_11-Run History _ Microsoft Flow.png2019-09-11 16_30_13-iCount - Purchase Invoice Log - Outstanding.png2019-09-11 16_28_52-Edit your flow _ Microsoft Flow.png2019-09-11 16_30_56-Run History _ Microsoft Flow.png

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

I have found when sending items from Outlook to Sharepoint that I have to use the formatDateTime expression to get the extended "time" parts of the timestamp to get into sharepoint correctly, otherwise it kind of lops them off.  the expression is formatDateTime(<timestamp>, 'g').  If I don't format it, it loses all of the time information when it goes into SharePoint for some reason.

View solution in original post

2 REPLIES 2
Frequent Visitor

I have found when sending items from Outlook to Sharepoint that I have to use the formatDateTime expression to get the extended "time" parts of the timestamp to get into sharepoint correctly, otherwise it kind of lops them off.  the expression is formatDateTime(<timestamp>, 'g').  If I don't format it, it loses all of the time information when it goes into SharePoint for some reason.

View solution in original post

Hi

That's solved my issue - thank you so much!

James.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (9,787)