Book-a-Room-with-powerapp

I am using an existing Powerapp Template "Book a Room" and modify there.

Modification I had made

1. Filter your search Room auto selected by your Account location country at search object

Default - First(Office365Users.SearchUser({searchTerm:User().Email}).Country).Country

this will filter your room list based on your country location.

2. to show the capacity of a room

-upon my reasearch there is no function available in powerapp to display room capacity. this is a workaround solution with SharePoint.

2.1. Create a SharePoint name "RoomList" as follows

The title room name must be the exact same name as your meeting room mailbox that was created in your exchange.

2.2. Add a new "text label" to the "RoomGallery"

add this to read the data from RoomList SharePoint

• "Size-" & First(Filter(RoomList, Title = ThisItem.Name)).Capacity

3. Popup box for booking confirmation

created the following popup object under the "RoomSelectScreen

• Label_date

Text - "Date: " & Text(DateSelected, "[$-en-US]mmmm dd, yyyy")

• Label_time

Text - "Time: " & Text(StartDateTime, DateTimeFormat.ShortTime) & " - " & Text(EndDateTime, DateTimeFormat.ShortTime)

• Label-popupConfirm

Text - "You have selected"

• btn_Confirm

OnSelect - Set(IsBooking, true); Navigate(ConfirmationScreen, ScreenTransition.Cover); UpdateContext ({varDisplayPopup:false})

• btn_Cancel

Onselect - UpdateContext ({varDisplayPopup:false})

Group them together and set visible value to

varDisplayPopup

4. Cancel a meeting

• create cancel button

Onselect - Office365.CalendarDeleteItemV2(MyCalendar,ThisItem.Id);Remove(FutureCalendarEvents,ThisItem);