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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,857)