Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / revert the changes to ...
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
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
  • Verified answer
    David_MA Profile Picture
    David_MA 11,726 Super User 2025 Season 1 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans