Export and Import SharePoint List Custom Forms App across tenants

PowerApps Overview

PowerApps is part of Microsoft’s Power Platform technologies offerings which include MS Flow and PowerBI (desktop and web). It comes up a lot of user-friendly features, which helps even to non-developer to build powerful forms for different layout with various data sources.

It is also built to customize SharePoint list forms(linked directly from the list) So that Site user who has access on the list can edit the list forms according to their requirements. If you customize the form for a list and want to replicate into another list/Site, PowerApps doesn’t provide such a feature. Also, this is a business problem when you move to a different tenant or within the same tenant.

Problem statement

One of the common issue Developer faces is how to move Customized Power from one site to another / one tenant to another

While PowerApps give the option to export app the package, but one needs to follow some steps to make it work in a new site/tenant. The following guide gives a brief idea of how to solve the problem of using custom forms across Sites/Tenants for any user.

Customize SharePoint List Forms using PowerApps and migrating to different site / tenant

Steps to create customize of SharePoint list forms as an app in PowerApps and importing as a package in another tenant.

1.     Go to your SharePoint site, create a list (if not yet created it), customize forms through the PowerApps (ex: change font color or background color)

2.     Save and Publish the app

3.     Then, export this as a package.

4.     Provide the name for the package with the description

5.     While exporting, please make sure that Import Setup should be as Create as New and save it.

6.     Now, click on the Export button. This will start downloading of a zip file.

7.     The exported zip package contains Microsoft.PowerApps folder and manifest JSON file. You have to navigate to Microsoft.PowerApps\apps\[numeric values] (refer to below screenshots). Inside this folder hierarchy, navigate to Microsoft.PowerApps\apps\[numeric values]. There will be only one JSON file, which needs to be edited.

Note: Before you perform the below steps, please navigate to the site where you want to copy/move this app(irrespective of the tenant). If you haven’t created the list, please create a similar list as you already created in the source site.

Once the list is ready, please get the List ID by navigating to Site Contents. In the Site Contents,

Select the list and click on the dots against the list name, go to Settings.

            In the browser URL, note down your list ID

           

           

8.      Open the JSON file in JSON editor app, now replace following sections

a.     In the embedded App, replace SiteID with target site URL, ListID with target listId and listUrl with target listUrl (here target refers to list where you want to copy the app)

b.     In dataSources, change it target list name (internal name)

c.     The tablename should be target listId(GUID)

d.     In the dataSets, change it to target site URL