SharePoint Diary

SharePoint Online: Get a Document Library using PowerShell

August 25, 2018 Client Side Object Model (CSOM), Document Library, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Get a Document Library in SharePoint Online using PowerShell SharePoint Online: Get a Document Library using PowerShell Here is the PowerShell to Get SharePoint Online document library #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microso…

SharePoint Online: Move All Files from One Folder to Another using PowerShell

August 24, 2018 Client Side Object Model (CSOM), File, Folder, PowerShell, SharePoint Online

Requirement: Move All Files Between Folders in SharePoint Online using PowerShell PowerShell to Move All Files from One Folder to Another in SharePoint Online: Here is the PowerShell to move all files from one folder to another folder #Load SharePoint CSOM Assemblies Add-Type -Path "…

SharePoint Online: Delete All Files and Sub-Folders from a Folder Recursively using PowerShell

August 21, 2018 Client Side Object Model (CSOM), Folder, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Empty a Folder in SharePoint Online document library by deleting all its files and Sub-Folders recursively. PowerShell to Delete All Files and Sub-Folders from a SharePoint Online Folder Let's delete a folder with subfolder and files from SharePoint Online. #Load SharePoint…

Fix 'You have to delete all the items in this folder before you can delete the folder" Error in SharePoint Online

August 20, 2018 Errors, SharePoint Online

Problem: When trying to delete a folder which has sub-folders and files, got an error message "You have to delete all the items in this folder before you can delete the folder" in SharePoint Online. Root Cause: Usually, we don't need to empty the folder before we delete it. Ho…

SharePoint Online: How to Enable Rating in List using PowerShell?

August 17, 2018 Client Side Object Model (CSOM), Document Library, List Settings, PowerShell, SharePoint Online

Requirement: Enable Rating in SharePoint Online List How to Enable Rating in SharePoint Online? Rating feature in SharePoint Online helps to highlight documents and list items. Rating can be enabled in SharePoint Online list and libraries to let users to see and rate items. Rating can be con…

SharePoint Online: Export User Information List using PowerShell

August 17, 2018 Client Side Object Model (CSOM), CSV, PowerShell, SharePoint Online, Users

Requirement: Export User Information List in SharePoint Online User Information List in SharePoint Online stores information about a user by having some metadata set up for the user such as User Picture, Email, DisplayName, LoginName etc. When we grant permissions to a user, they are added …

SharePoint Online: Create Document Set using PowerShell

August 16, 2018 Client Side Object Model (CSOM), Content Type, PowerShell, SharePoint Online

Requirement: Create a Document Set in SharePoint Online using PowerShell SharePoint Online: Create Document Set using PowerShell While my another post explains Creating Document Set in SharePoint Online - Step by Step , here is the PowerShell script to create document sets in SharePoint Online…

SharePoint Online: Create a Document Set - Step by Step

August 16, 2018 Content Type, SharePoint Online, Step By Step Guide

What is Document Set in SharePoint Online? As it's name indicates, document set is a set of related documents wrapped inside a special folder that allows multiple documents to be managed together and treated as if they were a single item. In other words, Document Set allows you to group doc…

Office 365: Find All SharePoint Online Administrators using PowerShell

August 16, 2018 Office 365, PowerShell, SharePoint Online

Requirement: Get All SharePoint Online Administrators of the Office 365 tenant. How to Check If a User is SharePoint Online Administrator in Office 365? To find if a user is SharePoint Online Administrator, do the following: Login to Office 365 Admin Center: https://admin.microsoft.com Expa…

SharePoint Online: Import Term Group, Term Set, Term from XML using PnP PowerShell

August 15, 2018 PnP PowerShell, SharePoint Online, Term Store, XML

Requirement: Import Term group, term set and terms data from a XML file to SharePoint Online using PnP PowerShell. XML File with Term Store Data: Here is my XML with Term store data <pnp:TermGroups xmlns:pnp="http://schemas.dev.office.com/PnP/2018/07/ProvisioningSchema"> <…

