Creating a folder and adding attachments received on mail to the created folder

[HeHo12345]

Hi,

When I get an email from a specific sender, I need the flow to automatically create a folder in Sharepoint based on subject of the mail and also save the attachments in the created folder.

All help is much appreciated

[NathanAlvares24 · Accepted solution]

Hi @HeHo12345 !

Try this flow.

Flow function:

1) It will get emails from a specific sender which needs to be specified in the From section of the trigger action, "When a new email arrives (V3)". Expand the advanced options to do that. Even put the yellow highlighted ones as 'Yes' since you need only attachments.

Additionally for this trigger, I have added a trigger expression so as to only receive emails which do not have the subject as empty. Check below:

Expression:

@not(empty(triggerOutputs()?['body/Subject']))

2) Then Create a new folder based on the subject name (from the trigger). Make sure that you already have a SharePoint document library in your SharePoint for this to happen. Also in the expression we make sure that it follows the rule of naming of folder convention. Like this: 

Expression:

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(triggerOutputs()?['body/subject'], '"', ''), '*', ''), ':', ''), '<', ''), '>', ''), '?', ''), '/', ''), '\', ''), '|', ''), '&', 'and')

3) Get the attachments from the mail since you can't just attach it directly to the folder. It will collect the data and use that data in the next action, Create file. This will loop through each attachment. See below:

Input:

Output:

I hope this helps.

[HeHo12345]

It worked perfectly! Much appreciated.

The subject of the mails can be quite long, is there a way that the whole subject wont show?

Ex subject:

 xxxxxxx xxxx xxxxxx xxxxxxxxx x xxxx xxxxxx xxxx xxxx xxxxx xxxxxxxx (OSVC-240625081540371 / OSVL8FB2BD)

The "x" mimics the number of letter typical in the subject. I would like that only "OSVL8FB2BD" to be showcased. This number/code is unique for each mail, and are always placed at the end after the dash in the paranthesis.

[NathanAlvares24 · Accepted solution]

Hi @HeHo12345 !

Instead of this:

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(triggerOutputs()?['body/subject'], '"', ''), '*', ''), ':', ''), '<', ''), '>', ''), '?', ''), '/', ''), '\', ''), '|', ''), '&', 'and')

Replace with this code:

trim(substring(triggerOutputs()?['body/Subject'], add(indexOf(triggerOutputs()?['body/Subject'], '/'), 1), sub(indexOf(triggerOutputs()?['body/Subject'], ')'), add(indexOf(triggerOutputs()?['body/Subject'], '/'), 1))))

Output:

I hope this helps.

[HeHo12345]

It worked perfectly, thank you so much!