Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Locking down a custom Approval Column

Hi All

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 ?

Dual Super User
Dual Super User

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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Okay great, thanks for the link ! I will try this at some point

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (3,435)