revert the changes to a column(s) edits by restricted users

(0) Share

Report

Posted on by KS-19122005-0

I have a list that i own and have multiple stakeholders that make edits to it. there are specific columns i update that i don't want the others to edit. I would like to enforce read-only behavior programmatically by restricting updates to specific columns using Power Automate. So, If the column was modified by a restricted user, use the previous value of the column to overwrite the change.

Can someone provide clear steps on how to create this type of flow?? Please and thank you!

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

David_MA 12,240 Super User 2025 Season 2 on at

Like (1)

Report
revert the changes to a column(s) edits by restricted users

Column level permissions are not supported in SharePoint. However, you can do this:

Create a flow that triggers when an item is modified.

Include a trigger condition to check where the modified by e-mail address is not equal to your e-mail address.

This way, the flow only runs when someone else modifies the item.

Then follow this blog post to get the changes from the workflow run to the prior version: Get the changes made to SharePoint Items with Power Automate

Add a condition to check if any of the fields you don't want updated have been modified.

If the condition returns true, send yourself an e-mail to notify yourself and then revert the item to the prior version.

You could follow this post to revert the item to the prior version also: Restore Version of a SharePoint List Item Using Power Automate. I didn't have luck with it. Since it is not something I really need, I didn't pursue it.

You could then also send a notification to the person who modified the item to remind them not to modify column x, y, and z and that the prior values have been restored.

Was this reply helpful? Yes No