Answered

Parsing the name of attachments in a mail

(0) Share

Report

Posted on by JesperTorp

So, im building this flow, where i have a mail with several attachments. These attachments needs to be saved in a sharepoint folder structure, based on the attachement's name. The attachment names are the names of our employees. The folder structure is build like this, on the first level we have folders names A,B,C,D.....X. Beneath each of these there are one folder for each employee, where the foldername are the persons full name.

So i want the attachment called "John Doe.pdf" to be saved in this subfolder: "/J/John Doe/". The attachment "Sarah John.pdf" to be saved in this subfolder: /S/Sarah John/". All these folders allready exists.

To accomplish this, i have tried to parse the filename for each attachment in the mail using the Substring() expression. This is where it fails, as i cannot get MSFlow to give me the attachment names as a type string i can work with, the "Attachment Name" is an object.

As seen here, i want to be able to use RegEx's to be able to tell flow, where to put each file, in the folder path.

Anyknow know if this is at all possible ?

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @JesperTorp,

I have made a test on my side and please take a try with the following workaround:

Add a "When a new email arrives" trigger, Has Attachment field and Include Attachments field both set to Yes.

Add a "Apply to each" action, input parameter set to Attachments dynamic content of the trigger.

Within "Apply to each" action, add a "Create file" action, specify Site Address and List Name. Folder Path field set to following formula:

/Reporting/substring(...)/split(...)

The substring(...) expression within above formula read as below:

substring(split(item()?['Name'],'.')[0],0,1)

The split(...) expression within above formula read as below:

split(item()?['Name'],'.')[0]

The File Name field set to following formula:

concat(triggerBody()?['DateTimeReceived'],'.',split(item()?['Name'],'.')[1])

The File Content field set to Content dynamic content of the trigger.

Image reference:

The flow works successfully as below:

Best regards,

Kris
JesperTorp 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, Yes, YES...that was E X A C T L Y what i needed, and it worked like a charm. Thx 🙂
NishantAgr 5 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-xida-msft ; @JesperTorp - Hi Both - This is really a helpfull post. Thanks to you guys.

I have a similar kind of requirement. We need to save the email attachments coming in our shared mailbox to sharepoint document library based on attachment name.

@v-xida-msft - Can you please help me out with steps. Please have a look at my scenario:
Suppose file name is IN_2019_02_07_Invoice.pdf
Let’s have sample librarie in the SharePoint site – Invoice
Once the file is received via the email, let’s move the files into heirarical folders, Invoice->IN->2019->02->07 these folders are based on Country Code/Current Year/Month/Date.. County code (IN, PO, BU, DE...) in File Name.
Also, moving files into folders based on year -> month will be ‘nice to have’ or even date wise within these libraries
Can we achieve this the way you have suggested to @JesperTorp. If yes please suggest expression & steps.
Can we achieve it on run time also, when email come it create the similar folder structure & save document there?
@v-xida-msft; @JesperTorp - All suggestions are open. Please let me know how can i do this.

Thanks in advance !