Power Automate Automatically Applies ‘UTC’ or Z to normal Excel Date/Times we can scrub or remove the “Z” that is at the end of the date/time. The problem is simple, but the solution requires some slight trickery or formatting to get Power Automate to convert the date times correctly.

Result – Any date/times from Power Automate in UTC or Z format are changed to local settings in SharePoint so the date and time is incorrect.Īll of the Date/Time values in the SharePoint List column 'SP_DateTime' are incorrect because they are offset by the timezone in the display settings.SharePoint List display settings in local ‘Central Standard Time’.Power Automate Automatically Applies ‘UTC’ or Z to normal Excel Date/Times.The problem in my flow that makes the SharePoint datetime result incorrect. No Conversion Flow Results No Conversion SharePoint List Results When all of the Excel Dates are put into the SharePoint list, the Date column SP_DateTime shows an incorrect time. I made a flow that gets the Excel rows from the table and then Create Item in a SharePoint List. The SP_DateTime is a standard Date Time type column in a SharePoint List. The Title column will be a text format, so there should be no time conversion issues.

I’m going to put the Excel Date into the SharePoint List columns Title and SP_DateTime. I have datetimes in an Excel table and need to put them into a SharePoint List.Įxcel Date Table SharePoint Column Settings There is also daylight savings time in this Time Zone. This is a simple example about a problem I had when moving date/times from an Excel table into a SharePoint list.

Time clock converter on excel