Power Platform Community Forum Thread Details

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:

Building flows

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.