Forum Discussion

Radoslavov91's avatar
Radoslavov91
Copper Contributor
Feb 05, 2023
Solved

Date and Time imported with Power Automate in wrong format

Hi all, i have this strange issue with a Date and Time column in SPO list. I've imported a data from an excel file using Power Automate. Among this data there is Start Date and TIme  and End Date an...
SharePoint Online
  • SvenSieverding's avatar
    SvenSieverding
    Feb 06, 2023

    Hi Radoslavov91,

     

    you are entering your data as a UTC timestamp into SharePoint (That is what the "Z" at the end of the timestamp means), not as a local timestamp . And SharePoint displays that date in your local timezone.

    You should either

    1) Convert your time into UTC time and save that to SharePoint (Using the "Convert Timezone Action")
    2) Remove the "Z" from the end of your timestamp. Then SharePoint will interpret the timestring as a time of the defautl timezone of it's regional settings

    Best Regards,
    Sven

SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Feb 06, 2023

Hi Radoslavov91,

 

you are entering your data as a UTC timestamp into SharePoint (That is what the "Z" at the end of the timestamp means), not as a local timestamp . And SharePoint displays that date in your local timezone.

You should either

1) Convert your time into UTC time and save that to SharePoint (Using the "Convert Timezone Action")
2) Remove the "Z" from the end of your timestamp. Then SharePoint will interpret the timestring as a time of the defautl timezone of it's regional settings

Best Regards,
Sven

Resources