Forum Discussion

rautchetan27's avatar
rautchetan27
Brass Contributor
Jun 10, 2020

change permission on list item

I have number of list items(1000+) for which one user have edit permission.

i want to make it read permission for that user and dont want to do manually for each item one by one.

 

i saw solution using add-in plumsail which have "change sharepoint permissions" option.

 

can i achieve this using any in build sharepoint "action item" other than plumsail?

I dont want to use plumsail..

 

I just want to change permissions for number of items (1000+)to read for particular user for list which have 10000 records, dont want to do it manually one by one

9 Replies

  • Lewis-H's avatar
    Lewis-H
    Iron Contributor

    It is actually quite easy and straightforward. To enable Item Level Permissions, go to List Settings > Advanced Settings.

    Item Level Permissions

    Scroll a bit down and you will see Item Level Permissions section.

    Item Level Permissions

    Inside the section, you will see two categories

    Read access and
    Create and Edit access

    • Ashish_Kohale's avatar
      Ashish_Kohale
      Iron Contributor

      rautchetan27 : Yes Lewis-H  is correct, If you don't want to use any script then through list settings --> under advanced settings option you will find "Item Level Permission" as per below screenshot, change the settings accordingly:

      • rautchetan27's avatar
        rautchetan27
        Brass Contributor

        Ashish_Kohale RobElliott Lewis-H 

         

        I tried above solution

         

        list settings --> under advanced settings-->Create  and Edit access :None

         

        but this not overwrite item level permission which already given.

         

        means if for few list items if i have given edit permission to one particular user and if i changed settings as above( create and Edit access to None), still that use persist edit access, still that user have edit access...and its not get removed...

         

         

    • RobElliott's avatar
      RobElliott
      Silver Contributor

      Lewis-H that is not a solution as the poster wants to change permissions for 1 user only; not for everyone, for a specific security group or for someone in an Office 365 group.

       

      Rob
      Los Gallardos
      Microsoft Power Automate Community Super User

  • rautchetan27 :  Powershell script will easier and faster option in this case.

    You can do this using:

    1) Power Automate, use "Apply to Each" action.

    2) Nintex Workflow.

    3) SharePoint workflow - REST API and loop action.

    • rautchetan27's avatar
      rautchetan27
      Brass Contributor

      Ashish_Kohale 

       

      For each loop i tried, but you can not use " stop sharing" with each item for particular user.

      "stop sharing" will stop sharing it with all users.

Resources