Importing Power Apps package as a SharePoint list form

[@donaldsunny7836]

Thank you a million %, you have saved my weekend reproducing a PowerApp app on another environment. This video is so easy to understand. This has saved me hours of work. I salute you

[@TomaszPoszytek]

Reading your comment makes me very happy 😊 Good luck in your project.

[@adamparkai-nagy2816]

Sir, you do deserve a medal for this! Thanks a lot, keep up the good work!

[@TomaszPoszytek]

Thank you very much 🥰

[@thomKunz1309]

Tomasz, this is beyond awesome and just saved me umpteenth hours recreating a form with quite substantial logic in it. Thank you so much!

[@TomaszPoszytek]

You're very much welcomed! ☺️

[@rt3ds814]

This process helped to copy a sharepoint list form to a new site list. Awesome info thanks for sharing!

[@TomaszPoszytek]

You're welcome 😄

[@elturankazimli4805]

Hi! Followed step-by-step and works perfectly. Thank you for such a nice video!!

[@TomaszPoszytek]

You're welcome! :)

[@JustAnIslandGuy]

Tomasz, thanks so much for this. It is indeed a GREAT time-saver!

[@TomaszPoszytek]

I'm glad it helped you!

[@jcelente]

Thanks a lot. That is exactly what I was looking for

[@TomaszPoszytek]

You're welcome! :)

[@jitu0583]

Thanks this is really helpful.

[@TomaszPoszytek]

You're welcome :)

[@ianalexandertorres6189]

i was looking for this!!! thanks man!

[@TomaszPoszytek]

+Ian Alexander Torres you're very much welcome ☺️

[@powerappsjunkie6296]

Any idea on how to do this now in 2021? It would seem they've changed the way information is written in the json file and none of the details listed are there now. It's just a single line of text now and doesn't mention anything as in the video. @Tomasz can you please look into this and see if it's still possible now in 2021?

[@TomaszPoszytek]

I checked it today. The file structure is still the same. It is displayed as a single line, but when you format that code it's quite a regular JSON :)

[@missAerielle]

Hi! thanks for the video. Im just wondering what are the steps i should do if want the form to be imported in a list with a different name but having same columns? thanks in advancen

[@TomaszPoszytek]

Hi, just follow the same steps, simply update list name and guid inside JSON.

[@missAerielle]

