Power Automate

Formatting Links in HTML Table

(1) Share

Report

Posted on by ADumith

277

Hello everyone,

I have a workflow that sends an email containing a table. The table information comes from a dataverse database.

Table CSS styles:

This table is made in HTML. It is the one below.

Workflow step:

As you can see, there is a column that contains a link. When building the table, the link is very long and unattractive. So, I wonder if it's possible to place the link in the cell value of the first column. This way, the cell will show a value with a hyperlink.

Do you think this is possible? Could you help me do it?

Thank you,

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @ADumith ,

I checked your HTML format and found that this format is universal and does not need to be changed.

You only need to adjust the order of the fields in your append to array variable and put the link field first so that it can be located in the first cell in the HTML table.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ADumith 277 on at

Like (1)

Report
Copy link

Link copied!

Hello @v-yetonggu-msft ,

First of all, thank you very much for replying.

I don't think I explained myself correctly.

Basically, what I need is for the table to be displayed in this way:

As you can see, the "Link" field or column is no longer there. Instead, the link is associated with the Matter Number column. That is, if the user clicks on the number, the system should take them to the link associated with that number.

I hope this makes sense now.

Again, thank you very much.

Was this reply helpful? Yes No
ADumith 277 on at

Like (1)

Report
Copy link

Link copied!
Hello @v-yetonggu-msft

I tried this:
{ "Matter Number": "<a href='@{parameters('elAppUrl (el_elAppUrl)')}&elid=@{items('Apply_to_each')?['el_matterengagementletterid']}&screen=assistant' title='Click the link below to complete the task for the related matter'>@{items('Apply_to_each')?['el_matternumber']}</a>", "Client Name": @{items('Apply_to_each')?['el_clientname']}, "Matter Name": @{items('Apply_to_each')?['el_mattername']}, "Eng Letter Status": @{items('Apply_to_each')?['el_engagementletterstatus@OData.Community.Display.V1.FormattedValue']} }

But I'm getting this instead.

Any idea?

Thank you

Was this reply helpful? Yes No
ADumith 277 on at

Like (1)

Report
Copy link

Link copied!

I would be interested if someone could help me with this.
Thank you,

Was this reply helpful? Yes No
Suggested answer

ADumith 277 on at

Like (2)

Report
Copy link

Link copied!

Hello,

I figure it out how to fix the issue:

Into the email body I added this:

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

Was this reply helpful? Yes No