Advertisement
private775

SharePoint: get items content using PowerShell

May 5th, 2015
471
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # IDS: 7,53
  2. $ids = 7,53
  3. $webUrl = "http://acme.com/sites/test/web"
  4. $listName = "MyItems"
  5.  
  6. # show all fields
  7. $w = get-spweb $webUrl
  8. $l = $w.Lists[$listName]
  9.  
  10. $fldNames = $l.Fields|?{ -not $_.FromBaseType}| % {$_.InternalName}
  11.  
  12. $ids = $l.Items|%{$_.ID}
  13.  
  14. foreach($id in $ids){
  15.     $item = $l.GetItemById($id)
  16.     "Title: $($item.Title)"
  17.     "Created: $($item['Created'])"
  18.     foreach($fldName in $fldNames){
  19.       $fld = $l.Fields.GetFieldByInternalName($fldName)
  20.       $val = $item[$fld.Id]
  21.       $valStr = ""
  22.       if($val -ne $null){
  23.         $valStr = $val.ToString()
  24.       }
  25.       "$($fld.Title):$($valStr)"
  26.     }
  27.     "###########################################################################"
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement