SharePoint Online SPOMod: Get-SPOListColumn
This article describes a function of a custom SharePoint Online module available for download and installation on GitHub where it welcomes all your suggestions and contributions.
Get-SPOListColumn
Retrieves a list field/column.
Parameters
| ListTitle | Mandatory | Name of the list |
| FieldTitle | Mandatory | Internal name or title of the field |
Examples
----- EXAMPLE 1 ------
Retrieve a column.
Get-SPOListColumn -ListTitle MyList6 -FieldTitle CSTColumn
----- EXAMPLE 2 ------
Retrieve properties for all columns.
$kolumny=(Get-SPOListFields -ListTitle MyList6).InternalName
foreach($kolum in $kolumny){Get-SPOListColumn -ListTitle MyList6 -FieldTitle $kolum}
----- EXAMPLE 3 ------
Retrieve properties for all columns and export them to CSV.
$kolumny=(Get-SPOListFields -ListTitle MyList6).InternalName
foreach($kolum in $kolumny){Get-SPOListColumn -ListTitle MyList6 -FieldTitle $kolum | export-csv c:\Deeletthis2.csv -Append}
----- EXAMPLE 4 ------
Retrieve all hidden columns.
$kolumny=(Get-SPOListFields -ListTitle MyList6).InternalName
foreach($kolum in $kolumny){Get-SPOListColumn -ListTitle MyList6 -FieldTitle $kolum | where{$_.Hidden -eq $true} | select Title}
----- EXAMPLE 5 ------
Retrieve all indexed columns.
$columns=(Get-SPOListFields -ListTitle MyList6).InternalName
foreach($column in $columns){Get-SPOListColumn -ListTitle MyList6 -FieldTitle $column | where{$_.Indexed -eq $true} | select Title}
See Also
SPOMod Cmdlets and Resources
Connect-SPOCSOM
Get-SPOList
Get-SPOListItems