Unanswered

Files from OneDrive Business to google Drive

(0) Share

Report

Posted on by glarag

Hello. I am trying to accomplish a simple flow, but even the flow that is already published as a template is not working. I already have many files in one target folder in OneDrive. I want the files to be copied to another folder in Google Drive. I used the "Create file" from OneDrive trigger, then "Create file" in Google Drive, but the problem is only the first file is being copied to the Google Drive folder, not all files in the OneDrive Folder. I tried removing all files from OneDrive folder and add one by one the files, but, again, after succeeding to copy the first file, on the second file there will be an error saying that the file cannot be copied because a file of the same name (the first one which is already in OneDrive and Google Drive) already exists. This should be just straightforward, how come it is not?

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

AlanPs1 2,471 on at

Like (1)

Report

Hi @glarag , sorry for the issues you are having.

Here is a Flow that will get all files in a OneDrive for Business folder and move them to a GoogleDrive Folder.

You press a button, they all move over.

I think the issues you describe is that the templates trigger when a new file is created, this means just the new file moves over. Using the custom method above will get all files and move them over.

I have tested it, it is fully working.

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

Hi @glarag

I am just wondering if you have had a chance to implement the presented solution?

Thanks, Alan

Was this reply helpful? Yes No
glarag 8 on at

Like (0)

Report

Hello Alan, thank you so much for your advise but I am still in the middle of testing it. So far only 20 of the 60 files copied over. Is this just taking long and I'm supposed to wait, it's been 17 mins since I triggered.
Will update,
Lara

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

Hi @glarag (Lara)

Great news you are giving it a go and that the early signs look good!

You can let me know on completion in that case

Thanks, Alan

Was this reply helpful? Yes No
glarag 8 on at

Like (0)

Report

Hello again Alan, nothing added to the initial 20 files so I triggered again. On the second try, it still just copied 20. Did I not the flow correctly?

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (1)

Report

Hi @glarag .

You're right, it only seems to handle 20 at a time. It has done the same with me.

I can see a way that I can work round that but once it has done 20, that's it for now.

I should be able to enhance this to loop back though or maybe another alternative so will report back later in the week.

If you have found my posts helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
glarag 8 on at

Like (0)

Report

Thank you for your patience Alan, I am finding flow as having a steep learning curve.

Was this reply helpful? Yes No
TChilds 2 on at

Like (0)

Report

Hi Alan...did you investigate how to get that flow to transfer more than 20 files at a time? I have alot of image files I want to transfer to Google Drive and doing it at 20 files at a time is going to take a century. Appreciate the help/advice.
Travis

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

Hi @TChilds

I've had a bit of a go but still not cracked it. Just not managed to find the time to try all the angles but when I do I will post back for sure.

Thanks, Alan

Was this reply helpful? Yes No
HenkFeenstra 2 on at

Like (0)

Report

Hi,

Do you know if it's possible to also copy new files to the same folders?
I have multiple directories in my OneDrive for Business and Google Drive.
And when i save a file it will be in one of those directories.
Right now the flow from onedrive to google drive works if you save a file somewhere on your onedrive but it stores the files in the root of the google drive.
i also want that the file gets into the same folder as on the onedrive.

So you get something like:
Save file "document.pdf" in onedrive folder XYZ
Check Google drive for folder XYZ. Exist -> continue / Doesn't exist -> create folder XYZ
Folder exist -> check for existing file. Exist -> update / doesn't exit -> copy file
Folder doesn't exist and is new created -> copy file in new folder

The flows right now needs you to specificy the folders you want to copy from and copy to.

Thanks in advance for the help.

Kind regards,
Henk Feenstra

Was this reply helpful? Yes No