Hi everyone, Hope you can help!
Our flow is basically connected to an excel table (One Drive for Business) and will send an email to different contacts. Each email contains a dynamic HTML table (i.e If Sam has 3 invoices submitted, he would receive a table with 3 rows, Rachel will receive 8 rows reflecting her 8 invoices, etc.) but i want to add a hyperlink to the column "Invoice Number" that should send us to a webpage containing of each exact invoice (i.e Sam's Invoice 88876, row 1 of his html table has an hyperlink to a google page with the invoice 88876 pdf). Can you help?
I followed this flow: https://alextofan.com/2019/02/14/flow-how-to-change-the-style-of-your-html-table-in-flow/ but i can't add an hyperlink
This is how it looks right know with the next code but no webpage gets open.
I have in my excel table the columns ID and Link (Which is the webpage)
<td @variables('varStyle').cellEmptyStyle, @variables('varStyle').cellStyle)}>
@{concat('<a href=", if(empty(item()['Link']),'',item()['Link']), '">', if(empty(item()['ID']),'',item()['ID']), '</a>')}</td>
Cheers!
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1