I am wondering if there is a way to achieve the following:
We have SharePoint lists on all sites within a site collection (some modern lists and some classic lists) where we have some basic common data columns. These columns are applicable across all sites within the site collection and are referenced by some power automate flows. We do not want users to be able to edit or delete these columns.
We want to be able to enable users to add their own columns for data entry to suit their individual needs. These columns won't be used in the power automate flows, so it doesn't really matter what they do with them or what they call them, that's up to the user.
I am aware that column level permissions doesn't seem to be possible in SharePoint. But I was wondering if it's possible to split up the permissions granted by the 'Manage lists' permissions setting so that users can add columns, but not edit or delete any columns in existence?
I am aware this could create a situation where users create columns that they can then no longer structurally edit or delete, but I'm willing to work around that if what I'm trying to achieve is possible.
Is what I'm trying to achieve possible?
Thanks in advance!