08-24-2019 03:13 AM
08-24-2019 03:13 AM
I have a SharePoint list, where I will store some data.
When new entry will be recorded, I will have 3 different Approvers.
For 3 Approvers I will have relevant "1st Approver Status", "2nd Approver Status"... columns
Is there any way to limit these columns, so only relevant Approver can modify his column of "Approver Status" in SharePoint list?
I am integrating Approval with Microsoft Flow. (send to 1st approver, then to 2nd, then to...)
And I will need strong evidence, that nobody except relevant Approver can change the status of the new entry in SharePoint list.
If this no possible, is there any possibilities to track, that relevant Approver approved request from his side?
08-24-2019 08:41 AM
Unfortunately, There is no way to set the permission at column level.
You can create a custom view and create a filtering per column but they can switch between the views.
08-25-2019 05:37 AM
08-26-2019 07:28 AM
You'll want to look at content approval. This is a list setting independent from Flow, but I believe can be accessed/activated using Flow. With content approval all new items are pending until a designated approver (someone in a permission group with Approver level access or higher) approves the item. The approver will be listed in the Modified By column. After that point, if anyone edits an item, it will revert back to pending.
Content approval uses a system field to track approvals, not the custom field you created so you can delete those. Unlike your custom fields that can be edited by anyone with access, these system fields cannot be edited directly by anyone regardless of permission level. If it says "Approved", that means the person in the Modified By column did it.
I don't believe you can prevent people from editing the items even after approval, however when they do, the item loses Approved status and would need to be re-approved by a designated person. That's about as locked down as you can make it.