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 SharePointThere is a template you can use:https://powerapps.microsoft.com/en-us/blog/office-template-book-a-room-now-available/

SharePoint list Calendar double booking

NicolasKheirallah
MVP
Nov 03, 2022
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/
- mymediahelper
  Copper Contributor
  Apr 08, 2024
  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.
mymediahelper
Copper Contributor
Apr 06, 2024
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.
- Rob_Elliott
  Bronze Contributor
  Apr 06, 2024
  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)
  - mymediahelper
    Copper Contributor
    Apr 06, 2024
    Rob_Elliott Yet I'm able to do it.
- NicolasKheirallah
  MVP
  Apr 06, 2024
  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
  - mymediahelper
    Copper Contributor
    Apr 06, 2024
    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.

Forum Discussion

SharePoint list Calendar double booking

Share

Resources