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…
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. …
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…
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…
When SharePoint My Site or OneDrive for business site collection are 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 ShareP…
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 …
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.
Reviewed by Salaudeen Rajack
on
April 29, 2017
Rating: 5
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…
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…
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…
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…
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: Update List Title, Description, Quick Launch Navigation Properties using PowerShell
Reviewed by Salaudeen Rajack
on
April 26, 2017
Rating: 5
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…
Requirement: Enable external sharing in SharePoint Online using PowerShell SharePoint Online allows you to collaboratively share your content with external users such as vendors, clients, customers, etc. To enable external sharing, you should turn on external sharing both on tenant level as w…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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 -…
Requirement: SharePoint Online CAML Query for Person or Group field SharePoint Online: CAML Query to Filter Person or Group Field in PowerShell Lets say, we want to filter and get all projects where "Project Manager" user field value is a particular person. #Load SharePoint CSOM As…
