You’re offline. This is a read only version of the page.
59
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 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.
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
