Forum Discussion

Sakib_Gayen's avatar
Sakib_Gayen
Copper Contributor
Dec 01, 2022

SharePoint List User Level permission

Hello, I have 3 members in my SharePoint List and by default they got EDIT permission. I want to set permission as - every user can see only his own created list items.   If any one know about it...
admin
Lists
microsoft lists
SharePoint Online
Venkadesh365's avatar
Venkadesh365
Copper Contributor
Dec 01, 2022

Hi   Sakib_Gayen 

One way to solve this scenario is to use flow-

  • Break the permission of item when item created
  • Add the permission to the user who created the item

 

  • Below are the steps:
    1. Create a flow in Power Automate
    2. Trigger : When an item is created
    3. Break the Permission. 
      1. Action: Send an HTTP request to SharePoint
      2. Uri: _api/lists/getByTitle('list-title')/items(item-id)/breakroleinheritance(copyRoleAssignments=false,clearSubscopes=true
      3. Headers: {
        "Accept": "application/json",
        "Content-type": "application/json"
        }
    4. Get the ID of User who created the item
      1. Action: Send an HTTP request to SharePoint
      2. Uri: _api/web/SiteUsers/GetByEmail('created-by-user-email')/Id
        Add EDIT permission to user who created the item
    5. Add Permission to user who created the item
      1. Action: Send an HTTP request to SharePoint
      2. Uri:_api/lists/getByTitle('list-title')/items(item-id)/roleassignments/addRoleAssignment(principalid=user-id},roledefid=1073741830)

 

Resources