Combining output to CSV from two Powershell commands

Question

I am trying to take an existing CSV file and append it with the output from another command. Whenever I run the script, it sets all values in the column to the $owner.

I'm not sure what I'm missing, but it is not working properly.

`Connect-MicrosoftTeams

#get list of teams
$TeamsFile = Get-Team | Select DisplayName, GroupID, Description | Export-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv" -Delimiter "," -NoTypeInformation

#read row in CSV, add owner to new column.
ForEach ($Team in $TeamsFile) {
$Owner = Get-TeamUser -GroupId $Team.GroupID -Role Owner | Select Name

Write-Host $Team.GroupID " Owner: " $Owner.name

$TeamsFile = Import-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv"
$TeamsFile | Select-Object -Property *, @{label = 'Team Owner'; expression = {$Owner.name}} 
}

$TeamsFile | Export-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv" -Delimiter "," -NoTypeInformation

`

Sample of existint CSV

could you show a part of csv file..it will be easier to trap the error, if we could replay the sample...And display the result waited — Frenchy
– Frenchy, Commented May 24, 2021 at 16:29
If you want the first $TeamsFile to contain anything, you should use Get-Team | Select DisplayName, GroupID, Description -OutVariable TeamsFile | Export-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv" -Delimiter "," -NoTypeInformation — AdminOfThings
– AdminOfThings, Commented May 24, 2021 at 16:40

AdminOfThings · Accepted Answer · 2021-05-24 17:14:23Z

2

If you only need a merged output of two commands, you may make use of calculated properties:

Get-Team |
    Select DisplayName,GroupID,Description,
        @{n='Team Owner';e={(Get-TeamUser -GroupId $_.GroupID -Role Owner).Name}}

If you already have a CSV file of Team data and need just the owner, you may update your CSV row objects with a new property using a calculated property also:

(Import-CSV -LiteralPath 'C:\Scripts\Microsoft_Teams_List.csv' |
    Select *,@{n='Team Owner';e={(Get-TeamUser -GroupId $_.GroupID -Role Owner).Name}}) |
        Export-Csv -LiteralPath 'C:\Scripts\Microsoft_Teams_List.csv' -NoTypeInformation

In your attempt, the following code does not yield the results you think:

$TeamsFile = Get-Team | Select DisplayName, GroupID, Description | Export-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv" -Delimiter "," -NoTypeInformation

$TeamsFile won't contain any output because all output was sent down the pipeline to Export-Csv. If you want to capture output before it is sent to Export-Csv, you can use the common parameter -OutVariable.

Get-Team | Select DisplayName, GroupID, Description -OutVariable TeamsFile |
    Export-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv" -Delimiter "," -NoTypeInformation
$TeamsFile # now contains your Teams

edited May 24, 2021 at 17:14

answered May 24, 2021 at 17:09

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

cowboydude99 Over a year ago

This worked! Can the same login be applied for a 3rd command? So if you want to find out which 'office' the team is used in, could you add this? I don't think so as it is not working: Get-Team | Select DisplayName,GroupID,Description, @{n='Team Owner';e={(Get-TeamUser -GroupId $_.GroupID -Role Owner).user}} @{n='Office';e={(get-mailbox -identity $_.user).office}} | Export-CSV -Path "C:\Scripts\Microsoft_Teams_List.csv" -Delimiter "," -NoTypeInformation

AdminOfThings Over a year ago

You need a comma between the calculated property hash tables, but, yes, the same can be applied for a second property. There could be a point where running many commands for each input object will start to become slower than doing larger queries and filtering them down.

Prosenjit Sen · Accepted Answer · 2021-05-25 15:40:05Z

0

If headers are the same, then you can keep source csv files in a directory and use this command to generate a combined csv.

Get-ChildItem -Filter *.csv | Select-Object -ExpandProperty FullName | Import-Csv | Export-Csv .\combinedreport.csv -NoTypeInformation

answered May 25, 2021 at 15:40

Prosenjit Sen

3664 silver badges7 bronze badges

Collectives™ on Stack Overflow

Combining output to CSV from two Powershell commands

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related