I know this isn't supported OOTB but I really have a requirement to make certain columns read only in O365 SharePoint Online (preferably modern experience).
We are trying to encourage a group of users to move from an Excel spreadsheet for managing tasks to using SharePoint. However, they have sheet protection on which prevents users changing due dates / task category etc.
Certain users should be able to edit these "locked" fields but others should not.
I know I could lock the edit fields with PowerApps but what's to stop a savvy user creating their own connection to the list to edit these columns?
Am I going about this the wrong way by using lists? Is there some other solution which would serve me better?
Thanks in advance!