Creating Hyperlinks in a HTML Table

(2) Share

Report

Posted on by CU23080757-2

Hello, I have been trying to create a flow that sends a list of events pulled from a sharepoint list periodically. This would create a table of the events in date order, and then have links to each sharepoint item. What I want to do is have the name of the event be the link, but I keep running into an issue. Power Automate is fine when the name of the hyperlink is "Link" but doesn't like it when it is dynamic content. The below images show where the issue is. Column 3 and 4 are just the hyperlink as I have the code parse original (longer) link and then reconstruct it.

Any ideas why the bottom one is invalid?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
You are missing some commas.

Try the below instead.

concat('<a href="', item()?['Column3'], item()?['Column4'], '">', item()?['Event'], '</a>')

Was this reply helpful? Yes No
CU23080757-2 12 on at

Like (1)

Report

I don't know how to respond to a suggested answer but the one Expiscornovus has suggested didn't work for me. It just returned the output as a giant cell.

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Can you share the outputs of your test in a screenshot. Also a screenshot of your flow action would be useful. For example, what type of action are you using, a create HTML table for example?

Below is how I tested it in a Select action. Maybe that helps as well?

1. The setup, I have added the expression to a value field within the map section of a Select action

2. The test run

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report
I take a much simpler approach; I just code the HTML in the value field like:

I do find it easier if you first enter the html code and then insert the values from the dynamic content second. Just be sure before you insert the field, it is in the appropriate spot where it needs to be inserted in the HTML code.

If you plan to send the HTML table via e-mail, in order for the links to work, you will need to pass the Output of the Create HTML table action through a Compose action with this expression:

replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')

Was this reply helpful? Yes No
CU23080757-2 12 on at

Like (1)

Report

Hi this is what the raw outputs now look like:

I don't really get why the dramatic change from just this concat.

Was this reply helpful? Yes No