How can i make a column read only in MS Lists?

Question

I have a list with multiple rows and 10 columns (columns 1-10). I want to fill in columns 1-5 myself and make them read-only for everyone else. This way, the audience can view the information in columns 1-5 but won’t be able to edit them. I don’t want to hide any columns; I just want columns 1-5 to remain as read-only reference while allowing others to update the remaining columns (6-10).

thank you

Answer 1

Hi @Kelly San Martin,

Unfortunately, SharePoint does not provide column-level security.

But it is still possible to achieve your goal with a little creativity. You can create a Power Automate flow that triggers when an item is created or modified in the list. The flow can check if the user has edited any of the columns that you want to restrict, and if so, it can revert the changes and send an email notification to the user.

As I am not an expert to Power Automate, I recommend you go to the dedicated forum here: Microsoft Power Automate Community - Power Platform Community. Members and engineers over there will focus on the specific situation on your side and share specific suggestions.

Hope my answer helps.

---

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.