cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rjkp_26
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-chengfen-msft
Microsoft
Microsoft

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 :

vchengfenmsft_4-1670394670575.png

Here is flow:

 

vchengfenmsft_0-1670394302285.pngvchengfenmsft_1-1670394329378.png

vchengfenmsft_2-1670394511350.png

 

Here is result:

vchengfenmsft_3-1670394647308.png

 

Best Regards

Cheng Feng

View solution in original post

2 REPLIES 2
v-chengfen-msft
Microsoft
Microsoft

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 :

vchengfenmsft_4-1670394670575.png

Here is flow:

 

vchengfenmsft_0-1670394302285.pngvchengfenmsft_1-1670394329378.png

vchengfenmsft_2-1670394511350.png

 

Here is result:

vchengfenmsft_3-1670394647308.png

 

Best Regards

Cheng Feng

rjkp_26
Frequent Visitor

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

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,394)