Answered

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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

NathanAlvares24 1,714 Moderator on at

Like (1)

Report
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.

Was this reply helpful? Yes No
HeHo12345 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like (1)

Report
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.

Was this reply helpful? Yes No
HeHo12345 14 on at

Like (1)

Report

It worked perfectly, thank you so much!

Was this reply helpful? Yes No