SharePoint stores all Date/Time in UTC, regardless of user/site time zone and you are in GMT+1.
Automatic UTC conversion leads to a 2-hour offset when using GMT+1.
Try below solution-
1. Use convertFromUtc() in Power Automate:
convertFromUtc('<Your_DateTime>', 'GMT+1', 'yyyy-MM-ddTHH:mm:ss')
2. Ensure SharePoint field is "Date and Time", not just "Date".
Adjust with convertTimeZone() if needed for user time zones
convertTimeZone(utcNow(), 'UTC', 'GMT+1', 'yyyy-MM-ddTHH:mm:ss')
This should correct the time zone mismatch.
Was this reply helpful?YesNo
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.
4
Share
Report
All responses (
Answers (
