How to format link properly in Create HTML table in Ms flow?

[WaleedBinAfzal]

Hi,

I am trying to create an html table with one column having link to the opportunity. This table I am using in sending emails. 

But there is an issue with the anchor tag as it is not appearing as it must appear. I am stuck at this point an its been two days I have searched here and there to get some help but still stuck here.

Please help. How can I see the link as normally anchor tag show. See below image for your reference.

[InterestedBloke · Accepted solution]

Hey Waleed,

This is something I've been patiently waiting for, but it's still not there.
You can vote for the idea here.

As for the workaround I've found for this, it's a bit complex at first, but it works nicely:

• Create HTML table as you have with the <a href="...

• Create Compose 1

replace(body('HTML_Table'),'&lt;a href=&quot;','<a href="')

• Create Compose 2

replace(outputs('Compose1'),'">','">')​

• Create Compose 3

replace(outputs('Compose2'),'&lt;/a&gt;','</a>')​

• (optional) Create Compose action called "Style" to format your table (i use the below formatting that i stole from a colleague, but you can create your own here)

<style>
body, p {font-family:"Calibri",sans-serif; font-size: 11pt}
table { background:white;border-collapse:collapse }
th {border:solid white 1.0pt; background:#106EBE;padding:1.45pt 3.6pt 1.45pt 3.6pt; color: white}
td { border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;padding:1.45pt 3.6pt 1.45pt 3.6pt;box-sizing: border-box }
a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline; }
a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;}
</style>​

• Create "Send an email" action that's not version2 - important as it has to be HTML.
  • Or i think it might even work with version2 if you switch to the HTML type
  • (optional) start e-mail with the output from "Style"
• Insert output from Compose 3 where you want your table to be

[PowerPat]

hi, i have only send email V2 ... but no works for me ? my email has always a href="

[InterestedBloke]

Hey PowerPat,

The above might no longer be relevant with the (V2) connector - it was for Send an Email (V1).

However, you might still be able to follow the same steps if you toggle the HTML code on 

Or there might be an easier option - don't know as i haven't played around with this recently.

[zylantha2]

You can nest the replace() functions in the one operation, saving actions and making your flow much more readable.  Here's how I did it using three nested calls:

replace(replace(replace(body('Create_HTML_table'),'&lt;','<'),'&gt;','>'),'&quot;','"')

[SvampK]

Got into this thread and found some other solution in this blog with prue HTML:

https://www.aerieconsulting.com/blog/how-to-sending-tables-in-flow-email-with-link-to-items