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 Copy Permissions from One List to Another in SharePoint Online using PowerShell?

Requirement: Copy permissions from one list to another in SharePoint Online. PowerShell to Copy Permissions Between SharePoint Online Lists and Libraries There are no ways to clone permissions from an existing list to a new list in SharePoint Online without using 3rd party tools. Well, Not anymore! Here is the PowerShell script…

Read more

SharePoint Online: Show/Hide a Form Field based on Another Field’s Value using Conditional Formula

Requirement: Show or Hide a field based on another field’s value in SharePoint Online list form. How to Show or Hide a Field based on Another Field in SharePoint Online? In the past, we used to achieve this using jQuery Show or Hide SharePoint List Form Fields based on Another Field’s Value…

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