How to Enable-Disable Comments in SharePoint Online List?

The new comments feature introduced in SharePoint Online modern lists allows users to comment on SharePoint Online list items. Disable Comments in SharePoint Online List Items Although comments in SharePoint Online list items is a great new feature, in some scenarios you may want to hide it! E.g. It may cause confusion…

Read more

SharePoint Online: How to Hide Folders in Document Library and Show All Files?

When you have a complicated deep File-Folder structure, You may want to hide folders from the view and show all files without folders in the SharePoint document library view. Probably, you may want to use Metadata instead of Folders! How to hide folder in SharePoint Online document library? Here is how to…

Read more

SharePoint Online: Get Default List Form (New/Edit/Display) URLs using PowerShell

Requirement: Get the default list form URLs in SharePoint Online. How to Get the List Form URLs in a SharePoint Online List? Just open the SharePoint Online site in SharePoint Designer, Navigate to the Lists >> Open the Target List >> and You’ll find the default list of forms under the “Forms”…

Read more

How to Disable Export to Excel Button in SharePoint Online?

Requirement: Disable Export to Excel in SharePoint Online. How to Disable Export to Excel in SharePoint Online? A business team wanted to remove the ability to export list data into Excel. How do I disable or hide the “Export to Excel” button in modern SharePoint Online lists? Option 1: Create a Custom…

Read more

SharePoint Online: Update List Items from a CSV File using PowerShell

Requirement: Update SharePoint Online List from a CSV using PowerShell. PowerShell to Update SharePoint Online List from CSV File We have a list called “Projects” with a bunch of columns and wanted to update items from a CSV file. Here is the PowerShell CSOM script to update the SharePoint Online list from…

Read more

SharePoint Online: How to Get a List using PowerShell?

Requirement: PowerShell to Get a List in SharePoint Online. SharePoint Online: PowerShell to Get a List Here is how to access SharePoint Online list programmatically using PowerShell. Let’s get a list by title: You can use this script to get any list or library from a given SharePoint Online site. PnP PowerShell…

Read more

SharePoint Online: Hide “Content Type” Field from List Forms

Requirement: Remove Content Type Field from SharePoint Online List Forms How to hide “Content Type” field from SharePoint Online List Forms? When you enable content types for a SharePoint Online list, you’ll see “Content Type” as a field in SharePoint list forms such as New and Edit. This could be annoying sometimes,…

Read more

How to Add File Size Column to SharePoint Online Document Library?

Requirement: Add file size column to SharePoint Online How to Show File Size in SharePoint Online? You can add the “File Size” column to any list view of the SharePoint Online document library to get the size of each file. Just follow these steps to add the file size column to SharePoint…

Read more

SharePoint Online: How to Make a List Read-Only?

Requirement: Make a SharePoint Online list to read only. How to make a list read only in SharePoint Online? Well, there are no direct ways to set a SharePoint Online list to read-only. However, we can follow this workaround to make a list to read-only mode. Navigate to your SharePoint Online List…

Read more

How to Disable Quick Edit in SharePoint Online?

Requirement: Disable Quick Edit in SharePoint Online We have a project tracking list with the 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?…

Read more