Trying to Set Up an Office Reservation System

jackrum we're in the same situation across multiple offices so I have built a system very similar to what you want to do and our staff book a desk for a day at the office they are going to be in. It is based on the videos by April Dunnam shown at the bottom of this post.

I've also used Power Apps as the front end and the backend in SharePoint has 2 lists, 1 for desks and 1 for the reservations.

The desks list has the location, title of each desk and whether it is active or not:

The columns I've got in Reservations list are as follows:

The app in Power Apps looks like this. The user doesn't have to enter their name or email address as that is picked up automatically from their Office 365 details: the On Start function of the app sets the Current User variable using Set(currentUser,User())

After the first 600+ bookings were made, and after feedback from users, we simplified it from being able to book any slots between 8 and 5 of any duration to inititally just 8am to 1pm then 1pm to 6pm, but have just simplified it again yesterday to just booking for a day, however much of the day the user will actually use it. This makes the syntax for checking available desks easier and more reliable. 

That syntax is now quite straightforward:

Filter(Desks,Not(Title in Filter(
'Desk Reservations',
CheckOutFrom = startTime).DeskText)
&& Active = 1
&& Location = selectedLocation)

Once the user confirms the booking the data is patched to the desk reservations list:

ForAll(selectedDesks,

Patch(
'Desk Reservations',
Defaults('Desk Reservations'),
{
Title: currentUser.FullName & " " & ThisRecord.Title,
Location: selectedLocation,
DeskText: ThisRecord.Title,
CheckOutFrom: startTime,
CheckOutTo: endTime,
OnBehalfOf: txtOnBehalfOf.Text,
ReservedBy: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & currentUser.Email,
Department: "",
DisplayName: currentUser.FullName,
Email: currentUser.Email,
JobTitle: "",
Picture: ""
}
}
));

Navigate(Success, ScreenTransition.CoverRight)

Adding the new item to the list triggers a flow in Power Automate to send the user an email confirming their booking:

There are other things that are going on, for example one screen in the middle is for the user to confirm they accept the risk assessment for the office. And they can also view a PDF of the layout of the office. Also anyone can print out the bookings for today at a particular office from the icon non the first screen. Our Directors like the app and have made it mandatory for bookings so I think it will be in use for the next year or so.

I hope that quick canter through the system has given you some ideas. Come back with any questions or if you need to know in detail how something has been done.

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)