SharePoint Online: View Folder Size using PowerShell

Requirement: Get Folder Size in SharePoint Online. How to C heck Folder Size in SharePoint Online? To view folder size in SharePoint Online, go to: Site Settings >> Click on "Storage Metrics" link under "Site Collection Administration" In the storage metrics page,…

SharePoint Online: Find and Delete Duplicate List Items using PowerShell

Requirement: Find and Delete Duplicate Items in SharePoint Online list using PowerShell Find Duplicate Rows in a SharePoint Online List using PowerShell Let's find duplicate items in "Projects" list in SharePoint based on the column: ProjectName. #Load SharePoint CSOM Assembl…

SharePoint Online: Get-Set Choice Field Value using PowerShell

Requirement: Get / Set Choice Field Value in SharePoint Online Here is my PowerShell scripts collection to read and update choice column values in SharePoint Online. PowerShell to Get Choice Field Value from a List Item in SharePoint Online: #Load SharePoint CSOM Assemblies Add-Type -Path …

SharePoint Online: Create Managed Metadata Site Column using PowerShell

Requirement: Create Managed Metadata Site Column in SharePoint Online using PowerShell How to Create a Managed Metadata Site Column in SharePoint Online? Managed Metadata column in SharePoint Online uses Term Set from the term store as the source for its allowed values. Term set defines set of…

SharePoint Online: Delete Permission Level using Powershell

Requirement: SharePoint Online Remove permission level using PowerShell Warning: Never delete any OOTB default permission levels in SharePoint! How to Delete Existing Permission Levels in SharePoint Online? To delete an existing permission level, in SharePoint Online, follow these steps: …

SharePoint Online: How to Check Group Permissions in a Site?

Requirement: Check Group Permission in SharePoint Online. How to Check SharePoint Online Group Permissions? SharePoint groups may be granted permission anywhere in a site collection. Here is how to view a group's permission assignments: Login to your SharePoint Online site >> Clic…

Limited-access user permission lockdown mode Feature in SharePoint

What is limited-access user permission lockdown mode? In SharePoint, users are assigned to the "Limited Access" permission level automatically when the account is granted exclusive access (unique permission) only to resources such as list/library/document, etc within the site, but no…

SharePoint Online: How to Approve Multiple Documents using PowerShell?

Requirement: Approve Multiple Documents in SharePoint Online using PowerShell How to Approve Multiple Items in SharePoint Online? When content approval is turned ON, each item must be approved in order to be visible to users. You can approve any item or document in SharePoint Online by: Right…

SharePoint Online: Download All Versions of a Document using PowerShell

Requirement: Download All Versions of a Document in SharePoint Online using PowerShell SharePoint Online: PowerShell to Download All Versions of a Document Version history in SharePoint Online lets you to store, track, and restore files in a library as they are changed. There are times you m…

PowerShell to Update Permissions for Custom Permission Level in SharePoint

Requirement: Update permission level in SharePoint using PowerShell How to Edit a Permission level in SharePoint? To edit an existing permission level in SharePoint, follow these steps: Permission levels are scoped at site collection. So, Navigate to SharePoint Site collection where yo…

How to Configure Audit Log to Capture All Deletes in SharePoint?

Requirement:   Track all delete operations in SharePoint How to Configure Audit Settings to Track Deletes in SharePoint Online? We can Track All Deletes in a SharePoint site collection using Audit Log Feature in three steps: Step 1: Make sure Reporting Feature is activated: Go to "Sit…

SharePoint Online: Find Permission Changes using Audit Reports

Requirement: Get all permission changes in a SharePoint Online site collection. Auditing permission changes is critical for SharePoint Online security. Audit reports provides permission changes report to track changes to security such as modifications to permissions, permission inheritance, g…

How to Create App Catalog Site in SharePoint Online?

What is App Catalog in SharePoint Online? App Catalog in SharePoint is a central location where we can manage custom-developed apps or 3rd party apps and make them available for users to download across all site collections. These apps are listed under the "From Your Organization" link…

SharePoint Online: Bulk Update All Items in Large List using PowerShell

Requirement: Bulk Update SharePoint Online List Items using PowerShell. How to Update a Large Number of List Items in Bulk using PowerShell? While lists < 5000 items can be updated using the approach in my other post, Update SharePoint Online List using PowerShell , How about updating la…

SharePoint Online: Delete List Items Created in the Past 7 Days using PowerShell

Requirement: Delete All List Items created within the past 7 days in SharePoint Online List. PowerShell to Delete SharePoint Online List Items based on Created Date #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1…

SharePoint Online: Fix "The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested" Error in PowerShell

Error: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested. Root cause: You must load the object before you are trying to retrieve its properties! Solution: Here is how the problem can be resolved …

SharePoint Online: Fix for "The remote server returned an error: (403) Forbidden" in PowerShell

Error: Exception calling "ExecuteQuery" with "0" argument(s): "The remote server returned an error: (403) Forbidden." in PowerShell scripts of SharePoint Online. Troubleshooting Checklist for 403 forbidden in SharePoint Online PowerShell: You may have provided…

SharePoint Online: Bulk Import Users to Groups from a CSV File using PowerShell

Requirement: Bulk add users from a CSV file to SharePoint Online Groups Here is the CSV file with users and groups data to bulk add users to groups: SharePoint Online: Bulk Add Users to Group using PowerShell  SharePoint Online groups help to manage security effectively by combining user a…

SharePoint Online: How to Get Direct Link to a Document In Modern Libraries?

Requirement: Get direct link to document in SharePoint Online. SharePoint Online: Get Direct Link to Document  Unlike SharePoint Online classic experience, modern document libraries doesn't provide direct link to documents. However, here is the trick to get direct link to file: Navigate …

SharePoint Online: Get Document Library Size using PowerShell

Requirement: Get the Size of a SharePoint Online Document Library PowerShell to Get List or Document Library Size in SharePoint Online: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Cl…

SharePoint Online: Get Subsite Size using PowerShell

Requirement: Get Subsite Size in SharePoint Online How to Get Subsite Size in S harePoint Online ? To find out the storage quota occupied by a subsite in SharePoint Online, go to: Site Settings >> Click on "Storage Metrics" link under "Site Collection Administration&quo…

SharePoint Online: How to Change Date Format to "DD/MM/YYYY"?

Requirement: Change Date format to "DD/MM/YYYY" in SharePoint Online. How to Set Date Format in SharePoint Online? By default, SharePoint Online sites display the dates in US format (MM/DD/YYYY). You may want to change the date format based on the country you live. Let's see ho…

SharePoint Online: Publish All Files in a Library using PowerShell

Requirement: Bulk Publish Multiple Files in SharePoint Online PowerShell to Check-in, Approve and Publish All Files in a Library: When you turn ON minor versioning in SharePoint Online document library, any edits will not appear to users with read-only (or view only) permissions until you pu…