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.
Solved! Go to Solution.
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.
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.
Hi
That's solved my issue - thank you so much!
James.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
44 | |
38 | |
30 | |
28 | |
26 |