Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / productivity / SharePoint

List and AllowDelete Property

0.00/5 (No votes)
20 Aug 2012CPOL2 min read 20.9K   70  
How to protect a list by disabling the Delete list option using Visual Studio and PowerShell.

Introduction

In this article we can explore how to protect a list from getting deleted by the user. In real world scenarios there are chances that the user can use the List Settings > Delete list option. 

Image 1

We have to make sure that the above option is hidden for the user through the SharePoint user interface.

There are multiple ways to achieve this:

  • Use  Visual Studio to set the list property AllowDeletion to false.
  • Use PowerShell to set the list property AllowDeletion to false.
  • Create a new Permission with Delete Restriction on List and assign to the user.

Here we are using the Visual Studio and PowerShell approach to disable the Delete option.

Visual Studio Approach

Create a new list in your SharePoint site and name the list New List. Ensure that through the List Settings page you can see the Delete this list link.

Image 2

Now create a new console application inside Visual Studio and name it AllowDeletionFalse.

Image 3

Inside the code modify the Main method as shown below:

C#
static void Main(string[] args)
{
    SPSite site = new SPSite("http://localhost");
    SPWeb web = site.OpenWeb();

    SPList list = web.Lists["New List"];
    list.AllowDeletion = false;

    list.Update();
}

The code above connects to the URL specified, gets the instance of the list named New List and modifies the property AllowDeletion to false.

Build and execute the application. If it is executed without errors the list now has the Delete link hidden. You can verify this by going back to the List Settings page inside SharePoint.

Image 4

From the Permissions and Management group you can see that the Delete this list link is missing. This makes our list protected from unwanted delete activity by a user.

PowerShell Approach

Now we can try to reverse the AllowDeletion property using PowerShell script.  Please note that for these type of scenarios on client locations, PowerShell would be more handy. (Visual Studio might not be installed in the customer premises.)

You can start the PowerShell Editor aka ISE (Integrated Script Editor) from Start > Programs > Accessories > Windows Power Shell menu group.

Image 5

The editor is shown below. Save the default file as AllowDeletionFalse.ps1. (ps1 is the extension for PowerShell scripts).

Image 6

Following is shown above in the .ps1 file.

C#
If ((Get-PSSnapIn -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) 
{ 
   Add-PSSnapIn -Name Microsoft.SharePoint.PowerShell 
}

$web = Get-SPWeb -Identity "http://localhost" -AssignmentCollection $assignment
$list = $web.lists["New List"]
$list.AllowDeletion = $true
$list.Update()

Code Explained

The first If block makes sure that the Microsoft.SharePoint.PowerShell snap-in is loaded into memory. (It is similar to Add Reference in Visual Studio.)

The Get-SPWeb cmdlet retrieves the reference to the specified web application. web.lists returns the reference to our New List. After setting AllowDeletion to true the list is updated. You can use the Run command of the PowerShell editor to execute the code.

Image 7

Once the code executes successfully our New List should have the Delete this list link visible in the List Settings. You can refresh the List Settings page to ensure that it is restored.

Image 8

References

Summary

In this article we have seen how to protect a list by disabling the Delete list option using Visual Studio and PowerShell. The source code is contained in the attachment.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)