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, please reply.

admin
Lists
microsoft lists
SharePoint Online
  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Dec 01, 2022
    If you go to "List Settings" and then to "Advanced Settings"

    then you have the Option
    "Create and Edit access: Specify which items users are allowed to create and edit"
    Set this to
    "Create items and edit items that were created by the user"

    And the Option
    "Read access: Specify which items users are allowed to read"
    Set this to
    "Read items that were created by the user"
  • 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