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
Solved! Go to 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
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
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'),'<','<'),'>','>'),'"','"')
Thank you once again for your time and response.
Regards,
Rjk