web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to restrict column...
Power Automate
Suggested Answer

How to restrict column editing in SharePoint list using Power Automate

(0) ShareShare
ReportReport
Posted on by
Hello Everyone,
 
I want to use Power Automate to prevent certain users from modifying specific columns in a SharePoint list, while allowing others (e.g., managers) to do so. Is there a recommended approach or workaround to enforce column-level access control using flows?
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    Unfortunately, there is no real direct way to do what you are asking. There is no column level changes. Now i say that, but I would like to know how the users are accessing the data.
     
    Let me explain.
     
    Let's pretend you were building a Canvas App. In that App, you can check a users roles or security groups and for them only show a specific View from SharePoint that does not show that column, and for others. You could do something similar in a model-driven app, as well as any other app as long as you do not expose a direct way for them to write to it.
     
    Now... from the back end, let's assume they have access to SharePoint itself, and that specific List with read-write-chain , from that side it is not completely possible.
     
    Now here is another... PITA but possible.
     
    You could setup a security group for instance where you have People X and another with People Y. Now the list is blocked from everyone. You have a UI or something where people can try to update that list. In your UI, you would trigger a Flow that would temporarily assign permissions on the fly to the item itself via the flow, do the update and turn it off.
     
    So in a really convoluted or structured way it would be possible, with some of the things I said, but again, if they are able to Browse to SharePoint and directly change it... you cannot do it without blocking them completely from the List, and only allow them to update it via your UX and Flow.
     
    Once the change has been made.... and depending on what it is, without versioning and then after the fact checking if its ok to change.. you cannot
     
    TO extend hehe a little. Let's pretend this was Dataverse. Dataverse supports plugins. Now thats not the big part, but it supports Stages. A stage is where you can set a plugin to do something, including, having the plugin look at the data BEFORE its applied to the Table and go, oh NO not that field, and block that field... Now of course ikn Dataverse you can simply use Column Level Security
     
    So IF you have Dataverse already.... and licenses.,.. maybe look at that instead, otherwise you have to build a solution around adding/removing/ui based solution
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey
  • David_MA Profile Picture
    14,090 Super User 2026 Season 1 on at
    I agree with everything @Michael E. Gernaey said. I would just add one other option; you could use a third-party forms designer for SharePoint such as SharePoint Forms. Then like he suggested, you could set up a security group in SharePoint and add the people who should be able to edit the fields you want to restrict. You can then create a rule in the form to then only allow people in that security group to be able to edit certain fields. To prevent people from bypassing the form, you would need to turn off the bulk edit feature in the SharePoint list. It is basically the same as using a Canvas App, but a lot easier to implement.
     
  • chiaraalina Profile Picture
    1,864 Super User 2026 Season 1 on at
    I’d probably handle this directly in Power Apps by customizing the SharePoint list form. You can activate it.

    You can restrict or hide specific fields based on the user’s email or group membership, so only certain people can edit them.

    That way, the restriction is applied right in the form, and you don’t need to rely on Power Automate to revert changes later.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard