Each Result in Table <TD>

Question

I have a PowerShell Script, which contain $frcnt Variable, it will gives a tow condition array:
1. Values: Name of process (without duplicates).
2. Keys: How many duplicates process. i want to show each above array in HTML table such as:

Keys         Values
chrome       10
explorer     5
firefox      7

here's my wrong syntax:

    $GetCon = Get-NetTCPConnection


$GName = foreach ($process in $GetCon) {

    $processName = (Get-Process -Id $process.OwningProcess).ProcessName
    $process | Add-Member -NotePropertyName ProcessName -NotePropertyValue $processName -PassThru
}

$gnmcnt = $GetCon | select -ExpandProperty ProcessName
$frcnt=@{}
$gnmcnt | % {if (!($frcnt.ContainsKey($_))) {$frcnt.Add($_,1)} else {$frcnt.Item($_)=$frcnt.Item($_) +1}}




$TableBody,$StrBody=""


$frcnt | ForEach-Object {

$TableBody+="<tr><td>$($_.Keys)</td> <td>$($_.Values)</td></tr>"

}


$Body =@"
<table>
<th>Process</th><th>Count</th>
$TableBody
</table>
"@

$Head = "<Style> body {Background-color: lightblue; } table {background-color: white; margin: 5px; float: left; top: 0px; display: inline-block; padding:5px; border: 1px solid black} tr:nth-child(odd) {background-color: lightgray} </style>"


$HTML = ConvertTo-Html -Body $Body -Head $Head


$HTML | Out-File -filepath "C:\temp\test.html" -Force

Invoke-Item "C:\temp\test.html"

Her's a result:

Again: I want to each result show's in with count values. thanks.

Answer 1

To convert the hashtable $frcnt to an array you can use the .GetEnumerator method.
.Keys changes to .Name then. and
.Values to singular .Value

Change the lines

$frcnt | ForEach-Object {
  $TableBody+="<tr><td>$($_.Keys)</td> <td>$($_.Values)</td></tr>"
}

to

$frcntArr = $frcnt.GetEnumerator() |%{$_}
ForEach ($Row in $frcntArr) {
  $TableBody+="<tr><td>$($Row.Name)</td> <td>$($Row.Value)</td></tr>`r`n"
}

---

Edit

or still better this, with only one Foreach

$frcnt.GetEnumerator() | ForEach {
  $TableBody+="<tr><td>$($_.Name)</td> <td>$($_.Value)</td></tr>`r`n"
}