I am creating a flow that consists of 6 approvers, i have a custom column that i use for statuses with 'conditional formatting' to colour it depending on the status. This column however, can still be edited by people that have edit rights, editing this in the middle of the flow is not too bad as the status will change anyway on the next approval.
How can i lock down the colum as "view only"? I heard you can create a lookup ? But the both colums still shows in the edit options?
Is there a trick ?
There really isn't a trick. SharePoint doesn't support permissions at the column level, only at the item level or higher. What you could do is lock down the entire record to prevent editing after the final Approval is complete. To do that you'll need to use HTTP REST calls to break inheritance of Security and then change who has access to edit the record. Here's an article that shows how to add the Contribute permission. But you can use the same procedure to add any permission level.