Skip to main content

Posts

PowerShell Automation for Smart SharePoint List Migration

PowerShell Automation for Smart SharePoint List Migration Migrating data between SharePoint environments is one of those tasks that looks simple on paper—but in practice, it’s easy to get tangled in duplicates, mismatched fields, or incomplete moves. With many organizations moving from on-premises SharePoint Server to SharePoint Online , automation becomes key to a smooth transition. This guide walks through a PowerShell script that not only moves list items from an on-premises SharePoint list to the cloud but also checks for duplicates before copying. Let’s break it down. Why Automate the Migration? Traditional migrations often copy everything from the source list to the destination list—whether or not those items already exist in the target. The result? Duplicates, clutter, and a messy data clean-up later. This script was designed to solve that. It brings intelligence into the migration process by checking for duplicates first, then deciding whether to move or...
Post a Comment
Read more
Recent posts

SharePoint Spaces is Being Deprecated – What to Do Next

SharePoint Spaces is Being Deprecated – What to Do Next Microsoft has officially announced that SharePoint Spaces will be deprecated starting in March 2025 , with full support ending by August 2025 . If you're currently using Spaces or were planning to explore it, it's a good time to consider your alternatives. What is Happening? SharePoint Spaces was a tool for creating immersive 3D environments inside SharePoint—great for things like virtual tours or rich visual storytelling. But now, Microsoft is shifting its focus to Microsoft Mesh , a more advanced platform designed for mixed reality collaboration. Mesh vs. SharePoint Spaces vs. SharePoint Pages Here’s a basic comparison to understand where things stand: Feature Microsoft Mesh SharePoint Spaces SharePoint Pages Create immersive 3D spaces Yes Yes No Host...
Post a Comment
Read more

OneDrive Sharing Report: A Comprehensive Guide

OneDrive Sharing Report Managing and monitoring the sharing permissions of files stored in OneDrive can be a critical task for organizations. This guide provides a step-by-step walkthrough of how to create an Azure AD application with specific permissions, generate a client secret, and use a PowerShell script to retrieve and report the sharing permissions of OneDrive files. By following these steps, you will be able to audit and control file sharing across your organization, ensuring security and compliance. Step 1: Creating an Azure AD Application To get started, you'll need to create an Azure AD application that will allow you to interact with the Microsoft Graph API and retrieve information about users' OneDrive files and sharing settings. Specifically, you need to set the following permissions: Directory.Read.All Directory.ReadWrite.All Files.Read.All ...
Post a Comment
Read more

Automate SharePoint Site Creation with PowerShell and PnP

Creating new SharePoint sites while maintaining a consistent look and feel can be challenging. Fortunately, with PowerShell and the PnP (Patterns and Practices) framework, we can automate the process of backing up a site template and applying it to a new site. This blog post will guide you through the necessary steps. Prerequisites Before you begin, ensure you have the following: SharePoint Online Management Shell PnP PowerShell module installed Appropriate permissions to access the SharePoint site and admin center Step-by-Step Guide 1. Backup the Site Template First, you need to connect to the source site and back up its template. # Source Site URL input $SourceSiteURL = Read-Host "Enter Source Site URL" # Path to XML file $SchmaXMLPath = " " # Connect to PnP Online to take template backup Connect-PnPOnline -Url $SourceSiteURL -Interactive # Get Site Schema and save to file Get-P...
Post a Comment
Read more

Identifying Stream Web Parts in SharePoint Pages

Microsoft recently announced that they are discontinuing the classic Stream and introducing a new version. This change necessitates the identification of Stream web parts across SharePoint pages within your organization. To help with this transition, you can use a PowerShell script to scan your SharePoint sites for any Stream web parts that may be in use. Below is a detailed explanation of how to achieve this using PowerShell and the PnP PowerShell module. Script Overview The script provided here connects to your SharePoint Online sites, iterates through all site pages, and checks for the presence of Stream web parts. It compiles a list of these pages and exports the information to a CSV file. Key Components of the Script 1. Parameters and Global Collection Initialization $PagesDataCollGlobal = @() 2. Function Definition: CheckWebParts This function connects to a given site, retrieves all site pages, and checks each page for Stream web ...
Post a Comment
Read more

Generate List of SharePoint Pages and Owners Using Power Shell

Managing a large SharePoint site with thousands of pages can be daunting, especially when you need to get a detailed list of pages along with their respective owners. Automating this process with a script can save a significant amount of time and effort. In this blog, I'll walk you through a PowerShell script that does just that—fetches the list of pages and their owners, and exports the data to an Excel file for easy management. Prerequisites Before diving into the script, ensure you have the following: PnP PowerShell Module : Install this module if you haven't already. You can do so by running: Install-Module -Name "PnP.PowerShell" Permissions : Ensure you have the necessary permissions to access the SharePoint site and its subsites. The PowerShell Script Below is the PowerShell script that retrieves the pages from the SharePoint site and it...
Post a Comment
Read more

Copying Footers Between SharePoint Sites Using PnP PowerShell

Recently, I have been extensively working with SharePoint and the Patterns and Practices (PnP) PowerShell module. PnP has significantly simplified various tasks by providing easy-to-use command sets and thorough documentation. One particular task that PnP has made straightforward is copying a footer from one SharePoint site to another. This process can be achieved with just a few commands. Why Use PnP PowerShell? PnP PowerShell is a set of cmdlets designed to work with SharePoint Online and SharePoint on-premises. It simplifies the management and automation of common tasks and provides commands for nearly every aspect of SharePoint administration. The PnP module is especially useful for tasks that would otherwise require complex scripting or manual intervention. Copying a Footer with PnP PowerShell To copy a footer from one SharePoint site to another, follow these steps. This process involves exporting the footer template from the source site in XML format and...
Post a Comment
Read more