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

23 REPLIES 23
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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,773)