SharePoint Diary

SharePoint Online: Configure List Settings using PowerShell

June 30, 2017 Client Side Object Model (CSOM), List Settings, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Edit List Settings in SharePoint Online using PowerShell How to Change List Settings in SharePoint Online? List settings in SharePoint Online defines the attributes of the list such as Name, description, etc and functionality of the lists. These settings can be configured by navi…

Configure Resource Throttling Settings for Large Lists in SharePoint 2016

June 30, 2017 Best Practices, Central Administration, Configuration, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is resource throttling in SharePoint? The biggest performance bottleneck in SharePoint sites is caused usually by large lists. If you have 50 simultaneous users in a site and two of them are contributing to large lists, all 50 users will experience very slow performance. Luckily starting…

SharePoint Online: How to Move a Folder using PowerShell?

June 30, 2017 Client Side Object Model (CSOM), Folder, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Move a Folder to Another Library or Another Site in SharePoint Online. How to Move a Folder in SharePoint Online? Moving a folder in SharePoint Online modern experience is quite simple. Navigate to your SharePoint Online library >> Select the Folder to move From the Too…

SharePoint Online: Find Site Column Usage in Content Types using PowerShell

June 29, 2017 Client Side Object Model (CSOM), Content Type, PowerShell, SharePoint Online, Site Columns

Requirement: Find Site Column Usage in Content Type in SharePoint Online site collection. Little background: When trying to delete a site column in SharePoint Online, Got a error message: "site columns which are included in content types cannot be deleted. Remove all references to this sit…

How to Get SharePoint Farm Account?

June 24, 2017 Security, SharePoint, SharePoint 2010, SharePoint 2013

SharePoint Farm Account manages the farm services. It runs SharePoint timer service, Used in application pool identity for Central Administration site and in database access. Typically configured at the time you run PSconfig wizard. How to Get SharePoint Farm Account? To identify SharePoint Fa…

SharePoint Online: How to Save Site as Template?

June 22, 2017 SharePoint Online, Site Template

Requirement: Save SharePoint Online Site as Template! Site templates are the quickest way to define the skeleton of a particular standard in SharePoint. It provides great re-usability so that we can create as many sites as we want from the template without manually re-creating them. So, After …

SharePoint Online: Save Site as Template Option Missing?

June 21, 2017 PowerShell, SharePoint Online

Problem: "Save Site as Template" option missing in SharePoint Online! How to Enable Save Site as Template in SharePoint Online? To fix this problem, we need to enable custom scripts. Here is how to fix the save site as template not available issue. Login to SharePoint Online Ad…

Fix "Sorry, You don't have access" Access Denied Error on Save Site as Template in SharePoint Online

June 21, 2017 Known Issues, SharePoint Online

Problem: Getting "Sorry, You don't have access" access denied error when trying to save site as template in SharePoint Online site from URL: https://crescent.sharepoint.com /_layouts/15/savetmpl.aspx Solution: To fix this problem, we need to enable custom scripts. Here is how t…

SharePoint Online: Change Time Zone using PowerShell

June 20, 2017 Client Side Object Model (CSOM), OneDrive for Business, PnP PowerShell, PowerShell, SharePoint Online, Site Settings

Requirement: Change Timezone in SharePoint Online. How to Change Timezone in SharePoint Online? As a global organization operating in different regions and time zones, we wanted to set time zones for respective sites since users get annoyed when they see Pacific time zones in uploaded documen…

SharePoint Online: PowerShell to Delete a Document Library

June 19, 2017 Client Side Object Model (CSOM), Document Library, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Delete SharePoint Online Document Library using PowerShell How to delete a document library in SharePoint Online? To delete a document library in SharePoint Online, follow these steps: Login to SharePoint Online, Navigate to the document library Click on Settings >> Libr…

SharePoint Online: Delete Drop Off Library using PowerShell

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

Requirement: Remove drop off library in SharePoint Online. Site owner activated "Content Organizer" feature in a site which brought "Drop Off Library" into the SharePoint Online site. Now, when he tried deleting this library by going to library settings, he could not find …

How to Secure SharePoint 2016 Central Administration Site from HTTP to HTTPS using SSL Certificate?

June 11, 2017 Central Administration, Security, SharePoint 2013, SharePoint 2016, SSL Certificate

Central Administration site is a web application where administration activities are performed for the farm. By default, Central Administration runs on non-secure HTTP. Enabling encryption ensures that the communications between users and the central admin website remain secure. Prerequisite: …

SharePoint Online: How to Inject CSS using Custom Action in PowerShell?

June 09, 2017 CSS, Custom Action, PowerShell, SharePoint Online

Requirement: Add Custom CSS to SharePoint Online without editing Master page PowerShell to Add CSS to SharePoint Online: Assuming you have "Custom.CSS" file uploaded to "Site Assets" library, Here is the PowerShell to insert CSS to SharePoint Online site. #Load SharePoint…

SharePoint Online: PowerShell to Inject JavaScript using Custom Action

June 09, 2017 Custom Action, Javascript, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Online

Requirement: Inject JavaScript into SharePoint Online using PowerShell SharePoint Online Inject JavaScript using PowerShell: Lets insert JavaScript to SharePoint Online using PowerShell, without modifying the Master page! #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\…

SharePoint Online: Find All Checked Out Files using PowerShell

June 08, 2017 Client Side Object Model (CSOM), File, Office 365, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Find All Checked Out files in SharePoint Online A bit background: Client have a large document library with bunch of check out documents and want them to make available to end users. So, tried creating a view which filters all checked out files, but it failed because of list vi…

SharePoint Online: Change Navigation Settings using PowerShell

June 08, 2017 Client Side Object Model (CSOM), Navigation, PowerShell, SharePoint Online

Requirement: SharePoint Online Set navigation using PowerShell How to Change Navigation in SharePoint Online? To change navigation in SharePoint Online, Go to: Site Settings >> "Navigation" under "Look and Feel" group Set the navigation settings for global navigat…

SharePoint Online: Site Users and Groups Report using PowerShell

June 07, 2017 Admin Reports, Permission, PowerShell, SharePoint Online, SharePoint Online Management Shell, Users and Groups

Requirement: Generate a report with all site groups and members of each group of a SharePoint online site collection. Prerequisites: Make sure you have SharePoint Online Management Shell installed! Get all Site Groups and Members of Each group: #Import SharePoint Online Management Shell Im…

SharePoint Online: Access Denied Error on Navigation Settings

June 07, 2017 Known Issues, Navigation, SharePoint Online

Problem: When trying to change the navigation settings of a SharePoint Online site, got access denied error. Access Required: Sorry, you don't have access. I'm sure, I am a Global Admin in Office 365, and Site Collection Administrator for that particular site collection. Tried the Po…

Change SQL Server Database Initial Size and Auto Growth Settings using PowerShell

June 07, 2017 PowerShell, SharePoint, SQL Server

Requirement: After a new farm deployment, I had to raise the size and growth of all SharePoint content databases. There were 20+ in the initial setup. As per SQL Server best practices for SharePoint , we must set the initial size and growth properties of the SharePoint content databases for be…

SharePoint Online: Export Permissions of a Site, List, Item using PowerShell

June 06, 2017 Admin Reports, Client Side Object Model (CSOM), CSV, Document Library, List, List Item, Permission, PowerShell, SharePoint Online

Requirement: Export permissions applied on a particular SharePoint Site, List or List Item to CSV report. PowerShell to Export Permissions of a Site, List, List Item in SharePoint Online: This PowerShell script extracts and exports Immediate (not on any underlying objects) permissions of the g…

Disclaimer