Excel table with a hyperlink column - need same hyperlinked output from Create HTML table option for that excel hyperlink Column

[rjkp_26]

I am using a table in excel fetched from OneDrive for business and creating HTML table using some selected fields in excel table in my flow which would be shown in email body and send to recipient when flow runs.

There is a hyperlink Column in excel which I want in the email body table with same hyperlink enabled. currently while using that hyperlink excel column using Create HTML table option output do not return the hyperlinking.

Can you please help to give a resolution

[v-chengfen-msft · Accepted solution]

Hi @rjkp_26 ,

Do you want:
1. Make excel data into html table
2. Hyperlink should also be in the form of a hyperlink in the Html table

The method of concatenating Html tables through strings can meet your needs

Here is test for your reference:

Here is excel :

Here is flow:

Here is result:

Best Regards

Cheng Feng

[rjkp_26]

Hi Cheng Feng,

Thanks for the suggestion. Unfortunately, it was not working for me. I used the below steps, and it works for me now - 

1. In Create HTML Table I added the hyperlink column and applied below formula where 'Link' is the       column in my excel that contains the hyperlink address - 

concat('<a href="', item()?['Link'], '"> Opp ID Link </a>')

2. Then in the email body i am calling the Create HTML Table output as below -

replace(replace(replace(body('Create_HTML_table'),'&lt;','<'),'&gt;','>'),'&quot;','"')

Thank you once again for your time and response.

Regards,

Rjk