Have you ever tried moving canvas apps or cloud flows across Microsoft 365 tenants or sites? This is a common task when deploying apps and flows to production. Apps and flows must be exported, and imported, and SharePoint actions must be manually updated. These manual updates are error-prone and labor-intensive. Flow & Power Apps Migrator automatically converts exported flows and apps to be compatible with the target environment.
Flow & Power Apps Migrator also helps you migrate SharePoint lists that are used as a dependency for your Apps and Flows. There is an interactive UI form that lets you do just that.
Finally, the Flow & Power Apps Migrator converts SharePoint List Forms customized with Power Apps.
- PowerShell 5.0 or later.
- Make sure that the SharePoint site exists in the target environment. You don't have to create Lists and Libraries because this tool will do it for you.
- Download the latest version of the Flow & Power Apps Migrator.
- Extract the ZIP package.
- Open a regular Windows PowerShell command prompt.
- Navigate to the extracted folder.
- Unblock the script files using the following command:
Get-ChildItem -Recurse | Unblock-File
| Artifact | Support |
|---|---|
| Standalone Canvas Power Apps | ✔ |
| Customized SharePoint List Forms Canvas apps | ✔ This works again since September 2022 |
| Canvas Power Apps that trigger Flows | ✔ (flows are also migrated) |
| Standalone Cloud Flows | ✔ |
| Standalone Desktop Flows | ❌ |
| Standalone Model-driven apps | N/A (not tested) |
| Solutions containing multiple canvas apps and flows | ✔ |
| SharePoint Connectors | ✔ |
| Non-SharePoint Connectors such as Word for Business | ❌ |
| SharePoint Lists | ✔ |
| SharePoint Libraries | ✔ |
| Cross-Language Lists migration | ❌ Both source and target sites must be created with the same language. Otherwise, you'll get the 0x80070005 (E_ACCESSDENIED) error |
| JSON List customizations | ✔ |
| JSON Column formatting | ❌ |
| SharePoint data | ❌ |
| Content Types | ✔ (migrated automatically) |
| Lookup fields | |
| Data Sources located in a single site | ✔ |
| Data Sources located in multiple sites and sub-sites | ❌ |
Export all of your flows:
Export all of your apps:
The scripts will iterate through all ZIP files inside the \src directory and convert them to be compatible with the new Microsoft 365 tenant or site.
- Run
Migrate-Packages.batscript
- Enter source site URL and target site URL:
- Keep
MIGRATE_LISTSproperty set toTrueif you want to migrate SharePoint lists and libraries.
- Select lists and libraries to migrate
- Sit back and wait for the lists and libraries to be migrated and the conversion process to finish.
Now you can import your flows and apps to the destination tenant. All SharePoint actions will now be converted and point to the new location.
Flow & Power Apps Migrator finds all unique IDs pointing to the source SharePoint site and replaces them with the destination IDs. resourceMapping.csv contains the mapping of these IDs.
- Does not support macOS and Linux.
- Only SharePoint data sources are updated.
- ZIP packages might not be converted if placed in a long path name on disk. For this reason, try placing the migrator as close to the root drive as possible.
What if you created an app or flow you want your Client or Partner to have? You can package your SharePoint Lists and the apps and flows in a single package. Then you would like to hand over this package and simple installation instructions. Guess what? There is a script that prepares this package automatically for you.
Prepare-Deployment-Package-for-Client.bat script prepares a deployment package you can share with your Clients or Partners.
- Run
Prepare-Deployment-Package-for-Client.bat
- Export your Solutions, Power Apps and Flows and save them to the
package\srcdirectory
- Send the
packagedirectory to your Client or Partner.
- If it does not already exists, create a SharePoint Online site. It will contain SharePoint Lists and Libraries that Power Apps/Flows require.
- Open the
packagedirectory. - Run
Convert-Packages.batscript. - Provide target site URL.
- Import all solutions, flows and apps from the
distdirectory.
Note: Convert-Packages.bat will:
- Deploy SharePoint lists and libraries (if you want to package them)
- Convert Apps and Flows from
srcand saves them to 'dist'.
SharePoint List forms customized with Power Apps can be migrated if you follow these steps:
-
Navigate to your SharePoint List
-
Click on one of the SharePoint list items
-
Click on the ellipsis (3 dots) > Customize with Power Apps:
-
Power apps Editor will open.
-
Click on File > See all versions
-
Click Export package:
-
Type your app name
-
Select "Create as new" under Import setup
-
Click Export
- Place the exported package in the
\srcdirectory - Run
Migrate-Packages.batscript
- Removed migration of the column formatting JSON. This was causing the issues with the migrated lists.
- Removing the migration of several out-of-the-box content types.
- Added additional tips to the users who are getting the
0x80070005 (E_ACCESSDENIED)error.
- Addressed issue #66 You cannot call a method on a null-valued expression
- Addressed issue #66 You cannot call a method on a null-valued expression
- Removed the REST API call that was causing 403 error for some users.
- The pnp:SiteFields node is now automatically removed from the Lists.xml PnP provisioning template if it's empty. An empty node was causing the "invalid template" errors.
- Removing more fields causing the infamous
0x80070005 (E_ACCESSDENIED)error. - Trimming trailing slashes in the site URLs
- Migrated lists with custom content types end up with an extra content type that should be deleted manually after migration.
- Migrated lists might need fields added to the content type or a form. In some cases, migrated lists show only the Title in the edit form.
- Removing Site fields causing the infamous
0x80070005 (E_ACCESSDENIED)error.
- Migrated lists with custom content types end up with an extra content type that should be deleted manually after migration.
- Migrated lists might need fields added to the content type or a form. In some cases, migrated lists show only the Title in the edit form.
- fixed a bug reported by spg-iwilson
- If the source and the target sites were created using different languages, then the app migrator will fail with the Access is denied (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) error.
- Migrated lists with custom content types end up with an extra content type that should be deleted manually after migration.
- Migrated lists might need fields added to the content type or a form. In some cases, migrated lists show only the Title in the edit form.
- Added an ability to run migrations using SharePoint-only App ID and App Secret. Use the
config\migrator-config.jsonfile to do it:
{
"source-site-url": "",
"target-site-url": "",
"source-site-app-id":"",
"source-site-app-secret":"",
"target-site-app-id":"",
"target-site-app-secret":""
}
- If the source and the target sites were created using different languages, then the app migrator will fail with the Access is denied (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) error.
- Migrated lists with custom content types end up with an extra content type that should be deleted manually after migration.
- Migrated lists might need fields added to the content type or a form. In some cases, migrated lists show only the Title in the edit form.
- Fixed the issue related to the Trace log causing the migratory to fail.
- Users connected to the source and target sites are now displayed in the console for easier troubleshooting.
- Fixed the issue caused by lists having multiple personal views.
- Added a check for the
E_ACCESSDENIEDerror.
- If the source and the target sites were created using different languages, then the app migrator will fail with the Access is denied (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) error.
- Migrated lists with custom content types end up with an extra content type that should be deleted manually, after migration.
- Migrated lists might need fields to be added to the content type or a form. In some cases, migrated lists show only Title in the edit form.
- Added a check of the source and target site permissions. If the user does not have the required permissions, the app migrator will stop and display an error message.
- Occasional error: Access is denied (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)). This error typically has nothing to do with permissions. It is hard to diagnose, but one of the fixes is to delete a target site and rerun the app migrator.
- Migrated lists with custom content types end up with extra content types that should be deleted manually, after migration.
- Migrated lists might need fields to be added to the content type or a form.
- Fixed an issue with lists not being migrated
- Migrated lists with custom content types end up with extra content types that should be deleted manually.
- Migrated lists might need fields to be added to the content type or a form.
- Added ability to Clear Credentials cache (helpful when your credentials pop-up opens and closes automatically, without prompting you to enter your credentials)
- Fixed an issue with migrating between non-English SharePoint sites.
- Migrated lists with custom content types end up with extra content types that should be deleted manually.
- Migrated lists might need fields to be added to the content type or a form.
- SharePoint list forms customized with Power Apps are now migrated by this tool. Credits to kvadratnymedved and amariak for providing a solution. 🙏
- Migrated lists with custom content types end up with extra content types that should be deleted manually.
- Migrated lists might need fields to be added to the content type or a form.
- Flow & Apps Migrator might cache your user credentials and not prompt you for them again. In this case, you will need to follow the steps described in this issue
- Added an ability to migrate flows that refer to the List and Library views. This was done to address the issue List Views not Migrated submitted by Juistin
- SharePoint list forms customized with Power Apps are no longer migrated by this tool. There is an issue I am still working on.
- Added an ability to migrate content types and columns. These will be automatically migrated if your lists have any custom content types.
- SharePoint list forms customized with Power Apps are no longer migrated by this tool. There is an issue I am still working on.
- Fixed a major bug preventing export-importing for the lists and libraries.
- Made console output more clear.
- Fixed a bug that corrupted solution zip files during the conversion process. It made it impossible to import solutions.
New features added:
Migrate-Packages.batscript now migrates SharePoint lists and libraries that your Apps and Flow depend on.- Added
Prepare-Deployment-Package-for-Client.batscript to prepare a deployment package to share with your Clients or Partners. Running this script will generate a package directory you can send to your Clients and Partners. Distribution of your apps and flows is now easier than ever.
New feature added:
- added support for solution migration. Thanks to Mark Doria for helping with this feature.
I like coffee and consume lots of it while coding. If you want to support me, you can click on the "buy me a coffee" button:
