You’re offline. This is a read only version of the page.
21
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!
Hi,
yes this was the issue, many thanks for your support!
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.
I can not select the Body of the Get Attachment Content on the Attachment content
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.
Share
Report
All responses (
Answers (
"ContentBytes": {
"$content-type": "application/pdf",
"$content": "JVBERi0xLjYNJeLjz9MNCjE0MiAwIG9iag08PC9G....
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!
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.
#1
WarrenBelz
146,522
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,890
Most Valuable Professional
