Dear All
We have a Flow that is triggered after an event is added on an Exchange calendar which updates the event. However, after the Flow has finished running, the event on the calendar has the incorrect time by 1 hour. We are working on GMT (and only ever use this timezone).
1) We create a new event on an Exchange calendar (for example, at 15:00😞
2) We look inside the Flow and can see it shows as 14:00.
3) We run the update to the event and make sure time zone is set to London (GMT):
4) The event on the calendar now shows at the incorrect time of 14:00 instead of 15:00.:
We think this must be due to Daylight Savings Time adjustments but we cannot simply just add 1 hour in the Flow because this will mean events in the winter will be incorrect. Our calendar is set to the correct time zome GMT.
Please could you help us work out how we can maintain the correct original time of the event being added?
Many thanks for your help
Dan
API PATCH FUNCTION
{
"originalStartTimeZone": "UTC",
"originalEndTimeZone": "UTC",
"responseStatus": {
"response": "organizer",
"time": "0001-01-01T00:00:00Z"
},
"recurrence": null,
"reminderMinutesBeforeStart": 15,
"isOnlineMeeting": true,
"onlineMeetingProvider": "teamsForBusiness",
"isReminderOn": true,
"hideAttendees": false,
"categories": ["Green category"],
"start": {
"dateTime": "2022-05-24T17:00:00Z",
"timeZone": "FLE Standard Time"
},
"end": {
"dateTime": "2022-05-25T18:00:00Z",
"timeZone": "FLE Standard Time"
}
}
RESULT RESPONSE SHOWS UTC
For me not working after use Graph api call.
Hi @DamoBird365 ,
Having the same issue and partially solved it with your answer.
My flow creates a calendar event for when an employee goes on leave - so it's a leave request.
In my example, I requested an annual leave from the 15th to the 20th of January.
In my calendar it shows the 15th but goes until the 19th.
In my site regional settings I have UTC+1 (Paris) and have converted time zones in my flow.
Could you please guide through this ?
What else should I do ?
Thank you very much,
Hello Dan,
The Power Platform uses UTC for all date and time. You may have to convert it to your timezone when you enter the Start time and End time. Following is the link that might help.
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
Regards,
Kedar
Hi @djs25uk
I believe that flows run on UTC and in Britain we are UTC +1 due to British Summer Time. You can handle this by converting the date /time from UTC to GMT.
Right now it is 16:59 in UK but utcnow() in my compose, outputs 15:59. If I use convert time zone from UTC to GMT, the output is 16:59. Presumably when the clocks go back, it will conveniently drop the hour. This caught me out in a video I did. Too late now to insert that finding 🤣 you could also try the expression convertFromUtc().
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
WarrenBelz
146,620
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,962
Most Valuable Professional