Hello.
Is it possible to create a flow that automatically saves attachments for a month, and when a new month arrives, creates a new folder and stores the new ones there? Example; in november there will be 10 attachments, and in december there will be 11. Can these be divided into folders automatically? and can this flow continue to create folders based on the month the email was received?
Solved! Go to Solution.
Hi @royaanon
According to your description, I set up a simple flow, you can refer to the screenshots below to see if it helps.
Expression:
The file will be saved in 2021-11(No need to manually create the '2021-11' folder, flow will be created automatically )
If you receive the email in December, the attachment will be saved in '2021-12' folder.
Hope the content above may help you.
Best Regards
Hi @royaanon
- For getting the month name you can make use of below in Expressions
formatDateTime(utcNow(),'MMMM') which gives the result November
- I am assuming you want to create folders in the Windows file system (and not on Sharepoint or OneDrive)
In that case take a look at this link for the File Systems Connector
Haven't tried, but in that link it says...
- Select the Action to Create File.
The folder path specified will be created if it does not exist.
Hi.
I want to create a folder in OneDrive, November, for attachments recvived in November, and folder for December for attachment recvived in Desember, and so on.
Im using Kutools now, but if i can use flows, i prefer that:)
For creating folders you can take a look at the Solution marked in this post
https://powerusers.microsoft.com/t5/Building-Flows/Create-a-folder-in-OneDrive/td-p/318736
Thanks, but creating folders, is ok, but the problem is when is got to make folders on months when recvive mail. Has tryed to set up a flow, but no luck 😛 .
Maybe my expectations was to high:)
Hi @royaanon
If you want to create folders when an email is received then use the "When an email is received" trigger of Power Automate.
You can check any of the in-built templates
Save email attachments to a SharePoint library and receive a notification
Save new email attachments in SharePoint and add a row to Excel
So when the incoming of email is triggered do the folder creation part.
Hi @royaanon
According to your description, I set up a simple flow, you can refer to the screenshots below to see if it helps.
Expression:
The file will be saved in 2021-11(No need to manually create the '2021-11' folder, flow will be created automatically )
If you receive the email in December, the attachment will be saved in '2021-12' folder.
Hope the content above may help you.
Best Regards