Forum Discussion

Brass Contributor

Mar 20, 2020

Solved

Exporting Results To .CSV File

Forgive me if this is obvious but I am still fairly new to Powershell and have tried alot but not found a reason for why this is not working. I have the below script that works find but when I try to...

Export csv

VasilMichev
Mar 20, 2020
The way you've done it, the CSV file is overwritten after each iteration. You either need to put the Export-CSV cmdlet outside of the loop, or use the -Append switch to make it add to the file, not overwrite it.

Also, when importing CSV files, PowerShell will treat items as objects. $user in your case will represent the entire object (think of it the entire row in the CSV file), but not all cmdlets will accept such input. Instead, you should use something like $user.Name or $user.UserPrincipalName - those properties represent the column names in your CSV file.

VasilMichev

MVP

Mar 20, 2020

The way you've done it, the CSV file is overwritten after each iteration. You either need to put the Export-CSV cmdlet outside of the loop, or use the -Append switch to make it add to the file, not overwrite it.

Also, when importing CSV files, PowerShell will treat items as objects. $user in your case will represent the entire object (think of it the entire row in the CSV file), but not all cmdlets will accept such input. Instead, you should use something like $user.Name or $user.UserPrincipalName - those properties represent the column names in your CSV file.