How to move files from one Sharepoint folder to different folder weekly

[NYOps-2022]

Hi all, 

I am stuck on the last setup of my power automate setup and hope someone can helps me.  I have a flow to create folder weekly using the date as the folder name.  for example, last week's folder is "10-7-2022" and this week's folder is "10-14-2022".  There are some files upload to the Sharepoint "Upload" folder each week.  I want to setup an automation to moves all the files in the "Upload" folder to each week's folder.  For Example, on 10-8-2022, all files in the "Upload" folder would move to folder "10-7-2022".  On 10-15-2022 which is tomorrow, all files in the "Upload" folder would move to folder "10-14-2022".  by next week, there are new files in the "Upload" folder and a new folder name "10-21-2022" and all the files in the "Upload" folder would move to folder "10-21-2022" on 10-22-2022 and so on.  Is it possible?  I can create recurrent automation to move file to just one folder but can't think of anyway I can set it up the way I need. 

thank you in advance for your help!

[grantjenkins]

Do you know how many files you expect to have each week within the Upload folder and the maximum size of a single file?

Below are the steps I'd use to achieve what you are after:

1. Set up a Recurrence trigger so the flow runs once a week as a specific time
2. Convert todays date to my time zone in the format yyyy-MM-dd (Year-Month-Day)
3. Create a new folder using the converted date
4. Get all the files from the Upload folder - and set Include Nested Items to No
5. Loop through each of the files returned (only include top level files and folders)
6. For each:
   1. Check if file or folder
   2. If file then use Move file action to move the file to the new weekly folder you created
   3. If folder then use Move folder action to move the folder (and all files/sub-folders) to the new weekly folder you created

See a summary of the flow. I'll go into detail of each action below the summary.

Recurrence

I've set this to run at 6PM each Monday (Brisbane Time zone). You would set as appropriate for your requirements.

Convert time zone

I get the current date using utcNow() and convert it to Brisbane Time zone formatted as yyyy-MM-dd. I use the output of this for my new weekly folder name.

Create new folder

This creates the new weekly folder using the output of the previous action.

Get files (properties only)

This retrieves all files (including folders) at the root of the Upload folder. The reason it only gets the top level files/folders is because I set Include Nested Items to No.

Apply to each / Condition

We then add a loop to iterate over each of the files/folders returned from Get files.

Within the loop we check to see if the item returned is a file or folder using the IsFolder property from the Get files (properties only) action.

Move folder / Move file

Depending on the outcome of the condition we use either Move folder to move the folder (and all files/sub-folders), or Move file to move the individual file. Both of these are setup exactly the same - just the actions used differ.

Hopefully this achieves what you are after.

[NYOps-2022]

thank you @grantjenkins so much for the information.  I might have thousands of files that need to move every week as those files are generate from the email attachment.  I will look through your suggestion and see if it works.  thank you again. 

[NYOps-2022]

@grantjenkins thanks you again.  I tried it but keep getting flow run failed on move file part.  Not sure if I did anything wrong but keep getting flow run failed when I test it. 

[grantjenkins]

What are you using for the Destination Folder parameter? It should be Full Path which should return a Folder path only, but yours seems to also include the filename in your screenshot.