power automate remove html tags when adding body content into an excel table row

Question

when using power automate to convert an incoming email to an excel row, how do you remove html tags

Answer 1

To remove HTML tags from the body content of an incoming email before adding it to an Excel table row in Power Automate, you can use an Azure Function or a built-in expression in Power Automate. If you choose to use an Azure Function, you can create a function that processes the email body and strips out HTML tags. Then, you can call this function in your Power Automate flow.

Alternatively, you can use the replace() function in Power Automate to remove specific HTML tags by replacing them with an empty string. However, for more complex HTML content, using an Azure Function is recommended for better handling of various HTML structures.

For example, you can use the following steps in your Power Automate flow:

1. Trigger the flow when a new email arrives.
2. Use the Azure Function to clean the email body by removing HTML tags.
3. Add the cleaned text to your Excel table row.

Make sure to format the request body correctly when calling the Azure Function to ensure it processes the email body as expected.

Answer 2

Dear @Kate Rattray,
Thank you for posting in the Microsoft Community. According to its description, I understand you’re trying to convert an incoming email into an Excel table row using Power Automate, but the email body includes HTML tags, making the content hard to read

If my understanding is correct, as our category focuses on Office 365 products, the problem you encountered is related to PowerAutomate Flow, to ensure that you get professional help and avoid incorrect information from our side, we suggest you post on the Microsoft Power Automate Community for expert assistance. This is a specific channel related to Power Automate. The reason I ask you to post a new topic is that our forum have limited resources about Power Automate, and in Microsoft Power Platform Community Forum Thread, you'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction. 

  Apologies for redirecting you to a different community as the members of the posted category focus on users with Microsoft 365 concern and have limited resources about Power Automate, so to get a quick and better assistance, we redirect you in the correct way. 

I truly appreciate your patience and understanding. Thank you for your cooperation.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.