Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Time of Event on Calendar Is Incorrect After Flow

(0) ShareShare
ReportReport
Posted on by 2

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😞

Capture0.PNG

 

2) We look inside the Flow and can see it shows as 14:00.

Capture1.PNG

 

3) We run the update to the event and make sure time zone is set to London (GMT):

Capture2.PNG

 

4) The event on the calendar now shows at the incorrect time of 14:00 instead of 15:00.:

Capture4.PNG

 

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

  • Markeris112 Profile Picture
    3 on at
    Re: Time of Event on Calendar Is Incorrect After Flow

     

     

     

    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.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",
            "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_MTRmMzhhNzItOTM3MC00NTJkLTljOTgtYTc2ZjlkNjAxZWVi%40thread.v2/0?context=%7b%22Tid%22%3a%2243864a51-470c-4314-a939-57bf31cb1138%22%2c%22Oid%22%3a%2216e391f6-cd1f-4d6a-8d37-602f74b05385%22%7d\" 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;tenantId=43864a51-470c-4314-a939-57bf31cb1138&amp;threadId=19_meeting_MTRmMzhhNzItOTM3MC00NTJkLTljOTgtYTc2ZjlkNjAxZWVi@thread.v2&amp;messageId=0&amp;language=en-US\" 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": {
            }
        }
    }
     
    FROM 5 to 6 PM is good time, but calendar shows 8pm - 9pm. Default time zone outlook and sharepoint UTC +2:00, "EET"
     
    Markeris112_0-1653243034465.png

     

  • Romain1 Profile Picture
    26 on at
    Re: Time of Event on Calendar Is Incorrect After Flow

    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.

     

    Romain1_0-1642192156376.png

    Romain1_1-1642192185659.png

     

    Could you please guide through this ?

    What else should I do ?

     

    Thank you very much,

  • darkestpage Profile Picture
    37 on at
    Re: Time of Event on Calendar Is Incorrect After Flow

    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

  • Verified answer
    DamoBird365 Profile Picture
    8,942 Microsoft Employee on at
    Re: Time of Event on Calendar Is Incorrect After Flow

    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().

     

    DamoBird365_0-1628784046831.png

    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 😉

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,620 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,962 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow