Unanswered

Book a room Add attendees

(0) Share

Report

Posted on by Davidpower

Hello,

I try to set up a button to add required attendes in the app book a room. So it's working I can add peoples but At the end it should send an email to my users and to my meeting room to book the room. But I can't have both working , it send an email just to the attendees or just to the room:

this is my code on the confirmation screen:

I change this one : RequiredAttendees:RoomsGallery.Selected.Email or Concat(ComboBox1.SelectedItems;Mail&";") /* Modify the formula here */

If I keep the first one it send to the room and if I use the second onbe it send to the attendes.

I Try something like this : RequiredAttendees:RoomsGallery.Selected.Email & Concat(ComboBox1.SelectedItems;Mail&";") /* Modify the formula here */

But it's not working.

If(IsBooking;
 UpdateContext({ShowLoading: true});;
 If(!BookForMeeting;
 Office365.V2CalendarPostItem(MyCalendar; User().FullName & "'s Booking"; StartDateTimeUTC; EndDateTimeUTC; 
 {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);;
 Office365.V2CalendarPatchItem(MyCalendar; MeetingsGallery.Selected.Id; If(MeetingsGallery.Selected.Subject = User().FullName & "'s Skype Meeting"; User().FullName & "'s Booking"; MeetingsGallery.Selected.Subject); StartDateTimeUTC; EndDateTimeUTC; {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)

Could you help me ?

Another question can we add the outlook calendar view in powerapps ?

Thank you,

Best regards,

David.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Davidpower 8 on at

Like (0)

Report

And is someone know hot to change the utc time to CET it could be usefull.

Thanks

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @Davidpower ,

I can help you with time,

CET is 1 hour ahead of UTC, therefore your formula be as

Text(Hour(Now())+1, "00")

Hope this helps.

Was this reply helpful? Yes No
Davidpower 8 on at

Like (0)

Report
Hello @Ethan_R

I try my formula like this so it's working in the room calendar bot not in the invitation (sorry I'm really bad with that):

If(IsBooking; UpdateContext({ShowLoading: true});; If(!BookForMeeting; Office365.V2CalendarPostItem(MyCalendar; User().FullName & "'s Booking";Text(Hour(Now())+1; "00"); Text(Hour(Now())+1; "00"); {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);; Office365.V2CalendarPatchItem(MyCalendar; MeetingsGallery.Selected.Id; If(MeetingsGallery.Selected.Subject = User().FullName & "'s Skype Meeting"; User().FullName & "'s Booking"; MeetingsGallery.Selected.Subject); StartDateTimeUTC; EndDateTimeUTC; {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)

Thank's for helping.

best regards,
David.

Was this reply helpful? Yes No
Davidpower 8 on at

Like (0)

Report
Well I think I fixed my issue with utc time by this code
If(IsBooking; UpdateContext({ShowLoading: true});; If(!BookForMeeting; Office365.V2CalendarPostItem(MyCalendar; User().FullName & "'s Booking";DateAdd(StartDateTime; -TimeZoneOffset(); Minutes); DateAdd(EndDateTime; -TimeZoneOffset(); Minutes); {TimeZone:"Central Europe 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);; Office365.V2CalendarPatchItem(MyCalendar; MeetingsGallery.Selected.Id; If(MeetingsGallery.Selected.Subject = User().FullName & "'s Skype Meeting"; User().FullName & "'s Booking"; MeetingsGallery.Selected.Subject); DateAdd(StartDateTime; -TimeZoneOffset(); Minutes); DateAdd(EndDateTime; -TimeZoneOffset(); Minutes); {TimeZone:"Central Europe Standard Time";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)

DateAdd(StartDateTime; -TimeZoneOffset(); Minutes);
DateAdd(EndDateTime; -TimeZoneOffset(); Minutes);
{TimeZone:"Central Europe Standard Time"

Not sure if it's the best but it seems to works.

So my last problem is this one :

I change this one : RequiredAttendees:RoomsGallery.Selected.Email or Concat(ComboBox1.SelectedItems;Mail&";") /* Modify the formula here */

If I keep the first one it send to the room and if I use the second onbe it send to the attendes.
I Try something like this : RequiredAttendees:RoomsGallery.Selected.Email & Concat(ComboBox1.SelectedItems;Mail&";") /* Modify the formula here */

Was this reply helpful? Yes No