Skip to main content

Notifications

Community site session details

Community site session details

Session Id : u1slm6xvWHT32l+4EZARCg
Power Automate - General Discussion
Unanswered

Power Automate Creat Event V4 Date and Time Issue

Like (0) ShareShare
ReportReport
Posted on 10 Aug 2022 09:09:30 by 4

Hello, 

I hope somebody here can help me. 

 

I´m trying to create an Outlook event with Power Automate. 
The trigger I use is the SQL 'When an item is created (V2)' as seen in the picture below.

 

Unbenannt.PNG

 

Now here comes the problem:

When testing the flow the event gets created but the event time somehow gets messed up.

 

Input and output show the time i like the event to be created as seen below:

 

Unbenannt1.PNG

Unbenannt2.PNG

Yet in the Outlook Calender view it is off. Somehow 2 hours get added to "start date" and "end date" resulting in the event starting. 

Important is that i dont want to create an all day event.  

 

Now comes the weird thing. As soon as i open the event from the calendar view the time is displayed as I wanted the event to be:

 

Unbenannt4.PNG

I already tried to convert the time zones and what not.

 

Thanks in advance.

  • SamuelBenjamin Profile Picture
    69 on 02 Feb 2023 at 18:37:50
    Re: Power Automate Creat Event V4 Date and Time Issue

    Yep, something weird with the way PA manage dates.

    Create an event (v4):
    -Input 9.45am Berlin Time as start time, this are the outputs:

      "subject": "Test Convert to UTC",
      "start": "2023-02-02T09:45:00.0000000",
      "end": "2023-02-02T10:30:00.0000000",
      "startWithTimeZone": "2023-02-02T09:45:00+01:00",
      "endWithTimeZone": "2023-02-02T10:30:00+01:00",



    Get an event (v3) to get the event details on the step above. Totally weird!!

            "subject""Test Convert to UTC",
            "start""2023-02-02T08:45:00.0000000",
            "end""2023-02-02T09:30:00.0000000",
            "startWithTimeZone""2023-02-02T08:45:00+00:00",
            "endWithTimeZone""2023-02-02T09:30:00+00:00",

    Update and event (v4) to update the event on the first step. I use the start and end values from the get an event step. This is the ouput, but the event is still showing at 9:45 on my calendar.
            "subject""Test Convert to UTC",
            "start""2023-02-02T08:45:00.0000000",
            "end""2023-02-02T09:30:00.0000000",
            "startWithTimeZone""2023-02-02T08:45:00+00:00",
            "endWithTimeZone""2023-02-02T09:30:00+00:00",

    Is there something I'm missing out about how to manage calendar events with PA??
  • Madddi43 Profile Picture
    4 on 10 Aug 2022 at 10:17:44
    Re: Power Automate Creat Event V4 Date and Time Issue

    Update:

     

    Just noticed that the time zone in the opened event is set as utc. As soon as i manually change that, the calendar view gets updated to the right time. 

    Still dont know why that happens because I set the time zone to UTC+1 in the create event action. 

    So help is still appreciated.

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,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard
Loading started