SharePoint Workflow to Power Automate Migration Tool

Current Situation & challenges facing by the clients

SharePoint 2010 workflow’s have already been retired & turned off for SharePoint Online tenants & even creation of new SharePoint 2013 designer workflow’s have also been blocked on new SharePoint Online tenants. Moreover Microsoft has already removed the ability to run or create SharePoint 2010 workflows from both new & existing tenants Therefore the biggest challenge that customers across geographic locations are facing currently that there are huge number of SharePoint Online tenants who are running millions of SharePoint Workflows & moreover as clients are heavily depend on those SharePoint workflow’s for their business operation & continuation , they have no other choice left but to migrate all those SharePoint workflows to Power Automate immediately. 

Unfortunately as at this moment there is no automated SharePoint workflow migration tool available in the global market which can migrate both SharePoint designer workflows as well as OOTB built-in SharePoint workflows to Power Automate & even there is no direct path for quick replacement as well, Therefore clients do not have any other option left apart from migrating their workflow’s manually to Power Automate which is not only very challenging (because of features differences) & time consuming but also involve a lot of effort & cost. 

Availability of any 3rd party SharePoint workflow migration  tool

As stated unfortunately as at this moment there is no automated SharePoint workflow migration tool available in the global market which can migrate both SharePoint designer workflows as well as OOTB built-in SharePoint workflows to Power Automate.

Way forward – Quick Introduction of SharePoint Workflow to Power Automate Migration tool (SP2PA)

It gives me immense pleasure to inform you all that we have successfully launched the 1st release of SharePoint Workflow to Power Automate Migration tool (SP2PA) which is going to be a definite game changer. This tool would give clients the desired flexibility as it has the in-built capability to automatically migrate both SharePoint designer workflows as well as OOTB built-in SharePoint workflows to Power Automate & therefore can save a significant effort , cost & time. This tool would also enhance migration accuracy & therefore can certainly be a real value proposition to the client in terms of both effort , cost & time.

How the tool would work

This tool would automatically connect & loop through all the SharePoint designer workflows in order to retrieve all the triggers, actions as well as conditions , associated with the workflows & ultimately would intelligently chose the right Power Automate actions to transform them. Currently we do not have apple to apple mappings between every SharePoint designer workflow action & corresponding Power Automate action. Therefore this tool would do the mapping & transformation indigenously to create the exact workflow structure in power automate. Also it would be an interactive experience for the users as they would be able to see a detailed progress status of the running migration job. Even on successful execution of the migration job, a comprehensive report / dashboard would get generated, reflecting the number of successful & failed migrations along with appropriate error messages.

This tool would even support bulk creation of workflows in Power Automate. For example, if there is a requirement to create 100 approval workflows (say) against 100 different list / library, the tool would create a generic workflow template & accordingly would ask the user to key in the count (100 in our example). Ultimately based on user input, the tool would automatedly create the desired number of approval workflows at one go. Once the workflows are created in Power Automate portal, few minor manual adjustments could be needed to ultimately get them running.

Guest article written by: Raja Mukherjee. Lead Enterprise Solution Architect – Microsoft Cloud Practice (SharePoint, Office 365 & Azure) @ IBM, Center Of Excellence (CoE) Lead – Microsoft Cloud Practice (SharePoint , Office 365 & Azure)
Center Of Excellence (CoE) Lead – Power Platform. Mobile: +91 9830624429 / 7044054971, Email: [email protected]