Top
PowerApps

Importing PowerApps package as a SharePoint list form


The functionality in PowerApps allowing to export an application and then import it in a different environment or to migrate it this way to your customer’s tenant is known. However this works like a charm when talking about standalone apps. Is it possible to import a list form made in PowerApps as well? Yes! Maybe not very straightforward, but yes.

Screencast

Before you start reading – watch this screencast. Hopefully it will help you to find answers to all your questions 🙂

Exporting an app

First you need to export your existing PowerApp list form. This is done the same as for the standalone app. Simply open your app in the designer, then in “Save” menu click “See all versions”:

Navigating to the "Export package" functionality
Navigating to the “Export package” functionality

Then in the opened page click “Export package” link:

Exporting PowerApps app as a package
Exporting PowerApps app as a package

Then, depending on your scenario, set name of the package, mark whether the app should be imported as a new one, or to update existing one. For the purposes of this post I selected “Create as new”.

Adjusting exported app configuration

If you try to import the app right away, you face errors – app fails to import, showing e.g. the below errors:

Errors when trying to directly import PowerApps list form package
Errors when trying to directly import PowerApps list form package

And when you open the error’s details:

Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException
Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException

This is due to the fact, that inside the package file there are defined relationships and GUIDs to the lists and site from the source location.

To solve it, first you need to create all the required lists, preferably with the same titles and columns, as there were in the source environment.

Then open the exported app – this is a ZIP file, therefore even using Windows Explorer you should be able to get into its contents.

After opening the ZIP, navigate to the last folder you can find. It is the only folder in the “apps” subfolder, under the path:
Microsoft.PowerApps\apps\[numeric values]

Inside the folder look for the only JSON file. Open it using e.g. Visual Studio Code. The code inside basically defines the app configuration. What is important, is to make changes in the following sections.

