Sharepoint-Moving files created with flow each Monday at 8am of every week and moving them to specific folder

[Alex_AR]

I have two flows currently running. 

1. The first flow creates a file based on a template every first monday of the week and names it as follow weekly_tasks_yyyy-MM-dd. The date at the end of the file name is automatically generated and is the date the file is created.
2. I have another flow that creates a folder every 1st of the month and the name format is yyyy-MM

I am having hard time creating a flow that will move the files created weekly to the correct folder automatically. for example

a total of 4 files are created in January, each file is moved automatically to the January the day it is created. Lets say there are 4 Mondays in January and at the end of the month the January folder will contain all 4 files created during that month.  the process repeats itself for each month. 

if anyone can point me in the right direction it would be greatly appreciated. 

[efialttes]

Sharepoint?

[Alex_AR]

In sharepoint yes, thanks 

[efialttes]

Hi again

And the new files (i.e. the ones not moved yet) are stored in the same source library, right?

If so, you can use the flow to be executed 1st of February 2020 to move 2020 January files to 'January' folder.

First you get all files on Source Library by means of SP Get Files (properties only). This action will give you a bunch of properties per file, one of them its ID.

Then you add a Filter Array to get the ones whose name contains the pattern you are looking for (2020-01)

Once you filter them, you add an Apply to each, its input will be filter output.

Inside the Apply to Each, you should invoke Move File action block

There are other approaches: for example, instead of using filter array, you can use a condition inside the Apply to Each, as explained in this thread

Hope this helps

[Alex_AR]

Yes, the files created are stored under a template in a document library. The old process was manual for both the renaming of the files and the creation of folders. You solution will work for sure but I am trying to make it even more organized by providing monthly folders where the files are generated. I have a team of engineers that report their weekly accomplishments every Monday for the previous week and it would be nice if they can go into the correct folder month and have the file ready for them to be populated. 

[efialttes]

Hi again
Not sure I understood properly.
What are you missing in my suggestion?
Thanx!

[Alex_AR]

I misunderstood you, I thought your suggestion will run at the end of every month and move the files into the correct folders. You were just talking about the January files. Currently I have a flow that moves the file into the January folder but it's a static one meaning it does not account for future folders created. I will try your suggestion and if I run into a bump I'll let you know. I am new to flow but I am learning. Thank you again for your help. 

[vxo15]

Hi, 
I am needing to create a flow just like yours, where flow creates a file based on a template every first of the month. Currently the flow over writes the file but I want to keep a history of the past run. Could you show me how your template was created? I would really appreciate it. 
@Alex_AR 

[Alex_AR]

Here you go....Let me know if you have questions

 

 

 

 

[Amanthaper]

Hi@vxo15 

If you add utcNow() to the end of your newly created file it will always create a new unique file and not overwrite the past runs (e.g. mynewfilename_2020-10-13T15:57:23.9722674Z)

------------------------------------------------------------------------------------------------------
If my post helps you with your problem or answers your question, please mark it Solved or Answered. This helps anyone with similar challenges. If you like my response, please give it a Thumbs Up.
------------------------------------------------------------------------------------------------------

[Alex_AR]

👍 

 

[vxo15]

@Alex_AR Thank you!