We now know that the rumours are true: Microsoft has announced the deprecation of SharePoint 2013 workflows. It’s been a long-time coming, and it’s why so many organisations have already begun to replace SharePoint workflows with Power Automate flows.
That’s where we come in. As Microsoft 365 experts, we knew there was a way to make this transition easier. So to help you through the process, we’ve created this comprehensive guide on how to replace SharePoint workflows with Power Automate flows.
But before we show you the how, let’s dive into the what – what is Power Automate, and how will it replace your existing SharePoint workflows?
There’s a reason why there’s been such an organic transition to flows in Power Automate. It’s an intuitive platform that comes with a myriad of benefits.
As with any system, there are some limitations:
We’re used to all the actions being SharePoint-focused, with everything we create based on SharePoint lists, libraries, and sites. Power Automate, on the other hand, not only connects to SharePoint but also Outlook, Teams, and Twitter – among others.
What this means for your conversion to Power Automate is that some actions you want may not be listed with the SharePoint actions. For example, if your SharePoint designer workflow has the action ADD TIME TO DATE you would look under DateTime for the action GET FUTURE TIME. Luckily there are some common connector groups which will help in your migration from SharePoint classic workflow to modern Power Automate:
It’s a good time to review your workflows and see if Power Automate might offer you a new way to achieve your goals. The transition from SharePoint 2010 workflows to Power Automate can be fairly seamless. There’s no need to be scared of replacing SharePoint workflows. As leading solutions experts, we’ve built a conversion table to help you find the equivalent SharePoint action in Power Automate.
Here’s an action comparison between SharePoint Workflow and Power Automate:
SharePoint workflow action | Power Automate action |
Create list item | Create item |
Delete item | Delete item |
Set field in current item | Update item |
Update list item | Update item |
Wait for event in list item | Do Until (Control) |
Wait for Field change in current item | Do until (Control) |
Check in item | Check in file |
Check out item | Check out file |
Copy document | Copy file Copy folder |
Discard check out item | Discard check out |
Translate document | Translator |
Add a comment | Flow actions can have comments added to them |
Set workflow status | PA does not have a workflow status, but could still update a column with the Flow status |
Set workflow variable | PA has a collection of actions to do with variables: · Initialise a variable · Append to string · Append to array · Set variable · Increment variable · Decrement variable There is also a collection of build-in actions for data operations (e.g. create csv table, create HTML table, select, parse JSON etc.) |
Log to history list | PA does not keep a workflow history list. Instead, it can log out to a list on the site to help track the actions of the Flow.
You can also review Flow history and trace which actions the Flow ran and whether they were successful or not. This is deleted after 30 days |
Go to a stage | Stages are not present in PA, instead the same behaviour can be achieved with a Switch statement inside a Do Until action |
Pause for duration | Delay |
Pause until date | Delay until |
Add time to date | Get future time |
Set time portion of date/time field | Get future time |
Find interval between two dates | Set a variable with an expression |
Do calculation | There are a collection of expressions for calculations which can be used with the Set Variable action (add, subtract, divide – even a randomizer!) |
Trim string | There is a trim expression which can be used with the Set Variable action |
Replace substring in string | There is a replace expression which can be used with the Set Variable action |
Find Substring in String Extract Substring from End of String Extract Substring from Index of String Extract Substring from Start of String Extract Substring of String from index with Length | All string manipulations can be done with expressions in the set variable action |
Build dictionary Count items in a dictionary Get an item from a dictionary | PA has replaced dictionaries with arrays. These can be manipulated with the data operations actions Compose Create CSV table Create HTML Table Filter array Join Parse JSON Select There also expressions which can be used with these actions to provide the functionality (and more) of SharePoint Designer workflows |
Start a task Process Assign a task
| Customisable approvals can be created using the Approval connector
Alternatively, tasks can be created in a task list using the Create Item action |
Send an email | Office 365 outlook ‘Send an email’ action The outlook email allows the Flow creator to determine the mailbox the email is sent from |
Call HTTP Web service | Send an HTTP request to SharePoint can handle any HTTP web services call to the SharePoint environment (without messing around with authentication headers!)
For all other API calls, the HTTP actions are required which are part of the premium plan |
If Statements If/Else | Condition (under the Control connector) If/Else is not present, but the same functionality can be achieved with the control actions. |
These are Power Automate actions which are not available in SharePoint Designer:
What it’s called | What it does |
Add attachment | Add an attachment to a list item |
Create new document set | Creates a document set (folder with properties) within a library |
Create folder | Creates a folder in a document library |
Create sharing link for a file or folder | Creates a link that can be used to share a file or folder |
Set content approval status | Sets the status of a document in a library as it moves through the approval process |
Get attachments | Get a list of the content of all attachments for a list item |
Get changes for an item or file (properties only) | If versioning is turned on, this will return information about columns that have changed within a given timeframe |
Grand access to an item or folder | Grant access to an item or a folder in SharePoint to specific people |
Get files (properties only) | Creates an array of the properties for all or a selection of files in a SharePoint library |
Get Items | Creates an array of the items in a list |
List folder | Returns the files in a specified SharePoint folder |
Move file | Moves a file from one document library to another, even across sites or site collections |
Move folder | Moves a folder from one document library to another, even across sites or site collections |
Resolve person | Using a name or email, this searches for a matching user for use in a person column |
Send an HTTP request to SharePoint | Sends an API call to SharePoint – no messing around with building dictionaries! |
Set hub site join status to pending | Set the requested site’s hub join request status to pending |
Stop sharing an item or file | Deletes all sharing links associated with a list item or file |
Delete attachment | Deletes a specific attachment from a list item |
Extract folder | Extracts an archive (e.g. .zip file) to a SharePoint folder |
Get all lists and libraries | Creates an array of the lists and libraries for a site |
Get attachment content | Extracts the content of an attachment from a list item |
Get file content | Returns the content of a file from a SharePoint library |
Get file metadata | Gets information about the file (size, created date, modified date etc.) |
Get folder metadata | Gets information about the folder (size, created date, modified date etc.) |
Get list views | Returns an array of the views on a particular list |
Get lists | Creates an array of the lists for a site |
List root folder | Returns information on the files in the root SharePoint folder |
Update file properties using AI builder model results | Updates the values stored in library columns for a file analysed by a specified model |
Approve hub site join request | Sets the hubs approval request to approved |
Generate document using Microsoft Syntax (preview) | Create documents based on modern templates from Microsoft Syntex. This preview requires a Syntex license. |
Extract folder | Extracts an archive file into a SharePoint folder |
Cancel hub site join request | If a hub join request was submitted incorrectly, this cancels the request |
Join hub site | With an approval token, this action adds a site to a hub site |
Set hub site join status to pending | Updates a hub request status to ‘Pending’ |
Now that we know for certain that 2013 workflows are being phased out, it’s time to start planning your transition.
It’s easy to see how Power Automate and other flow connections can meet your business needs. Have a look at your SharePoint Workflows and see if there are spots where Power Automate can slot in or identify points that can be streamlined as part of the conversion.
Want some expert advice on transitioning from SharePoint flows to Power Automate? Chat to Propelle today.