Prevent Doublebooking in a SPO Calendar that uses a choice field

C Mo 20 Reputation points
2023-05-15T13:59:19.0833333+00:00

We intend to use a SharePoint online calendar to reserve fleet cars. Currently, selection of a vehicle is done using a choice (dropdown) field. We need a way to ensure that a single vehicle is not double booked. Please help! Thank you in advance -

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,112 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
606 questions
0 comments No comments
{count} votes

Accepted answer
  1. RaytheonXie_MSFT 36,576 Reputation points Microsoft Vendor
    2023-05-16T05:50:32.4133333+00:00

    Hi @C Mo,

    Currently there is no such method to reach your requirement in SharePoint. A common workaround would be using Power Automate to check after the new event creation, delete the duplicate entry if any. Here is an example: Prevent double booking SharePoint calendar for the day.

    In addition, there is a PowerApps Office Template named Book a Room that might do some help on this scenario. Reference: Office Template: Book a Room now available.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.