web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a PTO Request...
Power Automate
Answered

Creating a PTO Request from a Form to a Shared Calendar. The Outlook Group Calendar event will not convert to the correct format or time zone.

(0) ShareShare
ReportReport
Posted on by

I am trying to create a PTO request from Microsoft Forms that once approved will go to an Outlook Group Calendar event. As Microsoft Forms does not have a field for time. I am using a text field. This Group Event module seems extremely limited and I am having difficulty with the Time Zone. I have concatenated my Time Date 

concat(outputs('Get_response_details_2')?['body/r572086a21b73494b80de0e613e51d6df'],'T',formatDateTime(outputs('Get_response_details_2')?['body/r664ec72acd9e4ff99aa6f6991aa24311'],'HH:mm:ss'))

However, this still converts to the wrong time. 

 
 
 
 

5-20-2020 5-14-24 PM.png5-20-2020 5-15-57 PM.png

Categories:
I have the same question (0)
  • Verified answer
    v-bacao-msft Profile Picture
    Microsoft Employee on at

     

    Hi @lsimmons11 ,

     

    Maybe you could use addHours() function to increase hours or decrease hours to eliminate time difference.

    This is a general method to deal with similar problems. Please take a try.

     

    Best Regards,

  • ldsimmons1 Profile Picture
    6 on at

    Thank you so much for your quick response! This does work. I was hoping to have a more elegant solution that would account for Daylight Savings Time but, I am not seeing one. May I ask why the Convert Time would not work? I am not sure if I had the correct string format. I tried sortable  date/time pattern Source Time- UTC and Destination UTC-06:00.

     
     
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard