Creating Hyperlinks in a HTML Table

Like (2) Share

Report

Posted on 23 Aug 2024 08:02:51 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:

Business Process Flows

All responses (5)

Answers (0)

CU23080757-2 12 on 23 Aug 2024 at 13:56:55

Like (1)

Report

Creating Hyperlinks in a HTML Table

Hi this is what the raw outputs now look like:

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

David_MA 10,874 Super User 2025 Season 1 on 23 Aug 2024 at 13:16:52

Like (1)

Report
Creating Hyperlinks in a HTML Table

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'),'<','<'),'>','>'),'"','"')
Expiscornovus 31,697 Most Valuable Professional on 23 Aug 2024 at 09:58:59

Like (1)

Report

Creating Hyperlinks in a HTML Table

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
CU23080757-2 12 on 23 Aug 2024 at 09:38:27

Like (1)

Report

Creating Hyperlinks in a HTML Table

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.
Expiscornovus 31,697 Most Valuable Professional on 23 Aug 2024 at 08:42:49

Like (1)

Report
Creating Hyperlinks in a HTML Table

You are missing some commas.

Try the below instead.

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