private775 icon

SharePoint: get items content using PowerShell

private775 | PRO | 05/05/15 06:02:23 PM UTC | 0 ⭐ | 759 👁️ | Never ⏰ | []
PowerShell |

670 B

|

None

|

0 👍

/

0 👎

# IDS: 7,53
$ids = 7,53
$webUrl = "http://acme.com/sites/test/web"
$listName = "MyItems"
 
# show all fields
$w = get-spweb $webUrl
$l = $w.Lists[$listName]
 
$fldNames = $l.Fields|?{ -not $_.FromBaseType}| % {$_.InternalName}
 
$ids = $l.Items|%{$_.ID}
 
foreach($id in $ids){
    $item = $l.GetItemById($id)
    "Title: $($item.Title)"
    "Created: $($item['Created'])"
    foreach($fldName in $fldNames){
      $fld = $l.Fields.GetFieldByInternalName($fldName)
      $val = $item[$fld.Id]
      $valStr = ""
      if($val -ne $null){
        $valStr = $val.ToString()
      }
      "$($fld.Title):$($valStr)"
    }
    "###########################################################################"
}

Comments