Hello I have read some different scenarios for removing HTML tags from an email when posting the results to a SharePoint site. However, I want to add a row to a table in Excel and cannot find a way to remove the tags from the body of the email so only the content remains. Below is the simple flow I have created. The HTML to text element is set to the Body of the email.
Unfortunately, the html will not be consistent so using text functions to split or replace text doesn't seem to work. I get an entry that looks like this below.
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri",sans-serif;
color:windowtext}
.MsoChpDefault
{font-family:"Calibri",sans-serif}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style></head><body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word"><div class="WordSection1"><p class="MsoNormal" style="line-height:16.5pt"><a name="_Hlk93337619"></a><a name="_Hlk142911914"></a><a name="_Hlk536104091"></a><a name="_Hlk536103749"><span style=""><span style=""><span style=""><span style="color:#2B2E2F">Hi,<br> <br>I hope you had a nice weekend. I've opened a ticket to have Ops update your Test environment to 8.1.2023. Jeremy will reach out to you directly to coordinate timing. <br> <br>Please let me know if you have any questions or concerns. </span></span></span></span></a><span style=""><span style=""><span style=" .... etc.
