MyList is a document library with a column called 'name'. I am trying to do this in my Powershell script:
$myList= $subWeb.Lists["MyList"]
$items= $myList.Items | sort Title
foreach ($li in $items) {
Write-Host $li.name # is empty?
}
When I look in the interface it clearly shows rows in the MyList library. Why is $li.name empty or how can I get the $li.name property?
$myList = $subWeb.Lists["MyList"]
$item s= $myList.Items | sort Title
foreach ($li in $items) {
Write-Host $li.["Name"]
}
I think what you are looking for is the file name.
It resides in an internal hidden column FileLeafRef.
Modify your code as below:
$myList = $subWeb.Lists["MyList"]
$items = $myList.Items | sort Title
foreach ($li in $items) {
Write-Host $li["FileLeafRef"] #should output something like - test.docx
#to update list item
$li["FileLeafRef"] = "newFileName.docx" #change it as per your requirement
$li["Title"] = "New document title"
$li.Update();
}
$li["Description"] and also check if the column itself has some value.
You need to go to Library settings->Columns, and find the column and click it.
Then you will find the internal name of the field via Field parameter of the URL:
Then in your PowerShell commands, you need to use the internal name.
A demo for your reference:
Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue
$SPweb = Get-SPWeb "http://your site url"
$SPlist = $SPweb.Lists["your library"]
$items=$SPlist.Items | sort Title
foreach ($SPitem in $items)
{
write-host $SPitem["name1"]
}
Note: you need to change "name1" to the internal name of your column.
