How to enable Quick edit in SharePoint 2013 using Powershell

Question

Without using Powershell, we are able to enable the Quick Edit as mentioned in the below URL:

SharePoint 2013: Create Custom List Template and Set Default View To Datasheet View Programmatically

But we cannot use this in other environment as that environment doesn't use Visual Studio.

So , can anyone please suggest me a way to enable Quick edit in SharePoint 2013 using PowerShell.

Note: We even tried selecting all the check-boxes using OOB features. It was of no use.

Thanks in advance.

The screen shot of the list attached below:

Answer 1

I am understanding that you would want to create a list with a Datasheet view. The key property is

SPViewType=Grid , whose enum value is 2048 Refer here

Please find the code below where I create a view.

#Get destination site and list
$web = Get-SPWeb "https://devintranet.spdev/forms/"
$list = $web.Lists["tester"]

$viewTitle = "SampleDVView2"
#Add the column names from the ViewField property to a string collection
$viewFields = New-Object System.Collections.Specialized.StringCollection
$viewFields.Add("Title") > $null
#Query property
$viewQuery = "<OrderBy><FieldRef Name='Modified' Ascending='FALSE'/></OrderBy>"
#RowLimit property
$viewRowLimit = 50
#Paged property
$viewPaged = $true
#DefaultView property
$viewDefaultView = $true


#Create the view in the destination list
$newview = $list.Views.Add($viewTitle, $viewFields, $viewQuery, $viewRowLimit, $viewPaged, $viewDefaultView,2048,$false)

Answer 2

You can use the PowerShell command to enable Quick Edit in an existing list:

$WebURL="http://spsite"
$ListName="listname"
$Web = Get-SPWeb $WebURL
$List = $Web.Lists.TryGetList($ListName)
$List.DisableGridEditing=$false
$List.Update()

Besides, we can enable it via list settings->Advanced settings->select “yes” for Quick Edit section, if it doesn’t work in your environment, you can check the article to troubleshoot:

Fix Quick Edit Disabled in SharePoint 2013 Issue