Forum Discussion
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 if a vehicle is already allocated for a particular data range, it becomes unavailable for any other date during that period.
I cannot make the Vehicle Registration column unique otherwise i cannot enter it more than once in the whole document.
I have tried validation settings but can't get the right result.
Can anyone help ?
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)
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)
