I have a Power Automate flow that will post message with hyperlink in html table.
The message and link content will be different depends on some condition but it always have a html table.
The action boxes arrangement is:
Select Rows from SQL -> Select -> Create html table -> Compose (to replace the html code as below) -> Post to Team group chat.
replace(replace(replace(body('Create_HTML_table_Directlink'),'<','<'),'>','>'),'"','"')
But I have no idea why, the hyperlink is shown as a proper link sometimes while sometimes it showed as plain text:
<a href="https://xxxxxxxxxxxxxxxx">Link</a>
I checked the output property of "Compose" in workflow history. It always the same regardless it is a success or failed team message.
What could be the reason?