Recreating a Sharepoint 2010 booking calendar in Sharepoint 365

Question

Hello,

I am having to migrate an existing booking system from sharepoint 2010 to sharepoint 365. I've used the sharepoint migration tool but I am having some issues with getting it all working how it was in sharepoint 2010. This is my first experience with sharepoint(other than using the existing site for bookings) and don't have my experience beyond word/excel/powerpoint.

Just to add some context here first. As it stands, the sharepoint site is just an event calendar which we use to book various work that needs to be done. Sharepoint 2010 allows us to have just two users which people share, our booking user and our manager user. Both users are able to create events but they are what we call a tentative booking. This is managed through a choice column called 'Confirmed', which the choices being 'yes' or 'no'. There is a hidden column called 'Current user' on the events which is a calculated column '=me'. Finally, the validation is a formula =OR('Confirmed=no', 'Current user =<the managers user>). This means that anyone can see or create an event but only a manager can confirm it.

When recreating this in sharepoint 365 I am running into a couple of problems, the user is no longer a shared user and is done off the single touch sign on, the calculated column of '=me' is no longer supported. I've gone down a few rabbit holes about trying to limit the visibility of the confirmed column to user etc but this process has become quite frustrating so I figured I should ask for some advice

Does anyone have some suggestions on how I could recreate the effect of everyone in the organisation can view/create events but only those users deemed to be managers are able to edit/confirm those bookings?

Thank you.

Answer 1

Hi @Colin Lewis ,

Unfortunately, after my attempts, there is no way in SharePoint Online to set a column to be edit/confirm only for some users (deemed to be managers), while other users have CREATE permission. This is because other users with CREATE permission (i.e., edit, etc.) can edit the column.

And the smallest permission level in sharepoint is item, you can't set it for smaller column levels.

I think maybe you can go to Power Apps Community and post a thread to see if you can accomplish what you want with a Power Apps custom list. Hope this information can help you！

---

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.