Unanswered

Save email PDF attachment to the current month-named folder in SharePoint

(0) Share

Report

Posted on by jeffchapmanjc

My department's shared mailbox receives 9 automatically generated emails each day with a single PDF file in each email. These 9 emails and attachments represent 9 different buildings. The email's subject and its PDF attachment are similarly named, according to the building. There are 9 SharePoint folders which these 9 files need to be uploaded to, but within each of these 9 folders are 12 subfolders, one for each month of the year. How can I get Flow to save each of these 9 PDF email attachments to their respective current month's subfolder, and have that continue throughout the year unattended? If necessary, I can rearrange the SharePoint folders so the month folders are after the building name folders rather than before.

Thanks for the help! I've scoured this forum and the net looking for this scenario without success.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Flow step 'SharePoint Create File' there is a property called 'Folder Path'. Here you need to set the below expression

utcNow('MMMM')

This is will return the current month name.

If you any further help let me know.

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @jeffchapmanjc

Do you need any futher help in this?

Was this reply helpful? Yes No
ShortRave 3 on at

Like (0)

Report
Copy link

Link copied!

@abm I already have a full set of month-named folders I need to funnel these month-named files into each day. They are named as follows, "01 January", "02 February", and so on. So if I were to include your suggestion in the "Folder Path" section, can you say how it would need to be modified? It currently looks like this:

/Shared Documents/2019/11 November/Allenmore Hospital Daily Census Report

So I'm thinking your suggestion would look like this (please correct me if not):

/Shared Documents/2019/11 utcNow('MMMM')/Allenmore Hospital Daily Census Report

I don't mind having to create 12 flows (one per month) for each of the 9 file uploads I need to run this automation on. I just want to ensure it works for the month changeovers. Thanks for help!

Was this reply helpful? Yes No