Draft Email in Power Automate Shows Tags Instead of Plain Text

(0) Share

Report

Posted on by Community member

Hi Team,

I’m using Power Automate to draft emails using data from an Excel file.

However, when the email is drafted, the body shows <p> tags automatically, even though my Excel file only has plain text and no HTML tags.

Can you please help me understand:

✅ Why Power Automate is adding <p> automatically in the drafted email body?

✅ How can I avoid these <p> tags and ensure my drafted emails display as clean, plain text?

Thank you for your help!

below is my flow.

In my flow the compose is used to split my recipient in To and Cc as I have multiple user.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
Based on what I see, the data in the Excel spreadsheet must be formatted with the HTML tags. Since you do not have the Outlook action in HTML mode, those tags get rendered as plain text. Do this:

Delete the Body value in the Outlook action.

Click on the </> button in the Outlook body toolbar.

Insert the Body value from Excel.

This puts the Outlook action into HTML code view, and when the e-mail is sent the tags from Excel should then be rendered correctly in the e-mail.

Was this reply helpful? Yes No
Community member 25 on at

Like (0)

Report

@David_MA Thanks
Much helpful

however just a question
why im not able to edit to my font and Size
it is default to Segoe UI 12

also while saving in draft it is not editable i need to click Switch to HTML

there is any solution to fix this?

Instead of plain txt
how can i add to HTML?

after i clicked on <> im not getting the tag but im not able to edit the body in the draft
any solution please?

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

When you switch to HTML mode in the Outlook action, it expects you to format the entire message using HTML. If you want to define the font and size, you can either add that to the HTML coding you are doing in Excel, or add style tags before the Excel body tag in the body of the e-mail.

I've tried to post an example in this post, but for some reason it will not post if I include HTML even if I add it with the code insert tool. Hopefully a screen shot will allow this to post:

Was this reply helpful? Yes No
Community member 25 on at

Like (0)

Report

Thank you much helpful :)

Was this reply helpful? Yes No