Send email with attaching file from SharePoint library document

[m_k]

Hello Experts,

I hope I can get quick assistance to the issue I'm facing when it strange to be happened when I'm following the correct steps as per my online search checkup.

I'm building a flow with the trigger “when a file is created or modified (properties only)” and then I did the following two actions to be able attach a file from the SharePoint library document to an email.

1- After the “when a file is created or modified (properties only)” I added the action "Get file content” and specified the Site Address, the file Identifier, and Infer Content Type=Yes.

2- After a valid condition, I added the action "Send an Email” and specified the Attachment name and Attachment content that is outputted from "Get file content”

The flow run successfully and I received the email with attachment; but the attachment file type is not valid or recognize and unable to open it.

Any advice…

[v-xida-msft · Accepted solution]

Hi @m_k,

Could you please share a screenshot of your flow's configuration?

Do you type the output of "Get file content" action within Attachments Name field of the "Send an email" action?

I think there is something wrong with Attachments Name field and Attachments Content field of the "Send an email" action within your flow. I have made a test on my side and please take a try with the following workaround:

• Add a "When a file is created or modified (properties only)" trigger.
• Add a "Get file metadata" action, specify Site Address and File Identifier field set to Identifier dynamic content of the trigger.
• Add a "Get file content" action, specify Site Address and File Identifier field set to Identifier dynamic content of the trigger.
• Add a Condition, click "Edit in advanced mode", type the following formula:

@not(empty(body('Get_file_content')))

• Within "If/yes" branch of Condition, add a "Send an email" action, Attachments Name field set to DisplayName dynamic content of "Get file metadata" action, Attachments Content field set to File Content dynamic content of "Get file content" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

[m_k]

Thank you very much @v-xida-msft

It worked now 🙂

I missed the action "Get file metadata" to get the attachment name. I used previously the file name from the trigger "When a file is created or modified (properties only)" as the attachment name and may be this is the problem.

[dwdwdwdw]

I've set-up a flow following the guidance on this topic (thanks!) and the file is delivered etc - however the file is missing the extension.

The type of file's im typically looking to send are .xlsx but i have also tested with .png and .jpg - all have the same issue.

I cant see how or where I can upload a screenshot. I'm using the dynamic content tag of 'name' for the AttachmentName, I cannot see 'DisplayName' as an available content tag. 

[Anonymous]

Hi,

I followed your instructions, but am not having success with sending the email. It's not failing, rather, I am told that the condition is not being met, so it is stopping on the email part. I have included a screen shot. Any help is greatly appreciated.

[Anonymous]

I  have been struggling to do just this Your solutional worked perfectly. Thank you!

[Hansn]

Excellent solution works well I attached it to the end of a "create document from List Item" then send the created document... All good ... Hans

[Tharma]

Hi @v-xida-msft,

I tried this solution, In Outlook Attachment content I could not pass File Content. No values is shown in dynamic variables.

Need help?

[Gtilam]

Hi Experts,

I've set-up a flow following the guidance on this topic. but it doesn't work when the new item is created on my list. Did I do anything wrong. could you please advise ?

Currently I experienced difficult when I am developing the flow for getting the attachments contained in the email notification when new item added on the list. 

Thank you

[jmon]

Thank you very much for your help. I have been trying to figure out why I can't attach the PDF that I just created from a Word Template from and list. 

I went through your steps but I don't have an advance option for the control. Sorry might be looking in the wrong location. 

I get this error when getting the PDF metadata. 

[741852]

I have been able to send an email attachment using the information discussed, but the attachment comes through as an unidentified file type rather than the file type it was uploaded as (PDF file).

Any ideas on how to resolve?

[mdiaz21]

Is there a way to do this without the share point list?

Regards,

[kristinamariz]

@v-xida-msft, this also works on my end! Thankie much!

[Ramiz]

The flow is working but the file extension is not coming. Any help in this?

[Anonymous]

Make sure you are passing the DisplayName or the Name parameter to the Attachment Name :

[DM4RSIU]

Good afternoon,

I have a similar situation.  However, I am unable to 

Add a Condition, click “Edit in advance mode”, type the following formula:

When I add the condition - is does not allow me that option. 

[Alexinux]

Hey!

I tried this and it works, but to a point. And I've followed other posts too about attaching documents for emails but I get the same result. The email body goes through but when I test it on myself or another user the attachment is in a weird format and gives me a warning pop-up for trusting the PDF I attached. Is something wrong with what I'm doing. I've attached the screenshots for better understanding.

Here is the Flow I'm using: