Unanswered

SharePoint Create Item from Email Received Time Incorrect

(0) Share

Report

Posted on by mark-carlisle

I have a Flow creating a list item within SharePoint. The SharePoint List has a column in there for time received and this is populated by the Received Time dynamic content from the 'When a new email arrives' trigger.

What’s happening is the time from the email is changing in Flow to a time 8 hours earlier.

In my example images the first image shows the outputs of the 'When a new email arrives' trigger, the DateTimeReceived is showing as 2017-11-28T15:19:43+00:00 which is correct. The second image shows the input to the 'Create item' action the the Received is showing as 2017-11-28T15:19:43+00:00 which is the same as image 1. UTC is there as a control and is just the expression utcNow() this has a slightly different format 2017-11-28T15:20:01.0297731Z which I've highlighted. Image 3 shows the output for the 'Create item' action note UTC is as is on image 2 but Received is now 8 hours before.

I assume the difference is down to the formatting of the input of Received compared to UTC what I want to know is how to convert my Received Time dynamic content to the same format as the expression utcNow() so it shows correctly on the SharePoint list.

Other troubleshooting

I'm based in the UK therefore currently in the UTC time zone.
I have checked with my IT to confirm my Office 365 user ID is set to GMT
I have checked with SharePoint site admin that the SharePoint site is also GMT.
Not believing my internal IT team I also created a new tenant to confirm this also happened on another tenant, which it does

Categories:

Building flows

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mark-carlisle,

Flow currently returns dates from SharePoint items in UTC.

Have you checked the items created in the list? Is it the correct date and time?

When testing this issue on my side, I found that I have the same issue with you. The date and time is different from the Inputs and Outputs of the action “Create item”. However, when I checked the list, it was the correct date and time.

Best regards,
Mabel Mao
mark-carlisle 59 on at

Like
a
(0)

Report
Copy link

Link copied!
I managed to resolve the issue it was down to the differing formats

Recieve Time was outputting in format 2017-11-28T15:19:43+00:00

Whereas UtcNow() was outputting in format 2017-11-28T15:20:01.0297731Z

The following expression on Receive Time resolved the issue;

formatdatetime(triggerBody()?['DateTimeReceived'],'yyyy-MM-ddTHH:mm:ss.fffffffZ')
For some reason formatting the Recieve Time using;

formatdatetime(triggerBody()?['DateTimeReceived'])

Still gave the incorrect data time outputs.