Organize Incoming Email Attachments by Year and Month

(0) Share

Report

Posted on by sdharam_netl

I would like to create a Flow that:

1. Extracts an attachment from a shared mailbox email (Daily)

2. Creates a file on Sharepoint

3. Organizes the files based on Year and Month

4. Sends out an email with a shared link to the file

I have an existing flow that extracts the attachment, stores it in a folder and sends out the email with the shared link. However, the challenging part is now storing the files by year and month. For some reason the flow works, meaning that the files are stored by year and month and I get the email with the shared link, but for some reason the flow comes up as failed.

Complete Flow.jpg Year Month Folder Creation.jpg Organized File Created.jpg

When I ran the test, I renamed the initial Year folder that was created from 2023 to 203-old (and a similar test with month August to August-old) to see if it would create a new Year file. It did but it seems in part of the flow, 2023-old is being processed and creating an error.

Error in Flow

Thanks in advance everyone.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here how I would have done this:

Explicitly create folder before creating file, if folder already exists "Create new folder" won't complain and do nothing wrong, no need to check if it already exists.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
sdharam_netl 2 on at

Like (0)

Report
Copy link

Link copied!

Hi SamLed,

Thanks for the suggestion. If I create the folder explicitly wouldn't that mean all the files will be stored in that folder and not relative to the month and year the file was created? Ideally I need a flow that would use the month and year the file was created and automatically place it in the relevant year and month folder.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Come on, obviously you create the folder according to your dynamic contents, I set up like this to illustrate.
ie. use formatDateTime(body('Get_items')?[Created], 'yyyy')/formatDateTime(body('Get_items')?[Created], 'MM')
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No