cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Domin
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 ?

2 REPLIES 2
Pstork1
Dual Super User III
Dual Super User III

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.

https://collab365.community/manage-permissions-sharepoint-list-item-using-microsoft-flow-add-contrib...



-------------------------------------------------------------------------
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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,592)