SharePoint Online: PowerShell to Get a File

August 13, 2018 Client Side Object Model (CSOM), Document Library, File, PowerShell, SharePoint Online

Requirement: Get a File from SharePoint Online using PowerShell. PowerShell to Get a File from SharePoint Online Here is my nifty collection of PowerShell scripts to get a file from SharePoint Online. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Micro…

SharePoint Online: Delete All Unique Permissions from a Site Collection using PowerShell

August 13, 2018 Client Side Object Model (CSOM), List, List Item, Permission, PowerShell, SharePoint Online, Site Collection, Subsite

Requirement: Remove unique permissions from a SharePoint Online site collection and restore permission inheritance from the parent. PowerShell Script to Restore Permission Inheritance in SharePoint Online: SharePoint Online allows us to manage permissions at more granular level when we need …

SharePoint Online: Filter List View to Show Files Only from a Sub-Folder using PowerShell

August 13, 2018 Client Side Object Model (CSOM), Folder, List View, PowerShell, SharePoint Online

Requirement: Set a list view filter to show files from a specific folder in a SharePoint Online document library. How to Set the View Filter to Show Files from a Folder? Unfortunately, The SharePoint web user interface doesn't provide us an option to set view filter based on folder, sub-…

SharePoint Online: PowerShell to Disable Modern Experience

August 12, 2018 Client Side Object Model (CSOM), List Settings, PnP PowerShell, PowerShell, SharePoint Online, Site Collection

Requirement: Disable modern experience in SharePoint Online. How to Disable New User Experience in a List and Switch back to Classic View? Definitely the modern experience in SharePoint Online lists and libraries is faster, mobile friendly and easier to use. It brings new functionalities and c…

SharePoint Online: PowerShell to Get List ID (GUID)

August 12, 2018 Client Side Object Model (CSOM), Document Library, List, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Get List ID in SharePoint Online using PowerShell How to Get the List ID in SharePoint Online? If you go to List Settings of any list or library, the URL looks like https://crescent.sharepoint.com/_layouts/15/listedit.aspx?List= d50ffc71%2D8b0f%2D4cbe%2Da1db%2D5667fee88468 , Here…

SharePoint Online: Delete Unique Permissions in a Subsite using PowerShell

August 12, 2018 Client Side Object Model (CSOM), Permission, PowerShell, SharePoint Online, Subsite

Requirement: Delete Unique Permissions of a Subsite in SharePoint Online using PowerShell How to Remove Unique Permissions of a SharePoint Online Site? Removing unique permissions and restoring permission inheritance for a subsite allows its security to be managed at the parent site level, in…

SharePoint Online: PowerShell to List All Files in a Document Library

August 11, 2018 Client Side Object Model (CSOM), CSV, Document Library, File, PnP PowerShell, PowerShell, SharePoint Online

Requirement: List All Documents in a SharePoint Online Document Library using PowerShell. SharePoint Online: PowerShell to Get List of Files in Document Library Here is the SharePoint Online PowerShell to list all documents: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program F…

SharePoint Online: PowerShell to a Get List

August 11, 2018 Client Side Object Model (CSOM), Document Library, List, PnP PowerShell, PowerShell, SharePoint Online

Requirement : Get a list in SharePoint Online using PowerShell PowerShell to Get a SharePoint Online List Let's get a list in SharePoint Online and count items in a list using PowerShell: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\…

SharePoint Online: PowerShell to Disable Versioning

August 11, 2018 Client Side Object Model (CSOM), List Settings, PnP PowerShell, PowerShell, SharePoint Online, Version History

Requirement: Disable Versioning in SharePoint Online using PowerShell How to Disable Versioning in SharePoint Online? Versioning feature in SharePoint Online creates a copy of items when someone changes a document, so that we can track every change to the document and revert to old version if …

Disclaimer