SharePoint Diary

CAML Query to Filter Yes/No (Check box) Field Values using PowerShell

April 30, 2017 CAML, Client Side Object Model (CSOM), PowerShell, SharePoint Online

Requirement: CAML Query to Filter Yes/No Field Values in PowerShell CAML Query to Filter Yes/No Field Values in SharePoint Online: Lets use PowerShell to query Yes/No field type values from a SharePoint Online list. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Com…

SharePoint Online: Get Site Collection Storage Size - Quota Usage Report using PowerShell

April 30, 2017 Admin Reports, Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell

Requirement: Need to generate a report to analyze all SharePoint Online Site collection storage consumption. How to Get the Storage Metrics of a SharePoint Online Site Collection? To find the storage details of a site collection, Go to: Click on Settings gear and then select Site Settings. …

SharePoint Online: Get-Set "Yes/No (Check box)" Field Value using PowerShell

April 30, 2017 Client Side Object Model (CSOM), Column, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Get or Set Yes/No Field Value in SharePoint Online using PowerShell. PowerShell to Get Value of Yes/No Field in SharePoint Online: Here is how you can read Yes/No field programmatically using PowerShell. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Comm…

How to Delete OneDrive for Business Site Collection in SharePoint Online?

April 30, 2017 Office 365, OneDrive for Business, PowerShell, SharePoint Online, SharePoint Online Management Shell

Requirement: Delete OneDrive for Business Site Collection! After a business decision made to disable OneDrive in organization-wide, We configured the settings to disable OneDrive. However, All existing OneDrive sites were active, users can access them and we wanted to remove them all! Any Sha…

How to Set Secondary Admin for All OneDrive for Business Sites?

April 30, 2017 My Site, Office 365, OneDrive for Business, Permission, SharePoint Online

When SharePoint My Site or OneDrive for Business site collection is created by the user, SharePoint assigns primary site collection administrator rights to the user. At times, you may have to gain Admin access in situations such as User left the organization, troubleshooting, etc. In SharePoi…

There was a problem deleting Web site "Site-URL". Sites that have subsites or certain apps can't be deleted. Please try again after deleting all subsites and removing the apps.

April 29, 2017 Client Side Object Model (CSOM), Office 365, SharePoint Online, Subsite

Problem: If you try to delete a SharePoint Online site which has subsites in it, SharePoint throws error message saying " There was a problem deleting Web site "<subsite-url>". Sites that have subsites or certain apps can't be deleted. Please try again after deleting …

How to Gain Owner Access to OneDrive for Business Sites in Office 365?

April 29, 2017 Office 365, OneDrive for Business, PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell, Site Collection Administrator

By default, When SharePoint My Site or OneDrive site collection is created by the user, SharePoint assigns primary site collection administrator rights to the user. In some cases, you may need to access another user's OneDrive for Business site. E.g. User left the company and the manager of t…

SharePoint Online: Check if Feature is Activated using PowerShell

April 29, 2017 Client Side Object Model (CSOM), Features, PnP PowerShell, PowerShell, SharePoint Online

Requirement: PowerShell to check if feature is activated in SharePoint Online. How to Check if a specific Feature is Enabled in SharePoint? To check the current status of a SharePoint feature, Say: Publishing Feature - follow these steps: Navigate to Site Settings >> Click on "Sit…

SharePoint Online: Find Content Type usage using PowerShell

April 28, 2017 Content Type, PowerShell, SharePoint Online

Requirement: Find where a Content Type is used in SharePoint Online You may have to find the content type usage in scenarios like, You are getting "content type is still in use" error when trying to delete a content type. You are trying to figure out where a particular content typ…

SharePoint Online: Set Content Type to Read Only using PowerShell

April 27, 2017 Client Side Object Model (CSOM), Content Type, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Make a Content type to read only in SharePoint Online. How to Make a Content Type to Read-Only in SharePoint Online? To set a content type to read only: Go to Settings >> Site settings Click on "Site content types" link From the content types listed, Click on t…

SharePoint Online: Update List Title, Description, Quick Launch Navigation Properties using PowerShell

April 26, 2017 Client Side Object Model (CSOM), Document Library, List, PnP PowerShell, PowerShell, Quick Launch, SharePoint Online

Requirement: Set Title, Description and Quick Launch Navigation settings in a SharePoint Online List. How to Update List Title, Description and Quick Launch Navigation Settings in SharePoint Online? To set list title, description and quick launch navigation options in SharePoint Online, follow…

SharePoint Online: PowerShell to Iterate Through All Files in a Document Library

April 24, 2017 Client Side Object Model (CSOM), Document Library, File, PnP PowerShell, PowerShell

