Answered

Issues with Multiple attachements to email using array with OneDrive For Business.

(0) Share

Report

Posted on by SPOFLOW

I'm creating a flow that will send multiple attachments from my onedrive for business account. I've found threads similar to mine and followed through with the solutions but am falling short on getting this to work once it tries to send. Each attachment has data.

Here is the Flow

Error occurs when Email is being Sent:

{
 "status": 400,
 "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.\r\nclientRequestId: 07fde98a-7f5a-4a19-9846-a391b50567df",
 "error": {
 "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'."
 },
 "source": "office365-wus.azconn-wus-01.p.azurewebsites.net"
}

What do you think is going on ?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (2)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SPOFLOW

See this post

https://powerusers.microsoft.com/t5/General-Power-Automate/Multi-attachment-email-Error/td-p/369305

Make sure use

"ContentBytes": base64(filecontentdynamiccontent)

Thanks

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!
"Please provide required input parameters 'To', 'Subject' and 'Body'"
So... the problem is not the attachments, right?
Hope this helps

Was this reply helpful? Yes No
SPOFLOW 51 on at

Like (1)

Report
Copy link

Link copied!

When I tried that and pressed the "ok" button, i get the error "The Expression is invalid.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SPOFLOW

Let me run my flow. Let you know soon.

Thanks

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SPOFLOW

So the issue is you are not showing the correct dynamic mappings?

The base64 should solve this.

Here is my test flow.

See the expression I set.

base64(body('Get_file_content_using_path_2'))

You need to set the right name of your Get File Content using path.

Here is my run result

Thanks

Was this reply helpful? Yes No
SPOFLOW 51 on at

Like (1)

Report
Copy link

Link copied!

getting error
my scripts look like this:

my expression for this one is
base64(body('VP EQ-Weekly TC Report-contents'))

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @SPOFLOW

Hi @SPOFLOW ,

We are getting closer now 🙂

Inside your expression use underscores for the spaces of your variable name.

VP_EQ-Weekly_TC_Report-contents

base64(body(VP_EQ-Weekly_TC_Report-contents))

Let me know how it goes.

Thanks

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @SPOFLOW ,

We could find the solution to this issue in the comment of this blog:

https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

You could click peek code to get the expression of the file content and add .$content after it.

Expression reference:

body('VP_EQ-Weekly_TC_Report-contents').$content

Please take a try again.

Best Regards,

Was this reply helpful? Yes No
Suggested answer

MC-31071729-0 2 on at

Like (0)

Report
Copy link

Link copied!

Can you please try use below JSON while appending the value to AttachmentArray variable. It worked for me for different file attachments in one single email.

Suggested JSON:

{
"Name": "@{items('Apply_to_each')?['DisplayName']}",
"ContentBytes": {"$content":"@{body('Get_attachment_content')['$content']}",

"$content-type":"@{body('Get_attachment_content')['$content-type']}" }
}

Was this reply helpful? Yes No