Forum Discussion
Solved
SharePoint list Calendar double booking
Hi All,
I have a sharepoint list acting as a calendar for booking 3 different rooms.
Columns: Room name, in date, out date
I wish to provide an error or notice or prevention if the user attempts to book a room that is already booked
Thanks
- Hi!
It's better if you build a PowerApps to handling and booking the room. Reason for this is that you can't block double booking in a calender i SharePoint
There is a template you can use:
https://powerapps.microsoft.com/en-us/blog/office-template-book-a-room-now-available/
- Not everyone knows how to build PowerApps. Your average SharePoint user isn't going to know how to do that. The easy solution is to just go into the calendar settings and then click on your list item for your rooms and just make sure the "Enforce Unique Values" is chosen.
- The Idea behind Power plattform is that your average user should be able to create an application pretty easily, I recommend you to check out what Citizen Developer is
- I don't think you've ever worked a Help Desk position. People who can barely work a keyboard can't do Automations or Power Apps. I'm not talking some multi-million dollar company with their own IT staff. I'm talking small offices and businesses. It may be an ideal solution in your brain, but not everyone is as computer savvy.
mymediahelper SharePoint cannot - and has never been able to - prevent double bookings in the calendar. That's why NicolasKheirallah suggested Power Apps. The end user might not be able to build an app, and you might not want them to, but in your IT department you've probably got people who know how to do it. I built a desk booking app in Power Apps with a SharePoint list as the backend which worked across 16 offices for 3 years, with over 30,000 bookings and it was impossible for bookings to clash. It can be done; just don't expect the SharePoint calendar to prevent clashes!
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)- Yup! thats what I ended up doing, Thanks for the reply.
- Hi!
It's better if you build a PowerApps to handling and booking the room. Reason for this is that you can't block double booking in a calender i SharePoint
There is a template you can use:
https://powerapps.microsoft.com/en-us/blog/office-template-book-a-room-now-available/NicolasKheirallah Not everyone is going to be able to do that. You have to think the lowest common denominator when dealing with people who are not IT savvy. I think a lot of IT people lose the ability to comprehend how to deal with those types of people. That's all fine for people who are computer literate. Your Mom and Pop business or a small to midsize business who just want to use SharePoint as an Intranet (which it pretty much is) and don't have an IT department aren't going to have the time or knowledge to do PowerApps or Automations.
