Skip Ribbon Commands
Skip to main content

Quick Launch

Todd Klindt's home page > Todd Klindt's Office 365 Admin Blog > Posts > Use PowerShell to Work with SharePoint 2010 Workflow Scan
July 29
Use PowerShell to Work with SharePoint 2010 Workflow Scan

Workflow Retirement Series TOC

Part 1 - SharePoint 2010 and 2013 Workflows Kaput in Office 365
Part 2 - Finding All the SharePoint 2010 Workflows in SharePoint Online
Part 3 - Find Only the Active SharePoint 2010 Workflows in SharePoint Online 
Part 4 - Use PowerShell to Work with SharePoint 2010 Workflow Scan

In Part 2 of my much beloved “Workflow Retirement Series” I covered how to scan your SharePoint Online environment for those pesky SharePoint 2010 workflows with the free SharePoint Modernization Scanner. I figured that was that. I was preparing to do my victory lap when I started getting some feedback. It seems some folks have a a lot of workflows in their environment, and a CSV file with a few hundred, or a few thousand rows isn’t terribly helpful. Now, once you get that CSV file into Excel you have one of the best data slicing and dicing tools invented by man at your disposal. You can slap a couple of filters on there, sort a few columns, hide a few others, and you can probably get whatever information you need. But I’m a PowerShell guy. I like to do things the hard way, with maximum typing. Let’s walk through what I did.

One of the reports the SharePoint Modernization Scanner makes is

ModernizationWorkflowScanResults.csv  and that’s the one I’m going to use. Since it’s a pretty well formed CSV file we can import it into an object without much fuss:

$results = Import-Csv .\ModernizationWorkflowScanResults.csv

As a gut check we can see how many rows we brought in:


You can also type $results[0] to see the first row, since it’s just an object. And since it’s an object, it has Members that we can exploit. What are those Members? I’m glad you asked:

$results | Get-Member


My eagle-eyed readers will notice that the NoteProperties are the column headers in the CSV file. To get my feet below me I did a simple Select to get a few properties:

$results | select "Definition Name",Version

You can add any of the columns you want. Remember to put quotes around the columns with spaces in the name.

$results | select "Definition Name","Subscription Name","List Title",Version,enabled

Depending on how your PowerShell host is configured that might be wide enough that might switch from table to list. To get it back to table pipe it through Format-Table:

$results | Select-Object "Definition Name","Subscription Name","List Title",Version,enabled,"Flow upgradability" | Format-Table –AutoSize


This report has both SharePoint 2010 and SharePoint 2013 workflows in it. The current fire is around SharePoint 2010 workflows, so let’s just look at those:

$results | Where-Object -Property version -EQ -Value "2010" | Select-Object "Definition Name","Subscription Name","List Title",Version,enabled,"Flow upgradability" | Format-Table -AutoSize

That should give you a better picture of the Herculean task in front of you. There’s one final piece I want to show you, and that’s how to see which sites have the most workflows:

$results | Where-Object -Property version -EQ -Value "2010" | Select-Object "Definition Name","List Title",enabled,"Site Url" | Group-Object -Property "Site Url" | Format-Table –AutoSize


This will help you figure out where to focus your efforts between now and November 1st.

Like I said at the beginning of this post, all of this and more is available in Excel and most of it has been done for you already in the Office 365 Classic workflow inventory.xlsx report that the SharePoint Modernization Scanner creates. But it’s a fun PowerShell exercise just the same.




Great Blog!

I do see multiple workflows in a single workflow history list. Using PnP, How can i filter based on the "Date Occurred" and export it to excel? Thank you in advance.
 on 9/14/2020 10:16 AM

Re: Use PowerShell to Work with SharePoint 2010 Workflow Scan

A beats might be fantastic. You possess numerous especially capable actors. I just aspire most people the right from victory.weight loss personal trainer in winter park
 on 10/30/2023 7:59 AM


Amazing! Exactly what a watch opener this particular publish may be personally. Greatly valued, saved, We can’t await much more! kitchen renovation
 on 11/12/2023 7:17 AM

Re: Use PowerShell to Work with SharePoint 2010 Workflow Scan

"Unleash affordability with Camile TM's industry-leading prices! Same-day success, the highest win rate, rapid service, deluxe treatment, and unwavering secrecy await you. Dive into role-playing excellence with Camile Team!" 롤듀오
 on 12/13/2023 6:38 AM


Great post. The particular submit has an effect on plenty of important difficulties individuals community. We all can't be uninvolved to be able to these kinds of difficulties. This kind of submit offers guidelines and also principles. Extremely useful and also $10 play for riversweeps
 on 12/28/2023 9:39 AM

funny thongs for bride

This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free.
 on 2/6/2024 4:46 AM

my dissertation

Navigating the complexities of academic research can be daunting, especially when it comes to write my dissertation. It's reassuring to know that there are experts out there who specialize in various disciplines, ready to offer guidance and support. From crafting captivating introductions to conducting meticulous research, their assistance can turn this daunting task into a manageable endeavor.
 on 2/9/2024 11:20 AM


Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me.Berechtigung für ein Kanada Visum zypriotische Bürgerür-ein-Kanada-Visum/zypriotische-Bürger/
 on 2/10/2024 7:42 AM


you need to connect to the SharePoint site where the workflows are located. You can do this using the Connect-SPOService cmdlet in SharePoint Online or by loading the SharePoint PowerShell snap-in for on-premises SharePoint environments.
 on 4/25/2024 11:09 PM


I like the way Todd explains each step and provides specific examples to illustrate. Using PowerShell to work with data can be a good choice for people who like to automate their work and prefer more flexible control than using Excel.
 on 5/9/2024 2:46 AM
1 - 10Next

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.


Body *

Today's date *

Select a date from the calendar.
Please enter today's date so I know you are a real person


Want a message when I reply to your comment? Put your Twitter handle here.