Answered

Email Attachments Do Not open

(0) Share

Report

Posted on by CU26081656-0

Hello,

i have a flow that scans through a SharePoint list and sends an email if the Date is today in the given time provided in a Date/Time column.

Users could attach items to the different list items.

I have managed to send out emails with the flow in the given times but I have two issues:

1. Email attachments are not opening in the sent emails

2. If there are more than one emails to be sent then the attachments from the first item is added to the second email.

I have tried the base64(dynamicfilecontent) in the append to array variable after the ContentBytes, but the result was the same.

Many thanks for your support in advance!

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

1) Make sure the display name you are using when building the attachments array contains a file extension. Depending on the attribute you are using it can be the file name without the extension. That can cause a problem when trying to open the file.

2) At the top of your Yes side of the condition make sure you set the attachments array equal to an empty array. Otherwise it doesn't get overridden if there are attachments in a previous item.

Was this reply helpful? Yes No
CU26081656-0 21 on at

Like (0)

Report

Many thanks for your note!
#1 Please find the result of the Append to array variable. Based on that it seems that the file name is correct but the content is not copied.

#2 is solved now with the provided solution, Thank you!

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
The ContentBytes is more than the Content of the Attachment. There is also a content type setting. You should be using the Body of the Get Attachment Content rather than the Attachment content.

When you are done ContentBytes should look more like this.

"ContentBytes": { "$content-type": "application/pdf", "$content": "JVBERi0xLjYNJeLjz9MNCjE0MiAwIG9iag08PC9G....

Was this reply helpful? Yes No
CU26081656-0 21 on at

Like (0)

Report

I can not select the Body of the Get Attachment Content on the Attachment content

Was this reply helpful? Yes No
Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (2)

Report

What you see as Attachment Content is the Body of the Get attachment. But the content you are getting doesn't include a content type. That's why it won't open. How are the attachments added to the SharePoint list? That may be where the problem resides. But the reason they won't open is because you have the content, but the system doesn't know what the content is since there is no content type.

Was this reply helpful? Yes No
CU26081656-0 21 on at

Like (0)

Report

Hi,

yes this was the issue, many thanks for your support!

Was this reply helpful? Yes No