Unanswered

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) Share

Report

Posted on by lsimmons11

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.png 5-20-2020 5-15-57 PM.png

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Re: 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.

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,

Was this reply helpful? Yes No
ldsimmons1 6 on at

Like (0)

Report

Re: 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.

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.

Was this reply helpful? Yes No