Answered

Saving and renaming email’s attachment to a SharePoint library

(0) Share

Report

Posted on by mmx9000

Created my first PA Flow, and it seems to work ok, but the files extensions are missing. It’s a very simple flow: Saving and renaming email’s attachment to a SharePoint library. The attachment gets saved and renamed… but it loses the file extension.

I have searched the Community, a found one post like what’s happening to me. But the solution of adding .pdf at the end of the File Name doesn’t seem to work. It created the file with a .pdf extension, but I can’t be read.

The email’s attachments are .pdf, so I’m not trying to cover the attachment into pdf, just want to rename it, and keep it as pdf.

This is the post I was referring to:
https://powerusers.microsoft.com/t5/Using-Flows/Missing-attachment-file-extension-when-creating-file-in/m-p/1348873

Screenshot of my flow:

Thanks, in advance!

Categories:

Using flows

I have the same question (1)

All responses (8)

Answers (1)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@mmx9000

If you add a Get Attachment action in your loop and reference the Name in Dynamic Properties under Get Attachment you will have the full file name including the extension.

Was this reply helpful? Yes No
mmx9000 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you for answering Scott. I tired adding the (Get Attachment v2) and the (Compose) but the Flow fails when I test it. I must be missing something at the (Get Attachment v2). I also wanted to ask; do I still use the (Create file) right?

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (1)

Report
Copy link

Link copied!

Hi @mmx9000 ,

Hope this helps you ,

Best Regards,
VK

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
mmx9000 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you VK. What you subjected works for me too... But I need to have the attachments rename with the email's subject line.

Thank you!

Was this reply helpful? Yes No
Verified answer

cbasolutions 9 on at

Like (1)

Report
Copy link

Link copied!

To do what you want to do, you can run the an Expression on the name. I would also suggest replacing any spaces in the name in case there are unwanted characters at the end.

concat(replace(triggerOutputs()?['body/subject'],' ','_'),'.pdf')

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (1)

Report
Copy link

Link copied!

Hi @mmx9000

Hope this helps

If you want both subject and attachment name as file name , use this instead of val2 in file name:
concat(variables('val2'),'_',split(items('Apply_to_each_2')?['name'],'.')[0])

Best Regards,
VK

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
mmx9000 12 on at

Like (0)

Report
Copy link

Link copied!

Adding this Expression worked, thank you! the file gets rename with the subject line and it also opens just fine.

Was this reply helpful? Yes No
mmx9000 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks everyone for the help! really appreciated it. 🤗 Thanks!

Was this reply helpful? Yes No