Create a new folder in onedrive business when the app transfers from one environment to another

[Hussnain]

When we export our app from our environment to another environment with onedrive business database, then it's not created our database tables in the customer onedrive for business. Whenever the app is exported into any environment it must make new tables in onedrive but the tables remain the same as a system defined. So what methodology do we use to achieve this query?

[thomasfnorthrup]

Hello, thanks for reaching out. 

I wanted to clarify are you referring to the OneDrive for Business integration with the OOTB SharePoint integration with a model-driven app? Or are you configuring some custom folders in OneDrive for something else? 

Thanks. 

[Hussnain]

Thank you for your response.

I am creating a canvas app and when I tried to import this app into the customer environment. It's not working correctly and it gives me the error 'Server response failed ' when I tried to add some data. Because there are no database tables created in onedrive when the app is imported. And I don't know how to fix it.

[Hussnain]

And also please suggest to me what is the correct way to export the canvas app into another environment with one onedrive connection.

[thomasfnorthrup]

Sorry Hussnain, I am still unclear. 

OneDrive is a SharePoint site that has a document library containing folders. It does not contain database or tables. Anything in OneDrive would have to be configured in SharePoint administration, or created manually in that environment. 

If you are referencing tables in the Dataverse which your canvas app accesses in dev environment, then you would need to add those table components to a solution and move that solution from one environment to another. 

[Hussnain]

My canvas app is connected to an excel file. I use excel files to store and retrieve data in the canvas app and that excel file is stored in one drive business. Whenever my app is exported or installed into any environment the new excel file must be created in the customer onedrive business.

[thomasfnorthrup]

Ok, in that scenario you would need to manually create the excel file in the destination environment. There is no easy way to move that with the canvas app. You could use power automate to move the file from one environment to another, but that is more work than just creating the file in the destination. 

Let me know if I am misunderstanding something. 

[Hussnain]

 Thank you thomasfnorthrup for replying once again,

Our purpose is to create the excel file automatically in onedrive business whenever our app will be installed from the app store because we don't know who install our app from the app store so that's why we cannot create an excel file manually in each environment. 

Suggest me a solution whenever a person installs our app from the app source excel file will be created in his onedrive business.

How to do this?

[Hussnain]

We want to do the same as the Microsoft budget tracker app.

[thomasfnorthrup]

Sorry Hussnain, I have not worked with deploying apps through App Source. But I know the Package deployer tool is leveraged when your app is installed from App Source. That tool is very powerful and allows you to execute custom code which can created to find the SharePoint library and create a file. It would be complex to build, You may deploy a Power Automate Flow that creates the file and include running that flow the first time after install. That is another idea. Best of luck!

Step 3: Create an AppSource package for your app (Microsoft Dataverse) - Power Apps | Microsoft Lear...

Package Deployer tool - Power Platform | Microsoft Learn