Dropbox -FILES AND FOLDERS- to Sharepoint Online

[DGC77]

hello everyone (you too @v-xida-msft if you're listening...),

after going through tens of posts, i got stuck with creating a flow that will basically copy all files and folders from a single dropbox user, to our organization's sharepoint site.

i've managed to build a flow that will copy files.

i've managed to build a flow that will copy [empty] folders.

i haven't managed to get flow to copy ALL existing files, folders, sub-folders - and the contents, from DB to SP...

any ideas?

thanks!!

[v-zhos-msft]

Hi @DGC77 ,

You purpose  is to copy files (folder and file) from dropbox to SP library.

I have made a test on my side, please take a try with the following workaround:

The '/box' is my SP library name, you need change teh name of yours.

'

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DGC77]

first of all, thanks for all your efforts.

it seems to work half way.

it copies the files within the root folder, yet fails to deal with subfolders.

i assume (yet not sure) that the flow is "aware" of a subfolder, but fails to create a copy of it on the SP site, therefore resulting with a 404 message - and it does not proceed to fetch the files within the subfolder.

what would be the correct step at this point?

thanks!

[v-zhos-msft]

Hi @DGC77 ,

The structure of my dropbox is like below:

When I used the flow above, it can wok successful:

However if your dropbox have many levels of subfolder, I am afraid that there is no way to achieve your needs in Microsoft Flow currently. 

There are some similar cases and idea you can take reference:

https://powerusers.microsoft.com/t5/Building-Flows/Copy-Sharepoint-Folder-with-Subfolders/m-p/51241?...

https://powerusers.microsoft.com/t5/Flow-Ideas/OneDrive-for-Business-Folder-copy/idi-p/22227?collaps...

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[DGC77]

Thanks a lot.

I assume that thre only solution would be a full import using SharePoint Import Tool, and then creating a flow for comparing files stored on both services, which is way beyond my knowledge.

[RobertoGrau]

The suggested flow does not work if the file is large. The block 'Get File Content' fails.  Is there a way to go around this limitation.