Answered

Sending Email via PowerApp Issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

When sending an email via PowerApps using templates we have in Dynamics, it's sending the XML to Outlook and not the HTML of the email. How can I get that to pass back the HTML?

See screenshot.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your Office365.SendEmail() formula?

Based on the screenshot that you mentioned, the result the emailtemplate.Selected.Body formula returned is a XML structure data (<?xml vresion = "1.0" ... >) rather than a valid HTML strucure data.

If you want the XML structure data to be rendered as a valid HTML strucure data in your email body, I afraid that there is no way to achieve your needs in PowerApps currently.

As an alternative solution, you could consider remove the XML tag from the result the emailtemplate.Selected.Body formula, then type the extracted text within your Office365.SendEmail() formula.

I have made a test on my side, please take a try with the following workaround:

Set the OnSelect property of the "Send Email" button to following:

Office365.SendEmail(
User().Email,
"PowerApps Email Subject",
substitute(
Substitute(emailtemplate.Selected.Body, "<?xml version=""1.0"" ?><xsl:stylesheet xmlns:xsl=""http://www.w3.org/1999/XSL/Transform"" version=""1.0""><xsl:output method=""text"" indent=""no""/><xsl:template match=""/data""><![CDATA[", ""),
"]]><xsl:choose><xsl:when test=""systemuser/fullname""><xsl:value-of select=""systemuser/fullname"" ... >",
""
),
{IsHtml: true}
)

Note: The <?xml version=""1.0"" ?><xsl:stylesheet xmlns:xsl=""http://www.w3.org/1999/XSL/Transform"" version=""1.0""><xsl:output method=""text"" indent=""no""/><xsl:template match=""/data""><![CDATA[ represents the XML tag before the HTML data in your emailtemplate.Selected.Body formula result.

The ]]><xsl:choose><xsl:when test=""systemuser/fullname""><xsl:value-of select=""systemuser/fullname"" ... > represents the XML tag after the HTML data in your emailtemplate.Selected.Body formula result.

Please consider take a try with above alternative solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for the feedback! However, that did not work. I also tried something similar myself with the following expression to remove the xml and it didn't render the html (just removed the xml text and displayed html text):

Office365.SendEmail(inputTo_1.Text, inputSubject_1.HtmlText, Right(inputBody_1.HtmlText, Len(inputBody_1.HtmlText)-177),{Importance: "Normal"})

Any other thoughts?

Thanks.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share more details about the extracted HTML text that you mentioned?

Please consider modify your formula as below:

Office365.SendEmail(
inputTo_1.Text,
inputSubject_1.HtmlText,
Right(inputBody_1.HtmlText, Len(inputBody_1.HtmlText)-177),
{
Importance: "Normal",
IsHtml: true /* <-- Add this formula */
}
)

Please consider modfy your formula as above, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No