cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
laz8592
Helper II
Helper II

Copy EXISTING files (not when files are created) in a sharepoint library to dropbox

I have alot of videos that I want to copy from a sharepoint library to dropbox. 

Using a template I see this flow can only run when new files are added (when files created) in the sharepoint library. 

I want to be able for the flow to look inside a sharepoint library or folder nd to be able to COPY the exisitng files to dropbox. 

 

How do I do this? See below default template I want to tweak. 

laz8592_0-1646819683195.png

 

 

8 REPLIES 8
ChristianAbata
Super User
Super User

hi @laz8592  you have only one way and is changing your trigger, so you can select schedule and run depends on a especifc date or manually so you can run it when you need.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi Christian

 

So basically I create a 'scheduled flow' with the 'when a file is created' sharepoint trigger and then create the file action on dropbox? 

Hi @laz8592 

Before creating a file, you need to get the file's properties and file content, and then create a new file.

vLilyWmsft_1-1647246159715.png

vLilyWmsft_0-1647246147062.png

vLilyWmsft_2-1647246205995.png

vLilyWmsft_3-1647246232558.png

vLilyWmsft_4-1647246245651.png

After flow runs, the files in this folder will be copied to the Dropbox folder.

vLilyWmsft_5-1647246336581.png

vLilyWmsft_6-1647246354808.png

Hope the content above may help you.

Best Regards

Thank you for your reply, everything worked expcept for the copying , see error below

laz8592_0-1647265617782.png

 

Hi @laz8592 

Does your folder contain subfolders?

If it contains subfolders, you can first determine whether the file is a folder, if it is a folder, skip it, if not, copy it to DropBox.

vLilyWmsft_0-1647331943085.png

Best Regards.

I am having a problem with the isfolder value. When its there the error is shown below. If i select a single file in the File identifier it copies the file successfully. I want to be able to copy whole folders and everything inside them. 

 

laz8592_0-1647333858255.png

 

Hi @laz8592 

If you want to copy the entire folder to Dropbox, you can refer to the screenshots below.

Suppose I want to copy every files inside the ‘Copy’ folder including the subfolders in Documents library to Dropbox.

vLilyWmsft_0-1647334631043.png

Flow in details:

vLilyWmsft_7-1647335275278.png

vLilyWmsft_2-1647334732300.png

Get the folder path with this formula.

Expression:

last(split(items('Apply_to_each')?['{Path}'],'Shared Documents'))

vLilyWmsft_3-1647334749738.png

‘Copy’ folder and subfolders are automatically created when new files are created.

vLilyWmsft_4-1647334982207.png

After flow runs, the 'Copy' folder will be copied to Dropbox.

vLilyWmsft_5-1647335064615.png

vLilyWmsft_8-1647335371814.png

Best Regards.

thank you very much for your help but the latest option is throwing up too many errors now. 

I have spent too much time on this, as it requires alot of configuring, I will go back to copying manually from onedrive to Dropbox 

 

Thank you for your time. 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,653)