Unanswered

Problems making a draft email from html

(0) Share

Report

Posted on by Stonker

Heya,

Beginner Power Automate user here, I'm trying to extract data from an email to put in a new draft email ready to be sent.

The outputs(OT/NAME/USER) I place back in a existing HTML to fit the format.

This all works well until I get to the http request, to make the draft email.

using this guide:

create a draft outlook - from damobird365

I'm able to make a plain text draft just fine, but with the output (HTML BODY) gathered it comes up with the following error:

Unable to read JSON request payload. Please ensure Content-Type header is set and payload is of valid JSON format.

I've looked around and it seems the quotes/or the HTML format might be the problem, but any method i've tried the replace the quotes don't seem to work for me.

Passing HTML content as a variable to build a JSON

Where in the flow do I exactly replace this? I've tried:

replace(variables('HTML_body'), '"', '"')

I understand the basic replace function, but whenever I use the replace function the content comes up as empty.

Where in my current flow should I change the HTML in my flow, or should I apply a different flow entirely.

I have the same question (0)

All responses (8)

Answers (0)

harshdeol 412 Moderator on at

Like (0)

Report

Re: Problems making a draft email from html

Hi @Stonker ,

Can you please share the screenshot of what you are passing in the content. I believe it is Email Body, Correct? Can you please share the screenshot of HTML Body, please.

-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.

Thank you,
Harsh Deol

Was this reply helpful? Yes No
Stonker 10 on at

Like (0)

Report

Re: Problems making a draft email from html

Hi Harsh,

Thanks for your quick reply to my post, the HTML input I'm using is quite long. over 60000 character and seems to exceed the number characters allowed in a private message, maybe that's part of the problem?
Should I only be adding HTML body to content: " "
start of the HTML Body:

I

Was this reply helpful? Yes No
VictorIvanidze 12,839 on at

Like (0)

Report
Re: Problems making a draft email from html

Try to use
replace(variables('HTML_body'), '"', '\"')

Was this reply helpful? Yes No
Stonker 10 on at

Like (0)

Report

Re: Problems making a draft email from html

Hi Victor,

I get the following error:
Did is misplace this command?

Was this reply helpful? Yes No
harshdeol 412 Moderator on at

Like (0)

Report
Re: Problems making a draft email from html

Hi @Stonker ,

In the expression of Compose Action, you're using the variables('HTML_body') instead of output of HTML body.

Please try by replacing this with:

outputs('HTML_body')

-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.

Thank you,
Harsh Deol

Was this reply helpful? Yes No
Stonker 10 on at

Like (0)

Report

Re: Problems making a draft email from html

Hi Harsh,
Thanks for your reply, now it does go through and replace the Quotes:
But it still gives the same error:

Was this reply helpful? Yes No
VictorIvanidze 12,839 on at

Like (0)

Report

Re: Problems making a draft email from html

Don't use empty Subject. Also please show the whole JSON request payload.

Was this reply helpful? Yes No
Stonker 10 on at

Like (0)

Report

Re: Problems making a draft email from html

In an attempt to change/hide data being input from the e-mail, something else broke:
I get this error now even with the emails that worked before, mind you I only changed the triggered parameters a bit (from requirement, repair it to previous parameters doesn't fix this error.

It currently gives the following error:
The execution of template action 'For_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/value']' is of type 'Null'. The result must be a valid array.

Rebuilding the flow and not tampering with the trigger parameters seems to help.
Regardless I've sent you the slightly edited HTML in a private message, hope this helps 🙂

Was this reply helpful? Yes No