Copy App with Google Drive Source to Subsite of Sharepoint

[mymymy]

I do have multiple Apps which have their data source on Google Drive (Google Spreadsheet and photo folders). Now I’d like to work with Sharepoint instead of Google Drive. So I’d like to copy the Apps to Sharepoint. I did add a new data source under “Account Sources” and could copy the App. Though, the data is saved under OneDrive of my private account. I’d rather prefer to use a subsite of my business. How can I change the data source to this subsite?

p.s. I’ve already had a look at the " Using Data from Excel spreadsheets in Office 365 and SharePoint" page and I’m aware of “AppSheet can only access files and folders that are stored in the default drive of a SharePoint site or sub-site. Contents that are stored in user-created drives are currently not accessible. In most cases, if you create a file or folder directly in a SharePoint site, the file/folder will automatically be created in the default drive of the site for you. Additionally, if a SharePoint site has been migrated to an on-premises server, it will no longer be accessible to AppSheet.”

[Aurelien]

Hi @mymymy

I have no experience yet with Sharepoint challenges: here are suggestions only.
Did you have a look there ?

and there:

[SkrOYC]

Curiously, yesterday I finished migration from OneDrive to a Sharepoint site.
Make sure to follow these steps:

help.appsheet.com

Data Organization for Teams

Best practices for organizing application data across a team of app creators

Microsoft O365

The following section describes how to configure an AppSheet account to use a SharePoint site as the default file storage location.

Create a SharePoint location

Create a SharePoint location where you will store data used by AppSheet applications. Add members that will create and own applications. End-users do NOT need to be added. Access for end users will be via the app and controlled by settings chosen by the app creator.

Get the SharePoint Site ID

Follow this process to determine the SharePoint Site ID for the target folder. Note: the SharePoint Site ID will have double forward slashes “//”.

1. Go to Microsoft SharePoint.
2. Select a SharePoint site and optionally a folder within that site.
3. Create an Excel workbook in the SharePoint folder.
4. Open your existing AppSheet application in the AppSheet Editor.
5. Go to the Data > Tables tab and click Add New Table .
6. In the GET DATA FROM dialog, select your Microsoft provider.
7. Select “SharePoint”.
8. Browse to your SharePoint site and folder.
9. Select the Excel workbook you added earlier.
10. Go to the Table > Data tab.
11. Select your newly added table.
12. Expand Storage.
13. Copy the entire first part of the Source Id property. This value starts with “SHAREPOINT_SITE_ID”. If you specified a folder, include the folder name. Omit the worksheet file name.
14. You can now delete the newly added table. All of the preceding steps were present to obtain the “SHAREPOINT_SITE_ID” value from the previous step.
15. Go to the Info > Properties tab.
16. Expand APP PROPERTIES
17. Copy the “SHAREPOINT_SITE_ID” value into the Default app folder property.

Set the default file storage location

The default file storage location can be set for an individual user’s account. When a user creates a new app, AppSheet creates a folder in this location to store files associated with the app (e.g. uploaded images, email templates). After the app is created, the file storage location can be modified for the app independently of the account default.

To set the default file storage location for a user’s account, navigate to: My account > Settings > Default folder path.

To set the default file storage location for an individual app, open the app and navigate to Info > Properties > App Properties > Default app folder.

Copy the SharePoint Site ID obtained above and paste into the desired location.

Updating existing applications

There are two methods to move an app’s data from OneDrive to SharePoint.

Method #1, move the data and update each table with the new data location:

1. Navigate to the app’s folder in OneDrive
2. Right click the folder and select “Move to”
3. Specify the new folder in SharePoint and click “Move here”
4. After the data is moved, open the app and navigate to Data > Tables
5. For each table
   a) Expand the “Storage” section
   b) Click “Source Path” and locate the spreadsheet in its new SharePoint location
   c) Click “Worksheet Name/Qualifier” and specify the correct worksheet for the table

Method #2, update the app owners default file storage location and copy the app:

1. Follow the steps in this section to update the app owner’s default file storage location to SharePoint
2. Open the app to be moved and navigate to: Manage > Author
3. Click “Copy App” and set the “Save app to” dropdown to “office365”

AppSheet will create a copy of the app definition and the associated data. The data will be saved to the default file storage location for the user’s account.

The process can be combined with an App Upgrade if it is important to maintain the same links for end-users to access the application.

[Roben]

You can do this manually by downloading the files from Google Drive and uploading them to the appropriate document libraries or lists in the SharePoint subsite. Alternatively, you can explore automation options or third-party tools that can assist with data migration such as Rclone, Carbonite, and Gs Richcopy360 .