Why is HTML body messed up in Power Automate send email v2 ?

[@UmightBwrong]

You are a lifesaver! This destroyed HTML code I spent a lot of time working on and have been losing my mind trying to figure what is happening. Thank you!

[@nickmyron8284]

You and this video are AMAZING!! I am not a programmer or coder but was simply trying to have Power Automate send an email with information from MS Form. I added and between the dynamic contents and it was working yesterday. Today it was all cleared up and it would not save if I added it again. The added information shows up on the older editor/designer but not the new one. Even it is visible on the older editor, the color still shown as black text. Of course your solution corrected all of that and more...Thank you again!

[@mariannastahl4174]

Thank you for this. I will definitely be including this process from now on with any email content. Especially since I just found out that this issue has become much worse with the New designer function. I must have corrected the rich text several times in the New designer only for it to keep screwing everything up. Much easier to manage it all using HTML code and a variable.

[@stefwanders1005]

The new designer is even more horrid when working with html in email

[@JasperVandierendonck]

Thank you!! After hours trying to get html code work, this worked in a second.

[@StephanieLouis-kn3dg]

Thank you for sharing this tip. I have been suffering through recreating the email body each time I had to make a change. I will give this a try.

[@gfimotavideos458]

Thanks for posting. I was just starting to get frustrated with this issue and thankfully Google found this video.

[@arnevandenbussche7406]

Crazy this didn't get fixed yet. This helped me and saved a lot of manual work

[@learningeachday]

Thank you so much. Like many others here, I was pretty frustrated with this whole html stuff. I learned html and then kept being so confused wondering why html tags were getting added where I hadn't added them before. I will try the variable route.

[@learningeachday]

Update: variables are working like a dream! Thank you again for the life skills imparted.

[@Shmank]

Brilliant! So happy I found your video tutorial on this.

[@NeedMoreTank]

Not all heroes wear capes! Thank you so much for this video!!

[@TheMarketingPerson]

Alireza is king... Thanks again

[@ssccservlearn]

FYI for anyone who landed here for the same reason I did - this works in the Comment field of the Forward an email (V2) action. Big help!

[@HamidRezaZeinali]

That saved my Time a lot Thank you Alireza

[@somasekhararchakam3825]

Thanks for the video..struggled a lot to fix the issue finally got it

[@sonjaschrey5654]

Hello, my PowerAutomate received an update recently and now the "send email V3" doesnt exist anymore. It is just "send email". However the problem I have now is, that I cannot format it at all. There are options like formates Headlines, font, etc. but in the moment i write sth in, I cannot change the format. At the beginning I can, but afterwards not. Can you help me? The emails that arrived look so awfull, which huge space in it, although there is no space in it when I wrote it in power automate. THANK YOU 🌺

[@miss_mann2402]

Excellent! Thank you Alireza. - Monique

[@danielrumbak2530]

Beautiful! Thank you Alireza!

[@Angela-iq3ky]

Great video. This has help to resolve my issue!

[@aleksei_12_24]

You realy helped me out. Thank you!

[@StephV272]

Question: If I have multiple email signatures in Outlook, is it possible to dynamically select one of those signatures in an email response, based on a trigger? I couldn't find any option to select a "signature" in the email action. Thanks!

[@RhondaatWork-z3g]

Do you know if there is an idea open to resolve the need for this workaround? I expected to be able to do all the formatting in the Editor but as we know, it messes subsequent runs up when you switch to the Source viewer. Thanks for the helpful tip!

[@AlirezaAliabadi]

Try public shaming Microsoft. Sometimes it works.

[@StephV272]

Fantastic explanation, thank you!

[@spen2431]

Great tip. Thanks for sharing 💥💥

[@franknielsen3219]

Nice video. Most of the times I just use a Compose action, think the result is the same, but nice explaining 👏👏

[@AlirezaAliabadi]

It does. The only reason I avoid compose is that I'd rather see a meaningful variable mane in my e-mail body than a label reading "Output".

[@coreymcelroy4878]

Thank you so much! Having the same issue in V3. I can change the HTML code and as soon as I save it the code literally reverts back. So annoying.

[@victorionescu7653]

Thank you Alireza!

[@mikemakesmaps]

noob here.. this has been driving me nuts!! Thanks so much. I do have a problem - formatting is as expected in Outlook, but not when sent to gmail. Any suggestions?

[@AlirezaAliabadi]

I don't even have gmail account. Sorry 😐

[@mikemakesmaps]

@@AlirezaAliabadi Ha, ok i'll keep searching... FYI the formatting stays on both email clients when using the email v2 editor - maybe that's the additional formatting they are trying to capture

[@pawekubicki4860]

Thanks! works like a charm

[@brunoiadocicco7614]

Thank you for sharing!

[@lxz86]

put the hyperlink in a variable before send it to the outlook(v2), got it.

[@AutomationDose4U]

Hi Alireza, thanks for sharing your knowledge. Is it possible to export 25k items from sp list to excel in one go (without loop). Thanks 👍

[@AlirezaAliabadi]

I don't see a problem with that. Just open the list in SharePoint and click on Export -> Export to excel

[@AutomationDose4U]

@@AlirezaAliabadi Thanks for quick reply. But jst to let you know. I have one library where my Excel template is there which contains charts and tables. Which I am refreshing using office script (calling from power automate). And my Excel list data changes everyday and I need to share report daily after refreshing data. I faced throttling excel connector issue. So jst confirming is it possible to dump entire SP list to existing Excel file. Thank a very much for your reply.

[@AlirezaAliabadi]

@@AutomationDose4U not with power automate directly. You need third party components like encodian.

[@saibot293]

I am still getting the link as the whole URL

[@AlirezaAliabadi]

Check your HTML.

[@JustindeVantier]

Change the opening and closing p tag to a div and the issue goes away.

[@AlirezaAliabadi]

I have tried that. It is hit or miss. The problem is that most of the time your e-mail is a lot more complicated than a single hyperlink.

[@jorgedavidambrocioventura9196]

gracias !!