SharePoint Diary

SharePoint Online: How to Delete a File from Document Library using PowerShell?

February 25, 2017 Client Side Object Model (CSOM), Document Library, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Delete a file from SharePoint Online document library using PowerShell How to Delete a File in SharePoint Online? To delete a single document from a library, do the following: In SharePoint Online site, Navigate to the document library. Select the File you want to delete and…

Set Global Search Center in SharePoint 2016

February 24, 2017 PowerShell, Search, SharePoint 2010, SharePoint 2013, SharePoint 2016

So, you have your search center site ready for SharePoint 2013 (Use this article: Create Enterprise Search Center using PowerShell ) as a next step, you should configure global search center from SharePoint central admin site to set default search center site for all site collections. SharePoin…

Add Rich Text Column in SharePoint Document Library

February 22, 2017 SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Designer, Tips and Tricks

Problem: Could not add rich text columns to SharePoint document library, Picture Library and other type of Libraries! Little background: End user created in document library with type "Description" column as "Multiple lines of text"and expecting this column to is expecting t…

Fix "Get-SPOSite: The Site 'https://tenant.sharepoint.com/' is not properly formed" Error in SharePoint Online

February 21, 2017 Errors, SharePoint Online, SharePoint Online Management Shell

Problem: When trying to connect to SharePoint Online site collection, got this error message "Get-SPOSite The Site Tenant-URL is not properly formed." Solution: Solution is simple! Just remove the trailing "/" from the URL! E.g. In my case, instead of " https://cr…

Compare SharePoint List Item Version History using PowerShell

February 19, 2017 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Version History

Requirement: Compare version history data of SharePoint List items and update a metadata column based on a particular field's value change. Bit background: We've a project tracking list with "Status" column. We wanted to have a insight on when a particular item's status w…

SharePoint Online: Change User Permissions using PowerShell

February 19, 2017 Client Side Object Model (CSOM), PowerShell, SharePoint Online, Users and Groups

Requirement: Edit user permissions in SharePoint Online How to change user permissions in SharePoint Online? You want to change user's permission on a particular site/library/item in SharePoint online. E.g. Once a particular project has completed and you no longer want the team member t…

SharePoint Online: Change Group Permissions using PowerShell

February 19, 2017 Client Side Object Model (CSOM), Permission, PnP PowerShell, PowerShell, SharePoint Online, Users and Groups

Requirement: SharePoint Online Change Group Permissions How to Update permissions for a SharePoint group? To edit group permissions in SharePoint Online, following these steps: Login to your SharePoint Online site as a administrator >> On the site collection Home page, click on Settin…

SharePoint Online: Remove Site Collection Administrator using PowerShell

February 19, 2017 Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online, Site Collection Administrator

Requirement: Remove Site collection Administrator using PowerShell in SharePoint Online. How to remove site collection administrator(s) in SharePoint Online? Site collection administrators in SharePoint Online have full control for the entire site collection, including the root site and all t…

SharePoint Online: Get List by Title using PowerShell

February 17, 2017 Client Side Object Model (CSOM), List, PowerShell, SharePoint Online

SharePoint Online: PowerShell to Get List by Title Here is how to get a list by its title. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program …

Fix for SharePoint 2016 Project Templates Missing in Visual Studio 2015

February 14, 2017 Known Issues, SharePoint 2016, Visual Studio

Problem: SharePoint Project Templates are missing in Visual Studio 2015! Solution: We need to install "Microsoft Office Developer Tools for Visual Studio 2015" for SharePoint 2016 project templates in Visual Studio 2015. For SharePoint 2010/2013, download and install: Microsoft O…

SharePoint Online: Get All Users in Site Collection using PowerShell

February 11, 2017 Client Side Object Model (CSOM), CSV, PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell, Users and Groups

Requirement: SharePoint Online PowerShell to Get All Users in Site Collection SharePoint Online: PowerShell Get All Users of the Site Collection While my another post addresses How to Get All Users and Groups in SharePoint Online , this post aims to get all users of the SharePoint site colle…

SharePoint Online: Create Announcement List using PowerShell

February 11, 2017 Client Side Object Model (CSOM), List, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Create Announcement List in SharePoint Online. How to Create Announcement list in SharePoint Online? As its name indicates, Announcements list in SharePoint Online is used to share announcements and news. It has "Title" and "Body" fields for announcement and a…

SharePoint Online: Copy Attachments from One List to Another using PowerShell

February 10, 2017 Attachment, Client Side Object Model (CSOM), List, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Copy Attachment from one list to another in SharePoint Online. PowerShell to Copy Attachment to Another List in SharePoint Online: Had a requirement to copy attachments between SharePoint Online lists. (only attachment - Not list items!). This script gets the attachments from sour…

List View Threshold in SharePoint Online - FAQs

February 10, 2017 Client Side Object Model (CSOM), Document Library, FAQs, List, List View, PowerShell, SharePoint Online

What is List View Threshold Limit in SharePoint Online? List View Threshold is a limit of 5000 items in SharePoint Online, which can't be exceeded! Although SharePoint Online can store up to 30 million items, when a list view tries to show more than 5000 items, you'll get "The atte…

SharePoint Online: How to Change Home Page using PowerShell?

February 08, 2017 Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online

Requirement: SharePoint Online Set Home Page How to Change Home page in SharePoint Online? The welcome page or Home page is the initial page displayed when you browse to a site. By default Home.aspx page in the Site Pages library is defined as the site welcome page. You can create a new page …

SharePoint Online: Get List Items from Folder using PowerShell

February 08, 2017 Client Side Object Model (CSOM), Folder, List Item, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Get all list items from a folder in SharePoint Online. SharePoint Online: PowerShell to Get List Items in a Folder Get all items from SharePoint list folder is a common requirement when working with client side object model scripts. Here is the SharePoint CSOM to get folder items…

"Delete this list" Missing in SharePoint? Here is the solution!

February 06, 2017 SharePoint 2013, SharePoint 2016

Problem: "Delete this list" option missing in SharePoint list settings! wanted to delete a particular list in SharePoint but could not find delete this list option under list settings. Tried deleting it from the list ribbon menu, SharePoint Designer, Content and structure tool, Explore…

SharePoint Online: Copy Files Between Site Collections using PowerShell

February 05, 2017 Client Side Object Model (CSOM), Document Library, File, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Copy Files between document libraries in SharePoint Online Site Collections. How to Copy a File Between SharePoint Online Site Collections? Here is how to copy files between document libraries in SharePoint Online: Navigate to your SharePoint Online document library>> Se…

SharePoint Online: Copy File Between Document Libraries using PowerShell

February 04, 2017 Client Side Object Model (CSOM), File, Folder, PnP PowerShell, PowerShell, SharePoint Online

Requirement: SharePoint Online PowerShell to copy files from one library to another How to Copy a File in SharePoint Online Document Library? Here is how to copy file in SharePoint Online Document Library: Navigate to your SharePoint Online document library. Right click on the file to copy …

SharePoint Online: Get All List Fields using PowerShell

February 03, 2017 Client Side Object Model (CSOM), Column, CSV, List, PnP PowerShell, PowerShell, SharePoint Online

Requirement: SharePoint Online PowerShell to Get All List Fields. How to Get List Fields in SharePoint Online? Navigate to list settings, under "Columns" section, you'll find all fields of the particular list. SharePoint Online: PowerShell to Get List Fields Here is the Sha…

Disclaimer