You’re offline. This is a read only version of the page.
Announcements
89
A column of times and dates is stored in my sharepoint list. It displays correctly in my sharepoint list, when used in power apps, and had worked correctly in power automate up until a couple of days ago. I now try to send an email using those times and dates, and the time is always one hour behind. I assume it has something to do with the clocks going forward on the 26th of March.
How do I deal with clocks going forward in power automate?
Any help would be appreciated.
Solved my issue, seems like sharepoint stores date time as UTC, but will display that date time as the local time zone to the user automatically, while automate dosent. With automate you need to explicitly state the format the date time should be in. So my solution, being from the UK, was to use the function 'convert time zone', set the source time zone as '(UTC) Coordinated Universal Time', and set my destination time zone as London, Edinburgh etc
Used this article
Display SharePoint time in the correct time zone with Power Automate (tomriha.com)
Share
Report
All responses (
Answers (
