Unanswered

Send email from teams channel message (in HTML)

(0) Share

Report

Posted on by MVMar

Hi Guys, I have a rather simple flow, but I think there are some formatting limitations which prevent it from working

I'm using an email building tool (Unlayer) from which I export the full email in raw HTML code.
My plan was to post this raw HTML code into a teams channel and then this would generate an email.

Technically I've created the flow and it works fine for plain text , etc.
Unfortunately, when I post raw HTML code in teams it doesn't get converted into a nice looking email.

It sends the email, but I also receive an email with just HTML code.

Any ideas how I can convert this and make it work as expected?

I've been using power automate to send HTML emails many times, but apparently there's some formatting issue that occurs when the data is captured from the teams post.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @MVMar
I test it in my side , the return from Teams the Html will be differnt like this:
So we need to use the replace() function to replace these String to the right Html code.
We can use this code to covert the body/content:
replace(replace(replace(replace(variables('EmailBodyContent'),'<','<') , '>','>'),' ',' '),';<br>','')

You can also use a "Compose" action to check if the return contains Invalid HTML characters.Our ultimate goal is to replace the value returned by Teams with a valid Html code using the replace function.
Then we can use this Html String to send an email .

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @MVMar - You can try @v-yueyun-msft suggestion

Another quick tip would be to try "Convert HTML to TEXT" action.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
MVMar 36 on at

Like (0)

Report

Hi, @v-yueyun-msft
Thank you for getting back to me so fast.

Now I see what you mean.
I've compared the input (left) and output (right) and I understand what's wrong.

I tried your suggestion with the expression you gave me, but when applied, it completely breaks the HTML code, to the point where it's unusable. I assume there are a other replacements that need to be done in order to clean it enough to the point where it's useable again.

In the meantime, I noticed something else - in Teams I can add a code snippet and post that. Is there a way I can extract the clean, unaltered HTML code from that snippet and dump it into the email body?
I saw that it's added as an "attachment" but no apparent way to get the contents of the attachment.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi, @MVMar
Thanks for your quick response! Yes , the "When a new channel message is added" trigger will breaks the html code.As you can see in your screenshot, he converts '<' into '<' in Html, '>' into '>', space into ' ' and so on. I think we can indeed use the replace() function to re-extract the converted Html code, which is not insecure.

And as searched , i found no way to extract the code snipped from Teams in Power Automate.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi , @MVMar
I test it in my side .By another , i also test the Attachments in Teams Channel , i think this can also be realize it.
And this is my txt file:

As we can see the trigger return if you upload an attachment:

We can get the file content using the "Get file content using path" action.
And we can see the html will not break just has '\r\n' when the txt have a line breaks. We can replace it use this code:
replace(outputs('Get_file_content_using_path')?['body'],decodeUriComponent('%0D%0A'),'')
For this , you can refer to :
Solved: Split at \r\n\r\n - Power Platform Community (microsoft.com)

And then we can also get the correct html code to send an email.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
MVMar 36 on at

Like (0)

Report

This way it actually works.
I added some additional things to pick up the name, etc. but it works as intended.
Thank you!

Was this reply helpful? Yes No