Answered

Copy all files from one folder to another within same SharePoint library using Flow

(0) Share

Report

Posted on by Yudistara

I am trying to use FLOW to automate copying files from one folder (say "Current") to another folder(say "Archive") within the same library. But it doesn't seem to work. Do I need to use some dynamic formulas here?

Please advice.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

Hi @ Yudistara,

Do you want to create a flow to copy the file in folder "Current" to folder "Archive" within the same library once a week?

If you would like to use the "Copy file" action if sharepoint connector to achieve your needs, you should fill in the file path in the "Source file path" field and "Destination file path" field of "Copy file" action instead of the folder path.

Please take a try use the "Create file"action to achieve your needs,and refer to screenshot below to create the flow to achieve your needs:

The expression in the "File Identifier" field of "Get file content" action as below:

items('Apply_to_each')?['{Identifier}']

The expression in the "File name" field of "Create file" action as below:

items('Apply_to_each')?['{FilenameWithExtension}']

The flow would run successfully to copy all files from folder "Current" to folder "Archive" as screenshot below:

Regards,
Alice Zhang

Was this reply helpful? Yes No
Yudistara 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-yuazh-msft. It worked perfectly with your instructions. Thanks a lot again.

But now I am trying to figure out how I can delete the file from "Current" folder in our example. Meaning, once the file is copied to Archive folder, the file needs to be deleted from "Current" folder.

I tried using the "Delete file" action, but not successful. Delete file action also deletes the file from both the folders. I only want to delete the file from the Current folder, but not the Archive folder. Any suggestions are appreciated.

Thanks.

Was this reply helpful? Yes No
Verified answer

Yudistara 28 on at

Like (1)

Report
Copy link

Link copied!

OK. I figured it out. Thought i need to share it if someone is looking for the solution.

All I had to do was get the files, set up a condition if the "folder path" contains the name of the folder in which the file needs to be deleted from. (See below screenshot) and then delete the file.

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

Like (0)

Report
Copy link

Link copied!

Very useful!
Would it be possible to edit the name of the file by adding today’s date at the end of the file name in the destination file path? I imagine it’d be in the Create File step, but what would the expression be?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Anonymous
Expression will be something like this

concat(split(filename,'.')[0],utcnow('dd/MM/yyyy'),split(filename,'.')[1])

Was this reply helpful? Yes No