Answered

Attaching multiple files to an email

(0) Share

Report

Posted on by V_Tiger

Hi there,

I created a workflow to automatically attach all files in a SharePoint folder to an email whenever I save a specific file in that folder. Here's an overview of my flow:

After running for 14 minutes, the flow failed with this error message:
"Action 'Send_an_email_(V2)_2' failed: Unable to cast object of type 'Newtonsoft.Json.Linq.JValue' to type 'Newtonsoft.Json.Linq.JObject'."

Does anyone know how to resolve this issue?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Take a look at Step 4 in this blog post I wrote. It shows how to append a file to an array variable so you can use the array in an email.

Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

Tomac 4,061 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @VT-15081731-0

You'll need to adjust your flow. You can't attach files by file identifier - you have to attach the whole file to an email.

Before your Append To Array action, use a Get File Content action with that file identifier to get the file. Then append it to your array using this array format:

{ "contentbytes": { "$content-type": "@{outputs('Get_Attachment_(V2)')?['body/contentType']}", "$content": @{outputs('Get_Attachment_(V2)')?['body/contentBytes']} }, "Name": "@{outputs('Get_Attachment_(V2)')?['body/Name']}" }

Note that you'll need to adjust the dynamic content in this example to match your flow's actions. My example uses files gathered from email attachments, you'll be using the outputs of your Get File Content action.

Was this reply helpful? Yes No
V_Tiger 32 on at

Like (1)

Report
Copy link

Link copied!
Tomac, thank you for your input. I have modified my flow as per your instructions. However, when I attempt to enter the expression you provided in the "Expressions" tab, adjusted to the actions I'm using, I receive an error message indicating that the expression is invalid. Below is the adjusted expression and a screenshot of the updated flow. What do you see I'm doing wrong?

{ "contentbytes": { "$content-type": "@{outputs('Get_file_content')?['body/contentType']}", "$content": "@{outputs('Get_file_content')?['body/contentBytes']}" }, "Name": "@{outputs('Get_file_content')?['body/Name']}" }

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Try the following instead. When you do the Get File Content it provides the already formatted Content. Its pickable from the Dynamic content dialog. And make sure not to put quotes around the file content, only around the name.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Verified answer

Tomac 4,061 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @V_Tiger

That code snippet was formatted to copy/paste directly into the Value field, the expressions would be automatically inserted. This is because the entire snippet isn't an expression, but there are several individual expressions contained within it.

In your comment below, the green parts are the expressions. The rest is plain text for the value. If you want, you can edit out the green parts (expressions) and then add them into your value in the right places.

Now that we can see all of your flow's actions the snippet can be customized to your flow, so here's a snippet you can copy/paste into your Value field with the dynamic content already customized to your flow:

{ "contentbytes": { "$content-type": "@{triggerOutputs()?['body/{ContentType}']}", "$content": @{body('Get_file_content')} }, "Name": "@{triggerOutputs()?['body/{FilenameWithExtension}']}" }

2 people found this reply helpful.

Was this reply helpful? Yes No
V_Tiger 32 on at

Like (1)

Report
Copy link

Link copied!

@Pstork1, I tried the code you provided in your last comment. Although the email was sent with attachments, the attachments were not in the expected formats (i.e., ".xlsm" and ".xlsx"). They appeared without any format. (Please see the screenshot below). On a positive note, the code provided by @Tomac worked as expected. Thank you both for your help!

Was this reply helpful? Yes No