Power Platform Community Forum Thread Details

**UPDATE** - I can't reply to @MichaelFP nor can I post a reply to my own post for some reason. I tried removing the TimeZoneOffset() and this made it appear in the calendar preview window correctly, but when I open the calendar invite to view the full details, it appears an hour behind when I booked it for and states the Time Zone is Co-ordinated Universal Time. How do I make it so the invite and the calendar preview window are matching?

**END OF UPDATE**

Original Post

Hello everyone,

I'm having a really frustrating issue with the Book A Room template Power App.

We've used it for some time and it has now decided for the past few weeks/months to send the meeting invites an hour ahead of the scheduled time.

So if it was booked for 10am, it will invite users and appear in the calendar as 11am.

I've done a lot of googling, tried manually adding in the (UTC+00:00) Dublin, Edinburgh, Lisbon, London" time zone etc with no luck.

Can someone please review the below formula and tell me what is going wrong or what needs to be changed, feeling pretty desperate at this point!

If(

IsBooking,

UpdateContext({ShowLoading: true});

If(

!BookForMeeting,

Office365.V2CalendarPostItem(

MyCalendar,

User().FullName & "'s Booking",

DateAdd(

StartDateTime,

-TimeZoneOffset(),

TimeUnit.Minutes

),

DateAdd(

EndDateTime,

-TimeZoneOffset(),

TimeUnit.Minutes

),

{

RequiredAttendees: RoomsGallery.Selected.Email,

Location: RoomsGallery.Selected.Name,

Importance: "Normal",

ShowAs: "Busy"

}

),

ClearCollect(

RequiredAttendeesNoRoom,

ForAll(

Split(

MeetingsGallery.Selected.RequiredAttendees,

";"

),

{Result: ThisRecord.Value}

)

);

ForAll(

AllRooms,

RemoveIf(

RequiredAttendeesNoRoom,

Address = Result

)

);

ClearCollect(

RequiredAttendeesNoRoom,

Concat(

RequiredAttendeesNoRoom,

Result & ";"

)

);

ClearCollect(

RequiredAttendeesNoRoom,

ForAll(

Split(

First(RequiredAttendeesNoRoom).Value,

";;"

),

{Result: ThisRecord.Value}

)

);

Set(

RequiredAttendeesFinal,

First(RequiredAttendeesNoRoom).Result

);

Set(

RequiredAttendeesTrue,

RoomsGallery.Selected.Email & ";" & RequiredAttendeesFinal

);

Office365.V2CalendarPatchItem(

MyCalendar,

MeetingsGallery.Selected.Id,

If(

MeetingsGallery.Selected.Subject = User().FullName & "'s Skype Meeting",

User().FullName & "'s Booking",

MeetingsGallery.Selected.Subject

),

StartDateTime,

EndDateTime,

{

RequiredAttendees: RequiredAttendeesTrue,

OptionalAttendees: MeetingsGallery.Selected.OptionalAttendees,

Body: "Room has been updated to " & RoomsGallery.Selected.Name,

Location: RoomsGallery.Selected.Name,

Importance: "Normal",

ShowAs: "Busy"

}

)

);

UpdateContext({ShowLoading: false})

);

Set(

IsBooking,

false

)