Need help in granting Edit permission in Sharepoint list based on a Column value

[Gopakumar]

Need help in granting Edit permission in Sharepoint list based on a Column value

The Log is :- If col value='XYZ', then only user A can edit the row.

[v-bofeng-msft · Accepted solution]

Hi @Gopakumar :

Is this editing permission set for the entire SharePoint list or just for this Canvas App? The two are different.

Case1: Set for the entire SharePoint list

I'm not sure if this can be achieved, I suggest you consult a SharePoint expert.

Case2: For your Canvas App

Just set the DisplayMode property of the corresponding control.For example:

I assume that your users submit changes via a button.Set the button's DisplayMode to:

If(
(colvalue="XYZ" && User().Email="UserA@xx.com")||
(colvalue="XXX" && User().Email="Userb@xx.com")||
(colvalue="YYY" && User().Email="UserC@xx.com")||
(colvalue="ZZZ" && User().Email="UserD@xx.com")
,
DisplayMode.Edit,
DisplayMode.Disabled
)

Best Regards,

Bof