web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Date is wrong when sen...
Power Automate
Answered

Date is wrong when sending excel data to Sharepoint list

(0) ShareShare
ReportReport
Posted on by 9

Good afternoon!

 

I am trying to create a new entry in a Sharepoint list when a new row is created in Excel.

The Date column in Excel is showing in the correct date + time in my timezone and flow is detecting the correct time because I tried running a "Convert timezone" step and the output was correct but when the data is sent to a Sharepoint List via a flow, it doesn't show the correct timezone (the time is off by -4 hours so it's not UTC time). 

 

I have adjusted the setting of my Sharepoint in Regional Settings to have the Eastern timezone which should reflect the correct time but when the flow is ran it's not correct.

 

SinfulArte_0-1628886564312.png

 

Data in Excel

SinfulArte_2-1628886765422.png

In sharepoint

SinfulArte_1-1628886746009.png

 

What am I doing wrong?

 

Categories:
I have the same question (0)
  • Verified answer
    SinfulArte Profile Picture
    9 on at

    FIXED! Had to delete and recreate the Sharepoint List after changing the timezone in Regional settings

  • v-LilyW-msft Profile Picture
    on at

    Hi @SinfulArte 

    Thanks for your posting here and sharing the solution in the forum as it would be helpful to anyone who encounters similar issues.

    Best Regards.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard