Save email attachment to SharePoint folder based on name

[dbruneau]

I would like to save email attachments to specific SharePoint folders based on the attachment name matching the SharePoint folder metadata. 

The attachments I receive contain a code in the name of the attachment. I want each attachment saved to their corresponding folder in SharePoint based on that code. I'm using a document library with document sets (folders) in SharePoint that contain the matching metadata.

Attachment example: 1234 ABCD Name.docx

Sharepoint example: Report ID = 1234

I want the attachment to be saved in the folder with the matching "Report ID".

Thoughts? Questions?

[v-yamao-msft]

Hi @dbruneau,

Do you want to create folders based on the attachment name?

Do all the attachments have the same name format?

I have made a simple test on my side and it works fine. Please take it for a reference.

The attachment name is formatted as 1234 ABCD Name.docx. A function substring will be used to get the Report Id from the name. The code used in the Folder path is:

substring(items('Apply_to_each')?['Name'],0,4)

If the attachments have the same Report Id, they will be saved in the same folder, otherwise, a new folder will be created.

Please try it on your side.

Best regards,

Mabel Mao

[dbruneau]

The folders have already been created in advance. The folders have a metadata field called "Report ID".

The attachments start with the Report ID and then have a space after. The length of the Report ID can vary. In my example, (1234 ABCD Name.docx) ABCD would be the Report ID.