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.
Solved! Go to 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
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
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |