PowerApps Create and Book a time slot - Reservations

Learn how to let your users create time slots for an event dynamically then have other reserve or book that time. The app uses Sequence, AddColumns, DataDiff, Patch and more functions to take some simple inputs and create this complex repeating data structure. App also allows you to add an event reminder to your Outlook Calendar.

0:00 Power Apps Booking or Reservation System
1:15 Demo of the example time slot app
4:20 Using Power Apps Sequence function and Power Apps AddColumns function to create a table of times during the day for a Dropdown control
10:18 Conditional error messages and setting the DisplayMode of a button
12:22 Using ForAll, Patch, and DateDiff PowerApps functions to create the blank slots in your data source (SharePoint)
14:48 Looking at the SharePoint list we use as a data source
17:08 Booking a time slot as a user
18:40 Unbooking a time slot and patching blanks quick tip

[LapaConsult_Ex_Macraris]

Thanks for this another great tip! Min 10:19 building on top of what you taught in this video, I was able to configure with nested DateAdd Dropdown end Time so that the items property always got a timevalue greater than than dropdown start Time. Thank you Again.

[maxcedeno]

Thanks so much. I learned and am learning a lot with your information videos and demos. Saludos desde Costa Rica. Pura Vida.

[angrybatvoice]

Great video! I had to build something very similar recently. After fighting and fighting with using Bookings and then Resource Calendars as the datasource, I opted to store the bookings in Sharepoint as well.

[RyanSmith-mhlj]

Hi Shane, awesome video, very helpful video. I have question, how to prevent overlapping date? For example, if a room (room A) booked from 1pm - 2pm, and another user wants to book same room from 12:30pm - 2:30pm, how to prevent that? Thanks

[matthewfritch]

Another great video and has given me a few ideas for a few things I have been working on.

[tluu]

This is great! This is like Microsoft Bookings but better

[Thiago-nmdf]

Hi Shane,  I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails.

As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver. 

Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow.

Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.

[ExplorerheNorth]

Hey Shane I have a query.
I want to make a vehicle servicing app.
This is easy enough but where I’m stuck is my work has opening hours, lunch hours and other activities that take time away from the normal working day.
What I was thinking was having the servicing broken into total hours from a Sharepoint table in the background to complete. So the person picks the date and the service type. The power app automatically knows the hours that are not working hours and populates the calendar and the date the vehicles would be available for collection.

Hope this makes sense

[VishnuSatheesh-oolt]

Hi Shane,
Thank you for all your videos. This has helped me a lot in my work.
I have a question about the time slots. Is it possible to tweak this to have slots available for multiple days with different start time and end time on each day?
For e.g., I am hosting a show from Monday to Friday.
I start at 8am and end at 4pm on Monday and Tuesday and for the rest of the days its from 9am to 3pm.
Any ideas on how to accomplish this?

[felixpohlmann]

Awesome!
1. Can multiple people register for a time-slot?
2. And where does the creator get a notification?
Are teams-meetings created by this?

[alleynesacademy]

HI Shane, I have found this very useful and I think it is exactly what I am after, however is it possible to have multiple people book on to the same time slot. For example if i had an event and there were 5 spaces for that slot, could it be open until the limit has been reached?

[ricardobunge]

Hey Shane - another great video highlighting some lesser-used functions and the importance of core skills. Thanks! Question, for the Sequence in the ForAll Patch, could you use Countrows(Gallery)? Or do you not have them appearing in the gallery UNTIL you patch?

[timgrattidge]

Hi Shane, This is great, really. I am desperate to create a calendar/schedule/event like this for my school IT Rooms. Is there an downloadable example that can be used to edit?

[MortenNormannAlmeland]

Hey - do you have a movie on how multiple people can book a traingroom ... and when they are going to the room they check in and check out and then the booking time should delete the booking and put in the absolute time for check in and check out. People can also se who is training ... live... if they let them or just anonym.

[katefallon]

I'm struggling to get 'TimeSlot' to populate as a date/time in my SharePoint list and the galleries its tied to. Its only populating the date and I've checked my work/compared it to yours and I can't find the obvious problem. Any thoughts?

[berlyanpermata]

Great Video, anyway can you make another tutorial of how to make the room booking system automatically available if the user forgets to checkout the room? Thankyou

[rupaliagarwal]

Is it possible to have weekly/monthly reoccurrence while booking such slots?

[williamvissenaeken]

Hello Shane, is there a tutorial to display an overview of all meetings from multiple meeting rooms? So list the calendar events of the day? We've had this configured with a Digital Signage Solution but development stopped recently so now we want to use Powerapps to accomplish the same. Thank you in advance! W.

[Lakshya]

Hi Shane, this helped me a kot. But I am still stuck. I need your help. I have a gallery with my calendar on it and I am not able to filter my time slots gallery with the selected date. Could you please help me with this

[Astra-rngk]

This is exactly what i need right now. Following the steps and failing with the first steps of adding a column? has this function now changed?
Ill keep trying!
Thanks for all the videos, i have learnt so much!