Answered

Link to list item truncated in Clean HTML

(0) Share

Report

Posted on by RADical

164

I'm having an issue with the link to SPO list item links being truncated in emails. I'm using the formula replace(replace(replace(replace(replace(replace(body('Create_HTML_table_of_audited_items'), '<', '<'), '>', '>'), '&', '&'), ''', '"'), '"', '"'), '"', decodeUriComponent('%27')) to fix the output of the link. It outputs the link fine when I use the dynamic output for the link to item, but once I try to transform the text in the select action using

"Effort": "<a href=\"@{item()?['{Link}']}\">@{item()?['Effort']}</a>",

then it starts to truncate the link. The column type I'm using for 'Effort' is single line of text.

Expanded view:

Please help....

Categories:

Business Process Flows

All responses (2)

Answers (1)

RADical 164 on at

Like (0)

Report

Re: Link to list item truncated in Clean HTML

@v-yujincui-msftThanks for the swift reply. This seems to have solved the problem with the link, but it broke my color formatting. I'll have to see how I can get that fixed, but at least the major issue is resolved.Thanks again!
Verified answer

v-yujincui-msft on at

Like (0)

Report
Re: Link to list item truncated in Clean HTML

Hi @RADical ,

I have made a simple test for your reference.

concat('"Effort":', '<a href="', item()?['{Link}'], '">',item()?['Effort'],'</a>')
replace(replace(replace(body('Create_HTML_table_of_audited_items'),'<','<'),'>','>'),'"','"')

Result Screenshot:

In addition, here is a link for your reference.

https://tomriha.com/how-to-add-hyperlink-in-the-create-html-table-power-automate-action/

Best Regards,

Charlie Choi