Share
Reportfrom my ADO query, I setup a variable BugURL and Select ID to make the hyperlink, which works.
Then create HTML Table with Automatic setting (which picks up the fields from Select Report Fields)
Then Compose CSS Formatting on the table, code shown below
<style>
table{
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 100%;
text-align: left;
border-collapse: collapse;
}
table td, table.th {
border: 1px solid #AAAAAA;
padding: 3px 4px;
}
table tbody td {
font-size: 13px;
}
table tr:nth-child(even) {
background: #D0E4F5;
}
table thead {
background: #1C6EA4;
background: -moz-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
background: -webkit-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
background: linear-gradient(to bottom, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
table tfoot {
font-size: 14px;
font-weight: bold;
color: #FFFFFF;
background: #D0E4F5;
background: -moz-linear-gradient(top, #dcebf7 0%, #d4e6f6 66%, #D0E4F5 100%);
background: -webkit-linear-gradient(top, #dcebf7 0%, #d4e6f6 66%, #D0E4F5 100%);
background: linear-gradient(to bottom, #dcebf7 0%, #d4e6f6 66%, #D0E4F5 100%);
border-top: 2px solid #444444;
}
table tfoot td {
font-size: 14px;
}
table tfoot .links {
text-align: right;
}
table tfoot .links a{
display: inline-block;
background: #1C6EA4;
color: #FFFFFF;
padding: 2px 8px;
border-radius: 5px;
}
</style>
@{body('Create_HTML_table')}
Then Send email to list of output of CSS modified table
The Bug ID output shows a hyperlinked URL similar to https://dev.azure.com/{Organization}/{Group}/_workitems/edit/123456, which works as a hyperlink (org and group info removed and fake bugID used)
The goal is I only want to show the Bug number 123456 that is hyperlinked so when it is clicked, it opens the Bug in ADO.
I've tried to use multiple forms of <a href="BugURL/ID",ID </a>, but am coming up short on solution. CoPilot not helpful.
All responses (
Answers (
62
