Help needed with SMTP connector (send email v3) and adding an attachment variable

(0) Share

Report

Posted on by CU-19081228-9

Hello Everyone.

I have a flow that works like this:

1 - It lists files in a OneDrive folder and gets the file content.

2 - It adds them to an array called Images.

I then want to send an email with those images in the array and I use the SMTP Send Email (v3) action.

In the SMTP connector action, I have for sending an email, I attach the Images array under Attachments.

However, when I run the flow, and it gets to the SMTP action (Send Email V3) it fails, with the error:

The 'inputs.parameters' of workflow operation 'Send_Email_(V3)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'SendEmailV3' is missing required property 'emailMessage/Attachments/0/ContentData'.

For reference, if I use the Microsoft Outlook Send an email V2 action, and attach the attachments array in the same way then it works without issue.

How do I fix this so the email sends with the attached images from the array using the SMTP Send Email (v3) action?

Thanks so much for any help!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

An update on this.

I updated my flow to create a new variable for use with the SMTP action with the following parameters:

For ContentData for expression is body('Get_file_content')['$content'].

I then added this new attachment variable to the SMTP send email action.

The SMTP email action now sends the email, with the attachment, except the image files cannot be opened

Can anyone kindly point me in the right direction to fix this please?

Thank you so much!

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ianwuk ,

According to below thread, could you please try and modify ContentType to be emply (" ") then check the result?

Solved: SMTP connector - send email with attachment - Power Platform Community (microsoft.com)

{ "ContentData": @{body('Get_file_content')}, "ContentType": " ", "FileName": @{items('Apply_to_each')?['Name']}, "ContentId": "1" }

Best regards,

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

Thank you for taking the time to reply @v-jefferni

I updated the contents of the SMTP image array to look like this, making sure ContentType was empty.

The flow ran, but the end result was the same, the images were in the email, but they could not be opened.

Do they have to be decoded or something?

Alternatively, if the images don't work as attachments, how can I then embed the same images in to the email instead?

Any further advice is much appreciated - thank you!!

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

@DamoBird365 I am the guy who left a comment on your YouTube video about the SMTP email action.

I don't suppose you can help with my final piece of this problem?

Thank you so much!

Was this reply helpful? Yes No
tmiller888 16 on at

Like (0)

Report
Copy link

Link copied!

I can't verify specifically for the Send Email (v3) action, but I have a flow where I use the Send Email (v2) action and a Start and Wait for Approval action. I found that I need different formats for the attachments array for each of those to work.

For attaching to the approval, I use "Name" and "Content" as the names of the properties. For attaching to the email, I use "Name" and "ContentBytes" as the names of the properties. But, the value for Content and ContentBytes is the same: body('Get_attachment_content')

Was this reply helpful? Yes No
Teteriachenko 6 on at

Like (0)

Report
Copy link

Link copied!

You have to extract Media Type with "Get file metadata"

And afterwards images will be showing

Was this reply helpful? Yes No
PA-user 4 on at

Like (0)

Report
Copy link

Link copied!

The OneDrive version of "get file metadata" doesn't get the files "content data". The output "body" just lists all the properties of the file, not including the data.

Was this reply helpful? Yes No
PA-user 4 on at

Like (0)

Report
Copy link

Link copied!

@ianwuk,

Did you get this problem solved?

Was this reply helpful? Yes No