Power Platform Community Forum Thread Details

Hello Everyone!!

Complete newbie to power automate - Hoping this is possible.

Every month i get 100s of service reports about different buildings that i need filed away.

They need to be filed within lots of subfolders and by month.

The reports(PDF's) will have different names but will always include the building number.

Can a flow be created that auto saves the reports when they enter my inbox and then moves and files the reports to the correct building subfolder by month? It would be a bonus if a folder could be created when the month ticks over. The building number could be used to identify which folder it should go to.

See below an example of the sub folders, reports and folder format.

Please note this is all on Onedrive.

Any help would be so greatly appreciated. Save me days of work a month.

Categories:

Building flows

@rhii10405

You can create a recurring flow (executes monthly) to create the folder the folder. e.g. on the 27th of every month, create the folder for the following month.
Solved: Create new folder in Power automate - Power Platform Community (microsoft.com)

Dynamically choose the folder name based on the current date using expressions UTCnow() and addtotime() expression:
How to add month(s) to a date in Power Automate (tomriha.com)

Then you can create a second flow triggered by when new email arrives. Again, when you create the file, you need to dynamically re-recreate the folder path using date expressions and extracting the building number from the file (assuming the building folders are named after the building number in the filename).