Copy most recent file from one folder to another and rename file

(0) Share

Report

Posted on by StuartSmith

225

We have 2 folders...

Folder 1: Used to store a daily data output fileS (.xlsx) in. Each daily file is named similar to "Daily_Spend_Service_20200828_000148", but with the date section changing.

Folder 2: Used by Power Bi to refresh a data report. Power Bi looks for a file called "Upload" in the folder.

We need a flow to copy the most recent file found in Folder 1 and copy it to Folder 2, once the most recent file is in folder 2, delete the previous file called "Upload" from folder 2 and rename the newly copied file to "Upload".

Is this possible? Very new to creating Flows, so any guidance would be great.

Categories:

Building flows

I have the same question (2)

All responses (3)

Answers (0)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Yes we can!

But, we need some more context info...

Onedrive? Onedrive4Business? Sharepoint?

Thanx!

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

Sorry, yes, both folders are located in Sharepoint Documents...

Documents\Folder 1
Documents\Folder 2

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!
Hi!

In order to copy newest file from folder 1 to folder 2 I would do the following:

Set 'Get files (properties only)' by selecting target site, library name and folder... Set 'Top Count' input to 1 and type the following ODATA expression to 'Order by' input

Created desc

Next add an 'Apply to each' action block, assign as its input 'Get files (properties only)' value output... this 'Apply to each will be executed 1 time only, since 'Top Count' was set to 1

Now inside the Apply to each I would add 'Copy file' action block. GReat stuff in this article on this action block

https://www.chakkaradeep.com/2018/10/10/new-and-improved-sharepoint-copy-move-actions-for-microsoft-flow/

Once you get this part running please let us know so we will work on renaming and deleting

Hope this helps

Was this reply helpful? Yes No