cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leslie_rivera
Helper V
Helper V

Book a Room template - UTC Time issue

I am using the Book a Room template and the Auto-response sent reflects the time in UTC. How can I get it to reflect my local time? Mountain Time??

 

leslie_rivera_0-1620947838841.png

leslie_rivera_0-1620963695000.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
leslie_rivera
Helper V
Helper V

See attached solution (had to change to V4, then hard coded mountain time)

View solution in original post

20 REPLIES 20
leslie_rivera
Helper V
Helper V

How and where do I add Timezoneoffset?

leslie_rivera_0-1621011846400.png

 

leslie_rivera
Helper V
Helper V

@v-bofeng-msft.. can you help me with this one? I am struggling to figure out how to fix this UTC issue. Not sure how and where to add the Timezoneoffset.

leslie_rivera
Helper V
Helper V

I tried putting in TimeZone: "Mountain Standard Time" but then it booked my 1030am meeting to 430pm

leslie_rivera_0-1621269442380.png

 

 

leslie_rivera_1-1621269461060.png

 

leslie_rivera
Helper V
Helper V

leslie_rivera_0-1621356035427.png

Where do i put the minutes to reflect Mountain Standard Time (UTC-0:00)?

 

leslie_rivera
Helper V
Helper V

Solution:

If(
IsBooking,
UpdateContext({ShowLoading: true});
If(
!BookForMeeting,
Office365.V4CalendarPostItem(
MyCalendar,
User().FullName & "'s Booking",
StartDateTime,
EndDateTime,
"Mountain Standard Time",
{
requiredAttendees: RoomsGallery.Selected.Email,
location: RoomsGallery.Selected.Name,
importance: "normal",
showAs: "busy"
}
),
ClearCollect(
RequiredAttendeesNoRoom,
Split(
MeetingsGallery.Selected.RequiredAttendees,
";"
)
);
ForAll(
AllRooms,
RemoveIf(
RequiredAttendeesNoRoom,
Address = Result
)
);
ClearCollect(
RequiredAttendeesNoRoom,
Concat(
RequiredAttendeesNoRoom,
Result & ";"
)
);
ClearCollect(
RequiredAttendeesNoRoom,
Split(
First(RequiredAttendeesNoRoom).Value,
";;"
)
);
Set(
RequiredAttendeesFinal,
First(RequiredAttendeesNoRoom).Result
);
Set(
RequiredAttendeesTrue,
RoomsGallery.Selected.Email & ";" & RequiredAttendeesFinal
);
Set(
OriginalBody,
Office365.V3CalendarGetItem(
MyCalendar,
MeetingsGallery.Selected.Id
).body
);
Office365.V4CalendarPatchItem(
MyCalendar,
MeetingsGallery.Selected.Id,
If(
MeetingsGallery.Selected.Subject = User().FullName & "'s Zoom Meeting",
User().FullName & "'s Booking",
MeetingsGallery.Selected.Subject
),
StartDateTime,
EndDateTime,
"Mountain Standard Time",
{
requiredAttendees: RequiredAttendeesTrue,
optionalAttendees: MeetingsGallery.Selected.OptionalAttendees,
body: OriginalBody,
location: RoomsGallery.Selected.Name,
importance: "Normal",
showAs: "Busy",
isHtml: true
}
)
);
UpdateContext({ShowLoading: false})
);
Set(
IsBooking,
false
)

 

leslie_rivera
Helper V
Helper V

See attached solution (had to change to V4, then hard coded mountain time)

@leslie_rivera 

 

I've tried using your solution in my code and have had no luck so far. Where would I put in the "Eastern Time Zone" portion of code?

 

jharville_0-1652980131303.png

 

Thank you so much,

 

Justin

Same issue with me. I am trying to change the time to GMT+5 but do not know where to change.

 

If any one know, please guide.

@jharville I update the Time Zone on the "ConfirmationScreen", On Visible... so for example if I wanted to change it to Eastern.. I would put "Eastern Standard Time" in both places.

 

image1.png

 

ConfirmationScreen_OnVisible.png

 

 

 

 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,435)