Requirement: Get List of Files in a SharePoint Online Document Library using PowerShell SharePoint Online PowerShell to Iterate through All Files in a Document Library: Often in PowerShell scripting, we may have to loop through each file in a SharePoint Online libraries. This PowerShell script…

How to Enable External Sharing in SharePoint Online?

April 24, 2017 Client Side Object Model (CSOM), External Sharing, External User, Office 365, PnP PowerShell, PowerShell, Security, SharePoint Admin Center, SharePoint Online, Users and Groups

Requirement: Enable external sharing in SharePoint Online using PowerShell How to Enable External Sharing in SharePoint Online? SharePoint Online allows you to collaboratively share your content with external users such as vendors, clients, customers, etc. To enable external sharing, you shou…

How to Set Choice Field Default Value to Blank in SharePoint?

April 23, 2017 Tips and Tricks

By default, when you create a new choice field, the very first choice you entered is also set as "Default value" in field settings. This results filling up the default value for the field in new item creation page (NewForm.aspx). However, there are times you may want to have a empty val…

Get-Set Choice Field Value in SharePoint using PowerShell

April 23, 2017 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Here is my nifty collection of PowerShell scripts to read or update values in Choice column in SharePoint. SharePoint: PowerShell to Get Choice Field Value PowerShell to get choice field values #Define URL and List name variables $WebURL="http://intranet.crescent.com/" $List…

Enable Blank Site Template in SharePoint 2016

April 22, 2017 PowerShell, SharePoint 2013, SharePoint 2016, Site Collection, Site Template

Problem: Blank site template is not available in SharePoint 2013 and SharePoint 2016. If you try to create a site collection from SharePoint Central Administration site or try to create a subsite, you'll find blank site template missing from the create site collection page. Unlike its prev…

Remove SharePoint Web Application Policy using PowerShell

April 20, 2017 Central Administration, PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Remove Web Application Policy using PowerShell How to remove a web application Policy in SharePoint? To remove a user or group from SharePoint web application Policy, follow these steps: Login to SharePoint Central Administration Site Application Management >> Manage Web…

How to Delete a Host Named Site Collection in SharePoint using PowerShell?

April 20, 2017 Host-named Site Collection, PowerShell, SharePoint 2013, SharePoint 2016

Requirement: Delete host named site collection using PowerShell in SharePoint. How to Delete host named Site Collection? Generally, Host named site collections in SharePoint are managed through PowerShell. Prior to SharePoint 2013, You cannot delete host named site collections from Central Ad…

SharePoint Online: PowerShell to Loop Through List Items

April 19, 2017 Client Side Object Model (CSOM), List, PowerShell, SharePoint Online

Requirement: SharePoint Online PowerShell to Loop through List Items Make sure you have SharePoint Online Client SDK downloaded and installed in your machine before running the script: https://www.microsoft.com/en-us/download/details.aspx?id=42038 PowerShell to Loop through List Items in Sha…

"Audit Log Reports" Link Missing in SharePoint?

April 19, 2017 Audit, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Online

Problem: Audit log reports missing in SharePoint! We enabled auditing for a SharePoint Online site collection but when under site settings page, found "Audit Log Reports" link missing. How to enable audit log reports in SharePoint? To enable audit log reports in SharePoint On-premi…

Style SharePoint 2016 List View Web Part with Custom CSS

April 16, 2017 Branding, CSS, List View Web Part, SharePoint 2013, SharePoint 2016, SharePoint Online

Requirement: Add a custom style to SharePoint 2016's standard list view web part to make it look like a dashboard! By default, SharePoint list view web part looks dull, isn't it? So, lets add some custom CSS to the SharePoint 2016 list view, to make it look like a dashboard! How to a…

SharePoint Online: CAML Query for Choice Field in PowerShell

April 05, 2017 CAML, Client Side Object Model (CSOM), PowerShell, SharePoint Online

Requirement: CAML Query for Choice Field in SharePoint Online using PowerShell. Get List Items Where a Choice Field is Equal to Particular Value: Lets get all projects from projects list where the "Priority" choice field is "Medium" #Load SharePoint CSOM Assemblies Add-Ty…

SharePoint Online: CAML Query for Lookup Field in PowerShell

April 05, 2017 Client Side Object Model (CSOM), PowerShell, SharePoint Online

Requirement: CAML Query for Lookup field in SharePoint Online using PowerShell CAML for SharePoint Lookup Field Value: Lets filter projects by parent project lookup field value "Address Book". Here is the SharePoint CAML for lookup field. #Load SharePoint CSOM Assemblies Add-Type -…