Unanswered

Sync Existing Files and Folders From SharePoint to Google Drive

(0) Share

Report

Posted on by Community Power Pla...

I'm brand new to Flows and I am trying to sync exisiting files and folders from SharePoint to Google Drive but I only see a template for syncing new files, which does work.

While this is useful, it doesn't help when I want to copy already existing files and doesn't appear to be able to sync folders in folders.

Ultimately I would like to have a schedule for the folders and all content inside the folder, including other folders, to sync once a day and update to GDrive. Is there a template for this already that I am just not seeing?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Add a custom column in your SharePoint library called 'Sync' type boolean. Set the default as false. Once the file synched to Google drive then update the column to true. When ever you retrieve the SharePoint files filter against Sync false so that you always retrieve the files which are not synced.

There is no flow template for reading all the files inside the another folder. For getting the sub-folders inside the folders you probably need a flow to do a recursive method to extract the files.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
v-litu-msft on at

Like (2)

Report

Hi @Anonymous,

There is no direct action to sync files from the SharePoint library to Google Drive.

But the is a workaround you can do it, please follow these steps to create your Flow to sync files:

Step 1: You need to create a folder named as your SharePoint library, mine is named LibraryA:

Step 2: We start to create a Flow with a manual trigger, it will run if you click the button, or you can create a currency trigger run every day.

Step 3: Get these files from your library, then Apply to each of them. Firstly, we need to judge each of the file whether is a folder, if it is a folder, skip it. If it is not a folder, get the file content and create its mirror file in the Google Drive.

Step 4: If the file has existed in the Google Drive, get the file id use the Get file metadata using path action, and then update it. One point that should be noticed is that we need to set the Configure run after of Get file metadata using path action as the previous action has failed. So, the file would be updated if the file has existed in the Google Drive.

Please have a try, I hope it can help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you! I will give this a shot!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

At the Get File Content step I selected the Site Address but I also need a File Identifier. What do I need to enter for that?

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

Please put the Identifier into it.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I built the flow as you described but I must be missing another piece.

When I click "Save" I get the error below error for both "Get files (properties only)" and for "Get file content" later in the flow.
"Enter Sharepoint site address and list/library name"

I have selected the site address from the dropdown for the site I want and I have selected the library, also from the drop down. Both clearly exist, otherwise I wouldn't see them and be able to select them.

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

pick "Identifier" from the get file properties action

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

Never mind, it's just a notification, not a warning or error.

And please use the Identifier instead of file path + filename with extension.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Moving in the right direction! Thank you! It did copy all of the files from each of the folders and placed them into the root of the Google Drive folder I created.

Is it possible to have Sharepoint create the folders in Google Drive and place the files into the correct folder?
Or do I need to create a flow for each and every folder I want to keep synced?
There are a lot of folders and sub folders. I can use the guidance you gave me to make more flows that are similar but it would be very time consuming to do that for every folder and sub folder.

A lot of these files are in sub folders in the SharePoint library, but as you can see in the screenshot, they are all in a single folder in Google Drive.
SP FoldersGDrive After Flow Runs

Was this reply helpful? Yes No