Power Automate

Trouble removing HTML tags in the email

(1) Share

Report

Posted on by Bala Periaswamy

Hello,

I created a flow to send email with ADO Query results. The flow has the following steps,

Manual Trigger
Get Query Results from ADO
Create a HTML table
Compose (replacing the tags, removing nulls and formatting the table)
Send Outlook Email

In the Compose action, as the first step, I am replacing the HTML tags using the following statements.

replace(replace(replace(coalesce(outputs('Get_ADO_Results')?['Description'],''),'<div>',''),'</div>',''),'<p>','')

replace(coalesce(outputs('Get_ADO_Results')?['Description'], ''), '<[^>]+>', '')

The email that I receive still has the HTML tags (<div>, <p> etc.) for the Description field, it looks messy and unreadable.

Can you please help me understand what I am missing?

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Have you considered using html to text action? It's pretty reliable.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Bala Periaswamy 6 on at

Like (0)

Report

Hi,

Thank you for your response!

I tried that; I added a step 'HTML to text' after 'Convert to HTML table', then in the email the table data is all clubbed as one string (as follows). I don't know how to format it back to a tabular format. Any suggestions?

Note: After HTML to text action, the query results look like this

IDTitleDescriptionBusiness ValueReleaseDate

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post trouble removing html tags in the email in this category building flows from 10/18/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 2 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
Bala Periaswamy 6 on at

Like (1)

Report

Hello,

Thank you for checking! 😊

As I mentioned in my previous post, I tried adding a step 'HTML to text' after 'Convert to HTML table', then in the email the table data was all clubbed together as one long string like this - IDTitleDescriptionBusinessValueReleaseDate.

I updated my flow to format the results from my ADO query into a HTML Table as follows and it works.

Thank you!

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Great to hear! Tom

Was this reply helpful? Yes No