SharePoint and Power Platform related Stuff

When working with SharePoint, you might find yourself in situations where you need to create a duplicate of an existing list. This could be for backup purposes, testing, or simply as a template for new content. Fortunately, using PnP PowerShell , you can automate this process in just a few easy steps. In this blog post, I'll walk you through how to create a duplicate of a SharePoint list, including its structure and items, using a simple PowerShell script with PnP PowerShell commands. What is PnP PowerShell? PnP PowerShell is a powerful library of cmdlets that helps you interact with SharePoint and Office 365. It allows you to manage SharePoint Online or SharePoint Server environments from the command line, automating common tasks and simplifying your SharePoint administration. Prerequisites: Before we dive into the script, make sure you have the following: PnP PowerShell module installed . If you haven't installed it yet, you can do so by running this command: Install-Module -...

In this post, we will walk through a PowerShell script that automates updating SharePoint list items using PnP PowerShell commands, including reading data from an Excel file to add new items to a secondary SharePoint list. This is useful for syncing or updating information across SharePoint lists, saving time and reducing manual effort. Prerequisites Before diving into the script, ensure you have the following: PnP PowerShell Module : You can install this via PowerShell by running Install-Module -Name "PnP.PowerShell" -Force -AllowClobber . Access to SharePoint Online Site : Ensure you have the necessary permissions to read and update SharePoint lists. Excel File : An Excel file with the data you want to import into the SharePoint list. The script uses the Import-Excel command, which requires the ImportExcel PowerShell module. You can install it using Install-Module -Name ImportExcel . Script Overview This script connects to a SharePoint Online site, retrieves items from a ...

To Automate Delete Approval history we need to delete the records data from Approval History Data verse table. To Delete Approvals History there are 2 approaches 1.     1. Using Data verse Actions in Power automate which is premium connector. 1.     2. Using HTTP Action in Flow which is also a premium connector. Using Data Verse Connector Step 1:  Step 2: