Forum Discussion

A-Patz's avatar
A-Patz
Copper Contributor
Jan 08, 2025
Solved

List calendar view with unique entry per date

I have created a sharepoint list which i want to use in calendar view, to enable allocating fleet cars for business trips. I have 6 vehicles to choose from via dropdown choice but want to make sure ...
  • Rob_Elliott's avatar
    Jan 09, 2025

    Out-of-the box SharePoint lists have never been able to prevent clashes. What you will need to do is to build an app in Power Apps with Lists as the backend. I did this a few years ago for a lease car checkout app and a desk booking app. Within the app you can make sure that vehicles are not displayed in the gallery showing available vehicles if a vehicle's already checked out for a date.. There are quite a few videos on YouTube, for example Laura Rogers has a ery good video on how to tweak the asset checkout template in Power Apps at https://www.youtube.com/watch?v=5v-RMT1CI-U. There are also good videos on this by people like Shane Young and April Dunnam.

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources