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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (57,119)