Time of Event on Calendar Is Incorrect After Flow

[djs25uk]

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

[DamoBird365 · Accepted solution]

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 😉

[darkestpage]

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

[Romain1]

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,

[Markeris112]

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. 

{

    "statusCode": 200,

    "headers": {

        "Transfer-Encoding": "chunked",

        "Strict-Transport-Security": "max-age=31536000",

        "request-id": "5ec89cad-05eb-4031-87c6-3848baddde10",

        "client-request-id": "5ec89cad-05eb-4031-87c6-3848baddde10",

        "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"West Europe\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"004\",\"RoleInstance\":\"AM2PEPF0000BE3C\"}}",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "false",

        "x-ms-apihub-obo": "true",

        "Cache-Control": "private",

        "Date": "Sun, 22 May 2022 17:14:19 GMT",

        "Content-Type": "application/json",

        "Content-Length": "6213"

    },

    "body": {

        "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('16e391f6-cd1f-4d6a-8d37-602f74b05385')/events/$ent...",

        "@odata.etag": "W/\"bICWdF7SQ0a9EING6K10eAAACDTcxg==\"",

        "id": "AAMkADA3YTcyYzQxLThjODUtNDg3ZC05OTk5LTllMDMxYWRkNDhlOQBGAAAAAABE3J5pSdn4TpniXRtkdwVFBwBsgJZ0XtJDRr0Qg0borXR4AAAAAAENAABsgJZ0XtJDRr0Qg0borXR4AAABzZG6AAA=",

        "createdDateTime": "2022-05-12T11:29:59.3012817Z",

        "lastModifiedDateTime": "2022-05-22T17:14:19.9287048Z",

        "changeKey": "bICWdF7SQ0a9EING6K10eAAACDTcxg==",

        "categories": [

            "Green category"

        ],

        "transactionId": null,

        "originalStartTimeZone": "UTC",

        "originalEndTimeZone": "UTC",

        "iCalUId": "040000008200E00074C5B7101A82E008000000003D8E019DF365D801000000000000000010000000400D60FCD712884198FC0B35B675E7F0",

        "reminderMinutesBeforeStart": 15,

        "isReminderOn": true,

        "hasAttachments": false,

        "subject": "Duonos kepimas ir biocheminiai pokyčiai",

        "bodyPreview": "suteiksime žinių apie tešlos biochemiją, kad duonos kepimas namuose visada būtų sėkmingas. Mokysimės kepti naminę duoną, kepimo meti sužinosite: kaip pasigaminti naminį duonos raugą, kaip iškepti duoną visai be pridėtinio cukraus. kepsime lietuvišką duoną",

        "importance": "normal",

        "sensitivity": "normal",

        "isAllDay": false,

        "isCancelled": false,

        "isOrganizer": true,

        "responseRequested": true,

        "seriesMasterId": null,

        "showAs": "busy",

        "type": "singleInstance",

        "webLink": "https://outlook.office365.com/owa/?itemid=AAMkADA3YTcyYzQxLThjODUtNDg3ZC05OTk5LTllMDMxYWRkNDhlOQBGAA...",

        "onlineMeetingUrl": null,

        "isOnlineMeeting": true,

        "onlineMeetingProvider": "teamsForBusiness",

        "allowNewTimeProposals": true,

        "occurrenceId": null,

        "isDraft": false,

        "hideAttendees": false,

        "responseStatus": {

            "response": "organizer",

            "time": "0001-01-01T00:00:00Z"

        },

        "body": {

            "contentType": "html",

            "content": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n</head>\r\n<body>\r\n<div class=\"cal_8889\">\r\n<div>\r\n<div class=\"x_cal_ea22\">\r\n<div>suteiksime žinių apie tešlos biochemiją, kad duonos kepimas namuose visada būtų sėkmingas. Mokysimės kepti naminę duoną, kepimo meti sužinosite: kaip pasigaminti naminį duonos raugą, kaip iškepti duoną visai be pridėtinio cukraus. kepsime lietuvišką duoną\r\n su raugu, kvietinę mielinę žydišką duoną &quot;chalą&quot;.<br>\r\n<div style=\"width:100%; height:20px\"><span style=\"white-space:nowrap; color:#5F5F5F; opacity:.36\">________________________________________________________________________________</span>\r\n</div>\r\n<div class=\"x_x_me-email-text\" lang=\"en-US\" style=\"color:#252424; font-family:'Segoe UI','Helvetica Neue',Helvetica,Arial,sans-serif\">\r\n<div style=\"margin-top:24px; margin-bottom:20px\"><span style=\"font-size:24px; color:#252424\">Microsoft Teams meeting</span>\r\n</div>\r\n<div style=\"margin-bottom:20px\">\r\n<div style=\"margin-top:0px; margin-bottom:0px; font-weight:bold\"><span style=\"font-size:14px; color:#252424\">Join on your computer or mobile app</span>\r\n</div>\r\n<a href=\"https://teams.microsoft.com/l/meetup-join/19%3ameeting_MTRmMzhhNzItOTM3MC00NTJkLTljOTgtYTc2ZjlkNjAxZ..." class=\"x_x_me-email-headline\" style=\"font-size:14px; font-family:'Segoe UI Semibold','Segoe UI','Helvetica Neue',Helvetica,Arial,sans-serif; text-decoration:underline; color:#6264a7\">Click\r\n here to join the meeting</a> </div>\r\n<div style=\"font-size:14px; margin-bottom:4px\">\r\n<div><img data-imagetype=\"External\" src=\"https://www.viko.lt/media/uploads/sites/3/2020/05/Untitled.png\">\r\n</div>\r\nVilniaus kolegija </div>\r\n<div style=\"margin-bottom:24px; margin-top:20px\"><a href=\"https://aka.ms/JoinTeamsMeeting\" class=\"x_x_me-email-link\" style=\"font-size:14px; text-decoration:underline; color:#6264a7; font-family:'Segoe UI','Helvetica Neue',Helvetica,Arial,sans-serif\">Learn More</a>\r\n | <a href=\"https://teams.microsoft.com/meetingOptions/?organizerId=16e391f6-cd1f-4d6a-8d37-602f74b05385&amp;ten..." class=\"x_x_me-email-link\" style=\"font-size:14px; text-decoration:underline; color:#6264a7; font-family:'Segoe UI','Helvetica Neue',Helvetica,Arial,sans-serif\">\r\nMeeting options</a> </div>\r\n</div>\r\n<div style=\"font-size:14px; margin-bottom:4px; font-family:'Segoe UI','Helvetica Neue',Helvetica,Arial,sans-serif\">\r\n</div>\r\n<div style=\"font-size:12px\"></div>\r\n<div></div>\r\n<div style=\"width:100%; height:20px\"><span style=\"white-space:nowrap; color:#5F5F5F; opacity:.36\">________________________________________________________________________________</span>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</body>\r\n</html>\r\n"

        },

        "start": {

            "dateTime": "2022-05-24T17:00:00.0000000",

            "timeZone": "UTC"

        },

        "end": {

            "dateTime": "2022-05-25T18:00:00.0000000",

            "timeZone": "UTC"

        },

        "location": {

            "displayName": "",

            "locationType": "default",

            "uniqueIdType": "unknown",

            "address": {},

            "coordinates": {}

        },

        "locations": [],

        "recurrence": null,

        "attendees": [

            {

                "type": "required",

                "status": {

                    "response": "accepted",

                    "time": "2022-05-22T17:07:44.5478259Z"

                },

                "emailAddress": {

                    "name": "Marius Gžegoževskis",

                    "address": "m.gzegozevskis@eif.viko.lt"

                }

            },

            {

                "type": "optional",

                "status": {

                    "response": "notResponded",

                    "time": "4501-01-01T00:00:00Z"

                },

                "emailAddress": {

                    "name": "Pirmas Testuotojas",

                    "address": "p.testuotojas@viko.lt"

                }

            }

        ],

        "organizer": {

            "emailAddress": {

                "name": "Personalo kompetencijos",

                "address": "personalokompetencijos@viko.lt"

            }

        },

        "onlineMeeting": {

            "joinUrl": "https://teams.microsoft.com/l/meetup-join/19%3ameeting_MTRmMzhhNzItOTM3MC00NTJkLTljOTgtYTc2ZjlkNjAxZ..."

        }

    }

}

FROM 5 to 6 PM is good time, but calendar shows 8pm - 9pm. Default time zone outlook and sharepoint UTC +2:00, "EET"