@@TomaszPoszytek Thanks, man. Ive read your blog and followed the steps. The import was successful but when I tried to open the customized app, its giving me an error something like "there was a problem opening the app". it didnt give me a specific details about the error so im not sure anymore whats the problem :(

[@TomaszPoszytek]

@@missAerielle please note, that this method isn't officially supported by MS. There's no oob method though. Whenever you see any issues you can try to do all the steps again. But first delete the form from the list.

[@snehas6742]

Thank you for the video but if i want to export within same tenant for another site collection it will give me "An App already exists for this list. Remove the existing App before adding a new one." errror..what we should do in this case?

[@TomaszPoszytek]

You need to change guids of the list and site. Without that you're trying to add the app back to the same list where you have exported it.

[@snehas6742]

@@TomaszPoszytek Yes,I've already replaced target SiteId,GUID and list Url from exported Json file..

[@TomaszPoszytek]

@@snehas6742 Maybe there is already a PowerApp form on that list? If yes, go to that list settings > form settings select "Use the default SharePoint form" option. Then under "Power Apps" option you will see link "Delete custom form". Click it and then try again.

[@snehas6742]

@@TomaszPoszytek Yeah,there was a custom form already on that list,deleted that form..Thanks for the reply.

[@brianhiggins9986]

Tomasz, thanks for the video. However, how do you accomplish this with a duplicate list in the same tenant. I have a Production list and want to create a Development list to test before I apply to the Production. Thanks in advance, Brian.

[@TomaszPoszytek]

Hi, well basically the same. You just need to change list URL and its GUID inside the exported package. Then import and it will appear as the form for the other list.

[@ResponsibleXI]

Great Video, thank you for this. One question - While this is working well for new imports, how can i do for updating any changes from Dev to Prod? While I try to choose from list of apps, it doesnt show my App with customized list forms. Is that a limitation? Do I have to delete existing settings from List Settings and import as new app again and always?

[@TomaszPoszytek]

You can't. You need to first remove existing form and then upload new version again. As said, this is not a supported approach, thus there's no lifecycle support.

[@ianalexandertorres6189]

What are the disadvantages using PowerApps SharePoint list form rather than starting from canvas app? I'm currently using this approach since i only have 1 list and nothing to connect anymore. Also users don't have to go outside the SharePoint site. Do you think it's alright that i used this?

[@TomaszPoszytek]

+Ian Alexander Torres I wouldn't consider advantages and disadvantages. Standalone canvas app is a solution on its own, whereas PA as SharePoint forms are helping you to build more complex interfaces for inputting data. The one disadvantage that you need to know is when you open SharePoint on mobile app, custom PA forms won't be loaded. So if you consider having your solution mobile, then standalone app might be a better solution.

[@techcoevolve]

Great 👍 Subscribed

[@ousselg1509]

Hello, thanks for the video. I wanted to know if you can use a already created app and embedd it in a SharePoint list?

[@TomaszPoszytek]

Not if it is a standalone app.

[@ousselg1509]

@@TomaszPoszytek thanks mate

[@VishalThakur-hh4pm]

Hi, have you tried this if Powerapps form is using some Power automate flows ?

[@TomaszPoszytek]

Yes, and as long as they were all exported as a single zip file all was good.

[@DaveMelton]

I just checked the functionality for this in current SPO, and it's gone. Previous versions no longer seems to have an export function.

[@TomaszPoszytek]

Hey, I am still able to find it. Just click to display details of the app and there is still the button to export.

[@VishalThakur-hh4pm]

Hey after doing the steps, when I am trying to open an item in the target form, I see… “Cant find the default display form for the list [] “

[@TomaszPoszytek]

I haven't faced such issue yet. Are you sure you have updated all the guids and names so they reflect new list?

[@VishalThakur-hh4pm]

@@TomaszPoszytek I have updated all the 3 items in the EmbeddedApp section. Yes

[@jl1399]

why might despite changing the site urls and and the guid ids the data connection refuse to go to the correct location and always refererence where it came from?

[@TomaszPoszytek]

It's a difficult question, I don't know the answer. It is sufficient to just change list URL, name and all guids.

[@jl1399]

@@TomaszPoszytek I found often to first delete all data connections then to replace them can fix this issue

[@satyanarayanach3038]

Thanks for the Great session.... But I have a question can we do the same thing while importing the canvas app package, because I don't find the option....or is there any other way???

[@TomaszPoszytek]

No, you can't do the same using oob method. Manipulation in the files is required.

[@satyanarayanach3038]

@@TomaszPoszytek ok.thanks for the response, It would be great if there is any reference for this manipulation. I have searched a lot but not able to find any thing

[@TomaszPoszytek]

@@satyanarayanach3038 would this be helpful for you? poszytek.eu/en/microsoft-en/office-365-en/powerapps-en/importing-powerapps-package-as-a-sharepoint-list-form/

[@satyanarayanach3038]

@@TomaszPoszytek Hi Tomasz, In my case it is quite different, I have a Canvas app where SharePoint list as Data source, I want to create a acceptance environment for the App. I have created a replica of the app by exporting and importing the package but there is no way to change the data source in JSON file. After importing the App when I try to redirect the data source to acceptance SharePoint list where the structure and Name is same it is actually erasing all previous customisation done on the app. So rather I am trying to find any simple way to do this instead of recreating everything from scratch, I found your video but this works for customised forms not for canvas Apps. So I am just wondering if there is any simple way for canvas app something like this

[@TomaszPoszytek]

@@satyanarayanach3038 in case of a standalone canvas app you simply need to open data sources in your imported app and from there remove old SharePoint data source and add the new one: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online#add-data-to-an-existing-app

[@ezjensen]

Thank you for this video. Any idea why I would not have the "embeddedApp" propertie(s)? I created a form in PA that points to a SharePoint list for data. I just now received a request that people can open the form by clicking an item in the SP list. So I'm trying to import the PA form to the SP list as the SP List form.

[@MikWsk]

This approach is for moving SharePoint Custom PA Form it can be created only by clicking "Customize in PowerApps". It contains a special "SharePointIntegration" element in the tree view of your app. I believe that;s the one responsible for "embeddedApp" config.

[@geralddahl9159]

This is helpful, thanks!

[@365degree9]

Thank you for the great video. When I managed to export the package, I got this message: "The provided flow' has been deleted." Do you know why? thanks

[@TomaszPoszytek]

Hey, I don't know your exact scenario, but maybe this will help: poszytek.eu/en/microsoft-en/office-365-en/powerapps-en/powerapps-export-fails-due-to-missing-components/? Maybe there is one orphaned connection to a flow in your app, and that flow is deleted?

[@365degree9]

@@TomaszPoszytek Yes, you are right! I did delete a flow link to a button. Now I am trying to fix it following your guide, hic. By the way, is it possible to apply this approach to Powerapps for Teams? thanks

[@TomaszPoszytek]

@@365degree9 for the Dataverse you should be able to export the app following the regular solutions' export->import approach.

[@365degree9]

@@TomaszPoszytek I have tried, when I clicked "Export package", nothing happened, when I clicked "Add to Teams" I could download a zip file with no msapp file. It would be great if you could have a video to guide us through this issue. Many thanks in advance!

[@SobaSugoi]

I just recently went through this process on a very in-depth application for a custom list I did and I wanted to note that in the article you have on this process, you have the user make changes to the connection references > datasets table and that was necessary for me. I also didn't have a join lines feature, so I found a way to do it myself without formatting the document, not too difficult but definitely worth getting an extension for that. I had no error for the form when opening the imported version of the application, but it linked to the wrong site still until I removed and added the SharePoint data sources for the form to the correct tenant. Keep in mind you must have all SharePoint sources updates; all SharePoint lists must have their GUID and URL links updated if they are all being moved as they were in my case. Otherwise if you want to maintain separate lists, such as an access control list, on the original tenant, then feel free to leave those data source updates as is.

[@TomaszPoszytek]

+Luke Estes thanks for sharing 😊

[@illmatic1668]

Hey Luke, were you moving between two different tenants or within the same tenant to a different site? I have tried this attempt in so many iterations and nothing works. Adding the GUID for the connection references > datasets table node for the main list and the additional data sources has always rendered "Sorry something went wrong." I am getting super frustrated.

[@SobaSugoi]

@@illmatic1668 I'm relatively new to all this stuff, but based on a quick search I believe it was the same tenant but different sites. When dealing with the additional data sources do make sure that you have added them to the new site/tenant. For example if you export/import the "main list" make sure you do so for the additional data sources if they're migrating as well, otherwise the references will be invalid. Does that make sense?

[@DzielnyKompanion]

Really, really valuable and helpful content. Wish I could found it year ago ! POZDRO GOSCIU

[@TomaszPoszytek]

Thank you! Dziękuję bardzo :)

[@ayantorcasitas1989]

thanks :) very helpful

[@TomaszPoszytek]

You're welcome ☺️

[@modmama1924]

THANK YOU