Wrong date time zone when import from excel online to a SharePoint list

(0) Share

Report

Posted on by kinghnvn

Hi all,

I'm facing an issues when import data from an excel file to a SharePoint list, please advise me, many thanks.

Wrong date time zone when import from excel online to a SharePoint list

I have an excel file in SharePoint as below

I created a flow to import data in the excel file to a SharePoint list looks like below

But after import, my date time is wrong time zone (it's showing 3:30 PM, that is not correct, should be keep the same in the excel file: J & K columns, My zone is GMT+7 )

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kinghnvn ,

When an item is created in SharePoint. It convert Date value to SharePoint site Timezone. Please check your SharePoint Timezone.

To solve this issue, check the time difference and add the difference value to Data value.
Please refer the below link. Thank you @DeepakS for sharing the solution.
https://powerusers.microsoft.com/t5/Building-Flows/SharePoint-showing-incorrect-date/td-p/961781

Regards
Kaif

Was this reply helpful? Yes No
kinghnvn on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I'm using the current time zone (UT+ C) but the date still wrong when I import from excel to sharepoint

SharePoint time zone

Excel
After convert: the time is not correct
My Power Automate flow

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kinghnvn,

Convert datetime value to require timezone. Please refer below link for reference:
https://powerusers.microsoft.com/t5/General-Power-Automate/Format-SharePoint-DateTime-column-in-Power-Automate/td-p/585063

Hope this will help you.

Regards
Kaif

Was this reply helpful? Yes No