In the connectionReferences section you will find all the connections defined and used by the application, e.g. Outlook, OneDrive and others and certainly, for this case – SharePoint. Now look for the dataSets section. It contains definitions of all lists that are being used by the application. Adjust their GUIDs to the values from you target environment:

            "connectionReferences": {
                "1dd34a9f-a232-48d7-b9b1-f3a149529511": {
                    "id": "49384936-6f18-4567-8283-411e553280d2",
                    "displayName": "SharePoint",
                    "iconUri": "https://connectoricons-prod.azureedge.net/sharepointonline/icon_1.0.1008.1183.png",
                    "dataSources": [
                        "LIST OF DATA SOURCES USED BY THE APP, e.g. SHAREPOINT LISTS’ TITLES"
                    ],
                    "dependencies": [],
                    "dependents": [],
                    "parameterHints": {},
                    "isOnPremiseConnection": false,
                    "bypassConsent": false,
                    "dataSets": {
                        "URL TO THE SITE": {
                            "dataSources": {
                                "LIST NAME": {
                                    "tableName": "LIST GUID"
                            }
                        }
                    },

Next scroll to embeddedApp section. It defines the location where the app should be deployed. Change siteId, listId and listUrl to values related to your target environment.

"embeddedApp": {
                "siteId": "SITE URL",
                "listId": "DESTINANTION LIST’S GUID",
                "listUrl": "DESTINATION LIST’S URL",
                "type": "SharepointFormApp",
                "screenWidth": 1185,
                "screenHeight": 790
            },

In the end save the file elsewhere and update the related file in the archive (app package). Once done, go to web.powerapps.com in your target environment.

Importing PowerApps package as a SharePoint list form

This process is also the same as when importing a package of a standalone app. Simply open the “Apps” page in PowerApps and then click the “Import package” link:

Importing PowerApps app package
Importing PowerApps app package

Then navigate to your saved ZIP file with the modified JSON file inside. After selecting it, importing mechanism asks whether to import app as new one, or to update. In my scenario there is no app to be updated, therefore I chose to import it as new. After couple of seconds your app is properly imported as a list’s form.

After doing that please remember to open your imported form in the designer, and check whether all data sources were properly re-linked and that all permissions are working fine. If you face any issues with accessing the lists, simply remove these data sources and add them again.

Remember publish your app at the end. Enjoy!


Tomasz Poszytek

Hi, I am Tomasz. I am expert in the field of process automation and business solutions' building using Power Platform. I am Microsoft MVP and Nintex vTE.

66 Comments
  • Pieter Temmerman

    Thanks! Didn’t know it was possible and I needed it ;).

    March 18, 2019 at 2:20 pm Reply
  • Deepthi

    Hello,
    I followed all the steps mentioned in this article, but at the end and it fails to import package.
    Error Message : “Something went wrong. Please try again”

    March 29, 2019 at 11:54 am Reply
    • Tomasz Poszytek

      Well.. I can’t say what went wrong. What you could do is to send me the package? Post a new message in https://powerusers.microsoft.com/t5/General-Discussion/bd-p/PowerAppsForum1, attach the file and mention me: TomaszPoszytek.

      March 29, 2019 at 12:04 pm Reply
      • Laks

        Hi
        I am also getting Error while importing the package “Something went wrong. Please try again”.
        Any idea?

        July 22, 2019 at 4:13 pm Reply
        • Tomasz Poszytek

          I don’t know what you’re doing with the package. Honestly speaking can’t say why you see the error.

          July 28, 2019 at 8:12 pm Reply
    • David Underwood

      When you’re zipping your folder back up be sure the zip file is created correctly. For example, if you right-click the folder your files are contained within and use 7zip to create a zip, it’ll nest a folder inside so the hierarchy won’t be right for the import. When you look at the contents of your zip file you should see manifest.json and a folder Microsoft.PowerApps.

      September 6, 2019 at 3:02 pm Reply
  • Chetan

    Excellent article, Tomasz!!! Saved a day for me.

    June 4, 2019 at 12:16 pm Reply
  • Swapnil Lad

    Hi Tomasz,

    Im following exact steps you have explained but still im getting the error “The sharePoint request failed with error: ‘{“error_description”:”Exception of type ‘Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException’ was thrown.”}’. The tracking Id is ‘f27f5d01-f7bc-42bb-881b-b8696c2118df'”.

    Can you please let me know if we need to do additional changes?

    Im trying to import package on another tenant.

    Thanks in advance.

    Regards,
    Swapnil Lad

    June 11, 2019 at 7:33 am Reply
    • Tomasz Poszytek

      That is the error that you see when you try to export a package and import to a new environment. Have you changed the GUIDs in JSON inside the file as described?

      June 11, 2019 at 12:18 pm Reply
  • Pavel Sheludkov

    Hi Tomasz,

    Brilliant article, thank you for sharing!
    Did you try to use the same approach when a targeting environment is within the same site collection?

    Regards,
    Pavel

    June 24, 2019 at 7:34 am Reply
    • Tomasz Poszytek

      Thank you for your kind words.
      Yes, I did two tests, one to migrate to a whole new tenant, the second one was a migration between lists in the same tenant.

      June 24, 2019 at 7:44 am Reply
  • Sathya

    hi I tried the above steps design got reflected in the target but the data and its rules were not populated in target

    July 4, 2019 at 8:03 am Reply
    • Tomasz Poszytek

      That is partly correct. Once you import app this way it will be imported, however you need to reattach all the data sources. Remove the existing ones and add them again. Then check the issues and fix them.

      July 4, 2019 at 9:47 am Reply
  • Nilesh Singh

    Hi Tomasz,

    I have a customized list on my Production site and i wanted that list to get created on my test site. My had exported the package and updated as per your suggestion but getting below error message.
    The sharePoint request failed with error: ‘{“odata.error”:{“code”:”-1, Microsoft.SharePoint.SPConnectorException”,”message”:{“lang”:”en-US”,”value”:”An App already exists for this list. Remove the existing App before adding a new one.”}}}’. The tracking Id is ‘29507748-34da-4227-8d3d-40a2161b847b’

    I wanted to customize my list (test site) to use powerapps form.

    Please suggest.

    September 6, 2019 at 8:47 am Reply
    • Tomasz Poszytek

      You need to go into your list’s settings, then to Form settings and delete the existing PowerApps form. Then try to import it again.
      The point is, it can’t overwrite it.

      September 6, 2019 at 8:54 am Reply
      • Nilesh Singh

        Thanks for you input, I able to import this but While click on New Item i can not able to see the my modified form.. Do i need to do update some properties.

        Please suggest.

        September 6, 2019 at 9:10 am Reply
        • Tomasz Poszytek

          So once you import the form you then have to publish it. The same way you do it with every other list form 🙂

          September 6, 2019 at 9:20 am Reply
          • Nilesh Singh

            Thank you for your response. I could able to publish the form on my list but getting one issue while saving the data it is saving on the production list.

            Could you please suggest what i missed…

            thanks

            September 6, 2019 at 10:13 am
    • Sayali

      It worked like a charm! Thank you so much!

      April 16, 2020 at 1:02 pm Reply
  • Nilesh Singh

    I am getting below message while selecting the custom form option.

    You have to publish your form from within PowerApps to make this option work.

    Please suggest.

    September 6, 2019 at 9:12 am Reply
  • David Underwood

    Thanks for this great article.

    Some additional items of note for folks following this article:

    After you import, go back to your list settings and then ‘Form Settings.’ Once there you’ll need to select ‘Use a custom form created in PowerApps’ and click OK. This won’t get your form working though, you still need to publish. To do this, click ‘Modify form in PowerApps’ and the form you imported will be opened in PowerApps. Make a quick edit (you can move a box to the right and back to the left for example to cause an edit to be picked up) and then Save. After saving, Publish. Be sure to hit CTRL+F5 on your SharePoint List and then click ‘New’ to see the new form.

    If you’re having trouble importing as new you may have a form already associated with the list. In this case you’ll need to delete it. Be sure you wish to delete it (you may want to open it first) and the go to the list settings, ‘Form Settings’ and choose ‘Use the default SharePoint Form’ and click ‘OK.’ After clicking ‘OK’ on the page refresh click ‘Delete custom form’ under the option provided to use a custom form. You should now be able to import with create new to attach the imported item to your list.

    September 6, 2019 at 3:07 pm Reply
    • Tomasz Poszytek

      Hey! Thank for your contribution and following information. I appreciate it.

      September 7, 2019 at 4:33 pm Reply
      • Nilesh Singh

        Hi,

        Its works for me. Only thing i am wondering even though i had make the changes in the data-source connection from the test site. It is still pointing to the source/Prod site collection.

        I had modify the form in power-app and deleted the existing connection and added my new connection (test site).

        I published the form and now its working as expected.

        thanks a lot for this nice article.

        September 9, 2019 at 9:37 am Reply
    • murali

      Its really helpful if you make a video.

      requesting to Tomasz and David kindly reply.
      I have a sharepoint list with simple date fields(4 fields+1 title), i have already did a powerapps form which i customized from list newItems.aspx.
      So this sample/Simple form i would like to move another site(both are SPO)

      Steps during Export what i did
      1. Opened List NewItems.aspx Form in powerapp
      2. From Apps-Exported (after published then i can see versions) downloaded package file in compressed format
      3. Opened JSOM File under(Microsoft.PowerApps\apps\[numeric values])
      First Time i just changed only below parameters
      “embeddedApp”: {
      “siteId”: “SITE URL”,//my taget site url
      “listId”: “DESTINANTION LIST’S GUID”, //copied from list settings page
      “listUrl”: “DESTINATION LIST’S URL”, //site/Lists/ListName/Allitems.aspx
      “type”: “SharepointFormApp”, //Not chanaged
      “screenWidth”: 1185, //No Change
      “screenHeight”: 790 //No change
      },
      Saved file, compressed and uploaded(means compressed file that contains all files how its downloaded)
      means Microsoft.PowerApps\apps\[numeric values]\.jsom+all other files
      ,I didn`t changed other than any thing
      during uploading package(Importing) getting error some thing went wrong.

      Second time just uploaded only compressed file .json excluding all files.
      But still same error some thing went wrong.

      kindly help here whats wrong here.

      Second time just changed

      October 16, 2019 at 3:43 pm Reply
      • Tomasz Poszytek

        I’ve recorded a screencast where I am trying to explain how to make that migration. Please see it. It’s in the beginning of the post. I hope it will answer all your questions.

        December 31, 2019 at 1:06 pm Reply
  • Quan

    Hi Tomasz.

    thank you for saving my day.

    it works for me, however when checking in powerapps i’ve receive 4 error messages.

    Could you please help me?
    Errors are
    1.Name isn’t correct…
    2.The function LookUp
    3.Invalid Argument type

    September 30, 2019 at 8:02 am Reply
    • Tomasz Poszytek

      To be honest I can’t resolve it this way. I didn’t face such errors. But possibly you could just check them and adjust to the new datasource? Maybe you have different internal names? Or some other small differences in the list, that causes those errors?

      October 1, 2019 at 9:13 am Reply
  • Dileep

    Hi Followed the steps and i am able to import the app. As suggested I deleted the existing form before import and when i try to modify or open the app i am getting “Error opening app”

    October 11, 2019 at 12:13 pm Reply
    • Tomasz Poszytek

      I’ve recorded a screencast where I am trying to explain how to make that migration. Please see it. It’s in the beginning of the post. I hope it will answer all your questions.

      December 31, 2019 at 1:06 pm Reply
  • Murali

    Its really helpful if you make a video.

    October 16, 2019 at 1:38 pm Reply
  • Vivek

    I have tried as you described the in this article, but I still get Something went wrong. Please try again later error.

    October 16, 2019 at 2:03 pm Reply
    • Tomasz Poszytek

      I’ve recorded a screencast where I am trying to explain how to make that migration. Please see it. It’s in the beginning of the post. I hope it will answer all your questions.

      December 31, 2019 at 1:06 pm Reply
  • Pixel

    everything almost worked.

    when changing the data source in powerapps to the new sharepoint data souce, it tells me “would you like to replace the data cards. this will replace all the cards on this form with new ones, based on your data.”

    if i say yes, it takes out all the formatting and design. if i say no, it removes the the data source connection. not sure how to reconnect the new one.

    October 24, 2019 at 10:00 pm Reply
    • Tomasz Poszytek

      Don’t replace datacards unless you want to build the form from a scratch again. Also, I’ve recorded a screencast where I am trying to explain how to make that migration. Please see it. It’s in the beginning of the post.

      December 31, 2019 at 1:05 pm Reply
  • Puneet Poojari

    Thanks Tomasz for wonderfull solution. I did sucessfull import – create new but now i am facing issue on Update LIst Form using same method. as i am not able to update as i m not able to see any app linked to it.
    Can you please help me on this

    November 7, 2019 at 9:40 am Reply
    • Tomasz Poszytek

      Hi, so what actually is not working? You were able to import form and set it as a list form, but now you cannot save it?

      November 7, 2019 at 9:50 am Reply
      • Puneet Poojari

        While importing i am able to select Create New option and i can proceed and i am able to work on form in different site. but now i want to use update existing one option while importing (whether the app should be imported as a new one, or to update existing one.).
        On selecting update option, i am not able to see any existing app in the environment which will be updated when this package is imported and import button remains disable.

        Is there any more setting/change i have to make for update purpose??

        November 7, 2019 at 11:29 am Reply
        • Puneet Poojari

          can you help here as i am stuck on updating of powerapps form

          November 12, 2019 at 11:11 am Reply
          • Tomasz Poszytek

            Hi! Sorry for keep you waiting. I’ve recorded a screencast where I am trying to explain how to make that migration. Please see it. It’s in the beginning of the post.

            December 31, 2019 at 1:04 pm
        • Puneet Poojari

          Have u got chance to check on my issue, as i stuck here.

          November 13, 2019 at 6:59 am Reply
  • Smy

    I wanted to import my dev environment form to the prod environment and I get the following error message:
    {“odata.error”:{“code”:”-1, Microsoft.SharePoint.SPConnectorException”,”message”:{“lang”:”fr-FR”,”value”:”List Not Found”}}} .
    I checked the json file and found the right Guids.
    Can you Help me please !

    November 22, 2019 at 10:28 am Reply
    • Tomasz Poszytek

      Hi! Sorry for keep you waiting. I’ve recorded a screencast where I am trying to explain how to make that migration. Please see it. It’s in the beginning of the post.

      December 31, 2019 at 1:04 pm Reply
  • Isa

    Hi Tomas.
    Congratulations for your work.
    Based on your information, I did export a SharePoint list form to a PowerApps standalone. (just the oposite)I got it deliting all embebed option from the JSON, and it works. But, when i save it it say that is going a be published in Sharepoint. Do you Know wich option do manage this? i D’ont find it.
    Thank you so much.
    Best regards.

    January 9, 2020 at 1:52 pm Reply
    • Tomasz Poszytek

      I didn’t find yet a way to really publish a list form as a standalone app. There is too much of manipulation needed both in the JSON and the present msapp file.

      January 9, 2020 at 2:30 pm Reply
      • Isa

        Thank you Tomas. I will inform you if I get

        January 10, 2020 at 11:16 am Reply
  • Therese Baker

    Thanks for the instructions! Worked perfectly for my SharePoint PowerApps form.

    January 27, 2020 at 9:22 pm Reply
  • Martin

    Thanks from Czech Republic. Your post helped me second time now, since I found it earlier last year and have forgotten the procedure 🙂

    February 6, 2020 at 2:52 pm Reply
  • James Tullett

    Hi Tomasz:

    Thankyou for this interesting article. I am using the methods here to attempt to migrate PowerApps between a Test/Development tenant and a Live tenant. At present, my efforts have been more successful with Canvas Apps than with Embedded Applications.

    I did have a question about the field “id” whose value is marked in red in the 5th picture below the video.

    “id”: “49384936-6f18-4567-8283-411e553280d2”

    Where does this value come from?

    I’ve been able to locate all the other GUIDs, URLs and names OK, but haven’t been able to work out this one.
    Is it the tenant GUID?

    February 17, 2020 at 10:48 am Reply
    • Tomasz Poszytek

      It is in red because code formatter uses this color. But it is just an ID of the datasource. You will have different. You shouldn’t modify it.

      February 18, 2020 at 9:03 am Reply
  • Ulises

    HI Tomasz, very useful video and article. It works fine for new list but what would be the procedure if I need to update the form in an existing list?

    March 26, 2020 at 12:06 am Reply
    • Tomasz Poszytek

      I would say you need to re-do the whole procedure from a scratch. So first remove the form, then create it again. Point is, with Power Apps for SharePoint update scenario doesn’t work.

      March 27, 2020 at 10:20 am Reply
  • Alex T

    Hi Tomasz,

    I tried to follow your instructions, but when I finally got to import my PowerApp I got an error saying “The application ” has an invalid definition.”

    Do you know what I might be doing wrong?

    April 25, 2020 at 12:19 am Reply
    • Tomasz Poszytek

      I haven’t faced such an error. Please follow the steps carefully. Maybe you have replaced something too much? There is also video added – try to follow the steps presented there.

      April 27, 2020 at 10:26 am Reply
  • Rodrigo

    Hello Tomasz, thanks for your article. I would like to know if is possible to import a package from powerapps to powerapps portal. Thanks a lot again

    May 5, 2020 at 1:34 am Reply
  • Ravi

    Thanks Tomasz.
    May be this would help someone, My first two attempts failed. For the third attempt, I used 7-zip software and voila, it worked !!!

    May 26, 2020 at 12:40 am Reply
  • STEPHEN WU

    Hello Tomasz, has Power Apps’ functionality changed in terms of importing? In your screenshot, I see that the import function used to be called “Import package (preview)”. When I tried to import, the verbiage is now “Import canvas app” (and “preview” has disappeared).

    I tried it anyway. First, “update” does not work because Power Apps offered me nothing to update. Then I tried to “Create as new”, but Power Apps complained that I already have an app with the same name. I decided not to rename and try again, because it looks like there is a good chance it will be imported to an environment different than the one I needed (given that no apps were listed as available to update in the environment now).

    In short, it looks like it is no longer possible to import Power Apps packages as SharePoint list forms.

    June 18, 2020 at 2:23 pm Reply
    • STEPHEN WU

      Sorry, I just watched your video, and saw that the user interface is in line with what my Power Apps shows, and different from the screenshot in the article. I will try again using your video as a guide. Doh!

      June 18, 2020 at 2:33 pm Reply

Post a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.