Power Platform Community Forum Thread Details

Hi All,

Been trying to get a workaround as my work moves from Sharepoint 2010 to using sharepoint online. I asked this question on the Microsoft learn for Sharepoint:

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.

I got the following advice:

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！

I was hoping someone here might be able to assist.

Thank you.

Categories:

Building Power Apps