Link to list item truncated in Clean HTML

Like (0) Share

Report

Posted on 21 Sep 2022 19:54:11 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

I have the same question (0)

All responses (2)

Answers (1)

RADical 164 on 22 Sep 2022 at 11:47:50

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!

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on 22 Sep 2022 at 06:03:58

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

Was this reply helpful? Yes No