Live coding demo for to Create Quick Launch left Navigation. Available to any end user and does not require SharePoint tenant admin, site collection admin, or high level access. Cheers.
Live coding demo for to Create SharePoint fields from CSV. Available to any end user and does not require SharePoint tenant admin, site collection admin, or high level access.
Provision list schema and create fields with DisplayName, InternalName, and Data Type from CSV input.
Live coding demo how to automate Correlation ID lookup and email CSV results with PowerShell automation and SPList request item. Reduce administration effort and provide faster CSV results to customers.
How to run Format-Table in PowerShell and format output as table with color logic driven from cell value. Full code below. Cheers
VIDEO
SOURCE CODE
# List process and format as table
$proc = Get-Process
$proc | Format-Table @{
# Add column "Name" to table
Label = "Name"
Expression = {
if ($_.Name -eq "chrome") {
# Format row color Green when Name is "chrome"
$color = "32" # Green
} else {
# Format row color Red when Name is not "chrome"
$color = "31" # Red
}
# Character 27 is ESC
$e = [char]27
# Format row with name and color
"$e[${color}m$($_.Name)$e[0m"
}
}, PID, CPU, PM, WS, VM, NPM, Path -AutoSize