Locking down a date selection

Question

Hi,

Our company has created a booking type system in Sharepoint (it's a list I believe), one of the questions we have included is to select a date that a user wishes to pick.

Is there a way to lock down the selection so if a user opens the booking calendar today, the following week is blocked out as unavailable and the first available date a user can pick from is a week from the day they open the booking request, hope that makes sense?

The idea is to encourage users to pick a date that at least gives the receiver a weeks notice.

Is this possible?

Thanks

Chris

Answer 1

Dear Chris,

Thank you for posting in Microsoft Community.

Based on the description, your requirement is to lock the selection so that other user will not be able to book the same date. Please correct me if my understanding is not correct. I found a related thread from Power Automate Community Prevent double booking SharePoint calendar for the... - Power Platform Community (microsoft.com).

Out expert from Power Automate Community found out that the Flow will not trigger when item is Modified only and it was reported to our Product Group. Since there is no out of the box to achieve this, I would suggest you to post the requirement in our Microsoft Power Automate Community. You may also post it in our SharePoint Developer - Microsoft Tech Community.

You kind understanding is highly appreciated. Stay safe and healthy.

Sincerely,

Zee | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***