SharePoint Workflow instances for a list item using PnP and PowerShell Scripts

Overview

During migration of the SharePoint sites, checking for running instances of workflow is very important for business users. This helps loss of data, data consistency and smooth migration. Communication such issues to respective are one of the key factors for a successful migration.

Problem Statement

By default, instances of the workflow instances can’t be migrated to the new SharePoint environment. It becomes really hard to find such instances going to each individual list.

PowerShell Scripts

Following scripts, provide an easy way to find the running instances of the workflow in a given list. It checks for running instances first which provides GUID of the workflow. Then compares with workflow subscription to get the workflow names. Later, it iterates through the site users to find out site owners, to whom we can contact to highlight the same.

The script requires, list name and site URLs as the basic parameters to run. It also requires a user email to whom the report should be sent along with the sender’s email address and password.

This script works for SharePoint 2013 workflows, as PnP doesn’t support SharePoint 2010 workflows

GitHub Link

Please your own parameters to run the scripts

1.      $ListTitle – List name

2.      $SiteURL – Site url

3.      $toemailaddress – Email address to which email be sent

4.      $ fromemailaccount – Sender’s email address

5.      $Password – Sender’s email password

Note: The above function has been developed on PowerShell V 5.1.18362.145 and PnP 3.15.1911.0. You need to PnP cmdlets installed to run this scripts