Add Sharepoint List Form to Existing App

[MartySt]

Hello,

I have built an app that initially was pulling data from an Excel file, however, I have had to migrate the data to a sharepoint list as that was more practical (and I cannot feasibly go back). Previously, I had a form which you could view and edit built into the app, which connected to the Excel data. However, I've found out that you cannot simply connect to a sharepoint list form, from an existing app. In order to get the special "sharepoint integration" connector, you must create a NEW app from the sharepoint list that will let you edit/view the form.

I have two options in my mind:

1. Copy over everything from my old app to the new app that is compatible with the sharepoint list form

2. Somehow travel from the old app to the new one in order to have access to the form? This would happen quite frequently and could be bothersome for users

Both of these options are a bit unattractive to me due to these reason: 

1.I don't mind doing the tedious work of remaking my complete app into a new one, you can copy paste decently well across apps, however, the new app does not have the same screen settings available as a standard canvas app??  In the "new" app, the screen options are orientation and size, which let you set small, large, or custom resolution. However there is no scale to fit, lock screen orientation, or lock aspect ratio options available. It would be a shame to be forced to move to this new app and have less features.

2.Will travelling to a second app slow the overall time it takes to go between screens? As is, the flow from the main app and editing the form feels really natural, will this become clunky?

Are there any other options that I haven't considered? thanks!!

[v-xida-msft]

Hi @MartySt ,

Do you want to migrate a standard canvas app to your SP List as custom form app?

If you want to migrate a standard canvas app to your SP List as custom form app, I afraid that there is no way to achieve your needs in PowerApps currently.

The Standard canvas app and Custom Form App are different App type in PowerApps. Currently, there is no way to convert a standard canvas app to a custom form app directly.

If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

As an available solution, I agree with your first option -- Copy over everything from my old app to the new app that is compatible with the Sharepoint list form.

Currently, if you want to migrate a custom form app from one SP List to another SP List across different tenants, I think it's possible in PowerApps. Please refer to the following blog:

https://www.microland.com/blogs/powerapps-customizations

Best regards,

[WarrenBelz · Accepted solution]

Hi @MartySt ,

You can directly copy a form to the SP list easily - I have posted this solution a number of times, but it seems it is not standard Microsoft Power Apps protocol. I do almost all of our SP Integration forms as stand-alone first then: -

• Let SharePoint generate its "default" app and leave it open.
• Open your standalone app in edit/design mode in another tab.
• Rename the SharePointForm1 in the Integrated app to whatever Form name you have in the other one.
• Delete the SP form
• Adjust your canvas size in the SP form to match the other one (width is particularly important)
• Copy your other form and paste it directly in - you may have to adjust X and Y depending on where it "lands"
• Change the Item of the Form to SharePointIntegration.Selected
• Save and Publish

and then it all works.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @MartySt ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[MartySt]

Hi @WarrenBelz 

I am having a bit of trouble getting this work, to clarify, here are the steps I've done:

• Let SharePoint generate its "default" app and leave it open. (Done)
• Open your standalone app in edit/design mode in another tab. (Done)
• Rename the SharePointForm1 in the Integrated app to whatever Form name you have in the other one. (Done)
• Delete the SP form (Am I deleting the form in my standalone app? This is what I assume I'm supposed to be doing)
• Adjust your canvas size in the SP form to match the other one (width is particularly important) (Done)
• Copy your other form and paste it directly in - you may have to adjust X and Y depending on where it "lands" (Copying the SP List Form into my standalone app correct? Doing this doesn't yield any data unfortunately)
• Change the Item of the Form to SharePointIntegration.Selected (this gives me an "Name isn't valid, the identifier isn't recognized error")

I had actually followed these steps and it worked for me once yesterday, but a power outage closed the app before I could save (lucky right..?), I'm having trouble recreating this success

Thanks!

[MartySt]

@WarrenBelz 

Disregard my above comment, I got it to work! I had clicked on "customize form" instead of "create an app". Copy pasting the form from the created app worked great!

[WarrenBelz]

Hi @MartySt ,

That is great - it works in both directions, except there is a bit more work going from an integrated form to a standard app.

I am however a little confused over your comment
I had clicked on "customize form" instead of "create an app". 

I would have thought it was the other way around - you are copying from an App to the customised form. I am sure you have worked this out, but the form you need to delete after renaming it (all the renaming does is sets up all the settings to refer to the new form) is the one in the integrated app. You then copy the "app" item over and change the Item property.

[dperez13]

can you elaborate on this step? particularly the delete the sp form step?

this is to show how to copy paste a stand alone app into a sharepoint app canvas, right?

[dperez13]

also anyone gotten his to work? https://www.microland.com/blogs/powerapps-customizations i keep getting sharepoint integration errors making the form unsuable when following these steps and similar steps, including going into the msapp and changing the json in there results in sharepointintegration being gone entirely. 

[WarrenBelz]

@dperez13 ,

I have done a blog on it - I can assure you it works