SharePoint Diary

SharePoint Online: How to Apply Site Policy using PowerShell?

August 30, 2019 PowerShell, SharePoint Online, Site Collection

Requirement: Apply site policy in SharePoint Online using PowerShell. How to Apply SharePoint Online Site Policy using PowerShell? Site Policies is a great way to implement governance in SharePoint Online. As of today, we can't create a new site policy through PowerShell! However, we …

SharePoint Online: How to Replace Classic Root Site Collection with a Modern Site?

August 30, 2019 PowerShell, SharePoint Online

Requirement: Convert SharePoint Online Root site collection from classic to modern experience! Our requirement is, We built a new Intranet based on a Modern SharePoint Communication site and want to swap into the root site. How to change the root site from classic to modern Experience? As Sh…

Connect to SharePoint Online using PowerShell with Multi-factor Authentication (MFA)

August 30, 2019 Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online

Requirement: Connect to SharePoint Online from PowerShell using multi-factor authentication. PowerShell to connect to SharePoint online with MFA Multi-Factor Authentication in Office 365 environments is often enabled as part of security hardening. Instead of typical user id and passwords, it a…

Find out Who has Deleted a Site Collection in SharePoint

August 29, 2019 IIS, PowerShell, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Collection

Requirement: Find out who has deleted a site collection in SharePoint 2016. How to Find Who Deleted a SharePoint Site? Unfortunately, there are no direct ways to find out who deleted a SharePoint site. The PowerShell cmdlet "Get-SPDeletedSite" gets you all deleted site collect…

SharePoint Online: Find All Unused Sites based on Last Modified Date

August 29, 2019 Admin Reports, Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online, Site Collection, Subsite

Requirement: Get All Unused SharePoint Online Sites PowerShell to Find Unused Sites in SharePoint Online Let's find the Last Modified Date value of a given site using PowerShell. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Serv…

Office 365: Get OneDrive for Business Usage Report using PowerShell

August 28, 2019 Admin Reports, Office 365, OneDrive for Business, PowerShell

Requirement: Get OneDrive for business usage report using PowerShell How to Check the OneDrive for Business Usage for a User in Office 365? To get the storage usage on OneDrive for business for a specific user, Login to Office 365 Admin Centre, Search and find the user. From user settings p…

Fix "There was an error while attempting to get the themes" Error in SharePoint Online

August 28, 2019 Errors, SharePoint Online, Theme

Problem: When trying to change site theme in SharePoint Online through "Settings >> Change the Look >> Theme" got an error message "There was an error while attempting to get the themes". Workaround: When you do multiple changes to the site's look and feel like…

OneDrive for Business: How to Remove Site Collection Administrator?

August 27, 2019 OneDrive for Business, PowerShell, SharePoint Online, Site Collection Administrator

Requirement: Remove user from OneDrive for Business Administrator. How to Remove User from OneDrive for Business Site Collection? If you are a site collection admin to a OneDrive site, You can do the following to remove a user from site collection admin list. Login to the target OneDrive for bus…

SharePoint Online: Bulk Update User Profiles using PowerShell

August 27, 2019 Azure AD, PnP PowerShell, PowerShell, SharePoint Online, User Profile

Requirement: By default, SharePoint Online synchronizes only certain properties from Azure AD. As there are no custom property mappings available in user profile service, we got to write our own script or utility to sync additional attributes to SharePoint Online user profiles. How to Bulk Upda…

OneDrive for Business: How to Increase Storage Quota for a User?

August 26, 2019 Office 365, OneDrive for Business, PowerShell

Requirement: Increase OneDrive for Business Storage Quota using PowerShell. How to Increase OneDrive for Business Storage for One User? The storage quota allocated to each user's OneDrive for Business site depends on your Microsoft 365 subscription plan. Say for e.g. if you have plans li…

SharePoint Online: Get All Items Created or Modified by a Specific User

August 25, 2019 Client Side Object Model (CSOM), File, List Item, PnP PowerShell, PowerShell, SharePoint Online, Users

Requirement: Find All List Items Created or Modified by a Specific User PowerShell to Get All Files Created or Modified by a Particular User #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoi…

SharePoint Online: How to Add New User Profile Property?

August 23, 2019 SharePoint Online, User Profile

Requirement: Create user profile property in SharePoint Online. How to add new user profile property in SharePoint Online? A SharePoint user profile is the collection of user properties that describes a single user. By default, SharePoint Online comes with a rich set of user profile propert…

How to Make a Subsite Read-Only using PowerShell?

August 21, 2019 Permission, PowerShell, SharePoint 2010, SharePoint 2013, SharePoint 2016, Subsite

Requirement: Make a SharePoint Subsite read-only. This method replaces all other permissions applied on the subsite with "Read" and can't be reverted! Make sure you are proceeding only in scenarios where you don't need to revert the read-only (E.g. Post migration)! You can take…

SharePoint Online: Fix "Error 0x800700DF: The file size exceeds the limit allowed and cannot be saved"

August 20, 2019 Errors, Known Issues, SharePoint Online

Problem: When copying a file from SharePoint Online through file explorer, got this error message "An unexpected error is keeping you from copying the folder. If you continue to receive this error, you can use the error code to search for help with this problem. Error 0x800700DF: The fi…

OneDrive for Business: Set the Default Storage Quota

August 20, 2019 OneDrive for Business, PowerShell

Requirement: Set the default OneDrive for Business storage space. How to Change OneDrive for Business Default Storage Limit? The default storage space allocated to users in OneDrive for Business depends on your Microsoft 365 subscription plan. Say for e.g. if you have plans like "Office 3…

How to Set Retention Period in OneDrive for Business?

August 20, 2019 Office 365, OneDrive for Business, PowerShell

Requirement: Increase Onedrive for Business Retention Period How to Configure OneDrive for Business Deleted User Retention? In a typical scenario, When a user leaves the company, the user account is deleted from the Active Directory and it gets synchronized to Microsoft 365 environment. Then…

Create Modern Page in SharePoint Online using PowerShell

August 16, 2019 Page, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Create Modern Page in SharePoint Online using PowerShell How to Create a Modern Page in SharePoint Online? Modern site pages are fast, Responsive, easy to author and support rich multimedia content. To create a modern site page, follow the below steps: Logon your SharePoint Onl…

Fix "App Step" is Disabled in SharePoint Designer Workflow

August 13, 2019 SharePoint Designer 2013, SharePoint Online, Workflows

Problem: "App Step" is grayed out in SharePoint Designer Workflow! What is App Step in SharePoint? SharePoint designer workflows get executed from the context of the user who initiated the trigger – started the workflow. E.g. If a workflow gets triggered on new item creation, it g…

Disclaimer