SharePoint List - Column Edit Restriction per User

Copper Contributor

Hello,

I have a SharePoint list that I'm using for a purchase order request process.  I've used power automate to send automatic emails per choices that are made (submitted, approved, rejected, etc.) and they work great.

 

What I'm trying to do is limit the "ApprovalStatus" field to only be changed by certain individuals, based on their email that is tied to our SharePoint.  I know it cannot be done out of the box on SharePoint, so I've tried using Power Automate (see photo below).  This has not worked for me. 

 

I'd prefer not to use power apps to edit a form, but i did try that.  I can get the logic to work when test it using "Preview" in the power apps designer, but it does not work on sharepoint when I publish it.  I edited the displaymode property field for "Approval Status" with the following code:

If(
User().Email = "email address removed for privacy reasons",
DisplayMode.Edit,
DisplayMode.Disabled
)

Again, looking for the simplest solution that anyone may suggest.  I appreciate everyone's help!

restriction logic.jpgScreenshot 2024-10-01 163410.jpg

0 Replies