How to Disable Quick Edit in SharePoint Online?

Requirement: Disable Quick Edit in SharePoint Online

We've a project tracking list with field "Project Health" which is updated by an event receiver based on certain parameters and business logic. So, we made the field hidden in SharePoint online using: SharePoint Online: How to Hide a Column from List Forms?, However, users can go to "Quick Edit" mode of the list and they get the hidden field there! Although the column was hidden from New and Edit Forms, SharePoint Online quick edit still displays the hidden field and we wanted to disable quick edit for the SharePoint Online list.
how to disable quick edit in sharepoint online

How to Disable Quick Edit in SharePoint Online?
To disable quick edit in SharePoint Online, follow below steps:

  • Navigate to the List >> Click on Settings >> List settings >>
  • Click on "Advanced settings" link under list settings page.
  • In Advanced Settings link, Scroll down and Under "Quick property editing " option, choose "No" for "Allow items in this list to be edited using Quick Edit?" and then click OK.

    This disables quick edit in SharePoint Online list even in classic mode.

how to disable quick edit in sharepoint 2013

 
PowerShell to Disable Quick Edit in SharePoint Online:

#Parameters
$SiteURL = "https://crescentintranet.sharepoint.com/sites/Marketing"
$ListName = "Projects"
 
#Connect to the site
Connect-PnPOnline $SiteURL -UseWebLogin

#Get the List 
$List = Get-pnpList -Identity $ListName

#Disable Quick Edit in SharePoint Online List
$List.DisableGridEditing = $True
$List.Update()
Invoke-PnPQuery
To hide quick edit in SharePoint On-premises, use: How to Disable Quick Edit in SharePoint?

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.