Get List Items In A Tree View

Kvbharat Bhushan
7y
1.9k
0
0

Blog

Create a ps1 extension file and save it in your local path.

Change the highlighted part with your site collection URL, List name etc.

<ol>
<li>Create a ps1 extension file and save it in your local path.</li>
</ol>
Change the highlighted part with your site collection url, List name etc.
#============================================================
# Function Get-FolderItems is a recursive function that will
# get all items from a list and print it out like a Treeview
#============================================================
function Get-FolderItems([Microsoft.SharePoint.SPFolder]$folder, $level) {
#The following code is to simulate the treeview in the printout. It if for visual purposes only
if($level -eq $null) {
$level=0
}
$prestring = “”
for($x=0;$x -le $level;$x++) {
$prestring += “—”
}
# Create query object
$query = New-Object Microsoft.SharePoint.SPQuery
$query.Folder = $folder
# Get SPWeb object
$web = $folder.ParentWeb
# Get SPList
$list = $web.Lists[$folder.ParentListId]
# Get a collection of items in the specified $folder
$itemCollection = $list.GetItems($query)
# If the folder is the root of the list, display information
if($folder.ParentListID -ne $folder.ParentFolder.ParentListID) {
Write-Host($folder.Name + ” [Root of the list with ” + $folder.ItemCount + ” item(s) in it]”)
}
# Iterate through each item in the $folder – Note sub folders and list items are both considered items
foreach($item in $itemCollection) {
# If the item is a folder
if($item.Folder -ne $null) {
# Write the Subfolder information
Write-Host($prestring + “*” + $item.Name + ” [Folder Item | Parent Folder: ” + $folder.Name + ” | Contains ” + $folder.ItemCount + ” item(s)]”)
# Call the Get-Items function recursively for the found sub-solder
Get-FolderItems $item.Folder ($level+1)
}
# If the item is not a folder
if($item.Folder -eq $null) {
# Write the item information
Write-Host($prestring + $item.Name + ” [Item | Parent Folder: ” + $folder.Name + “]”)
}
}
$web.dispose()
$web = $null
}
#============================================================
# Function Get-Folder will return a SPFolder object based on
# $webUrl string and a $listName string
#============================================================
function Get-Folder([string]$webUrl,[string]$listName) {
# Use the Get-SPWeb CMDLET – it gives you the SPWeb object without having to create the SPSite object
$web = Get-SPWeb $stringUrl
# Get your SPList
$list = $web.Lists[$stringListName]
# Get the root folder containing items in your list
$folder = $list.RootFolder
$web.Dispose()
$web = $null
return ,$folder
}
#============================================================
# Main procedural code
#============================================================
$stringUrl = “http://hvsp01/sites/HRMS”
$stringListName = “Calander”
# Get the root folder for the List
$folder = Get-Folder $stringUrl $stringListName
# Call the recursive Get-FolderItems function passing the root of your list. It will call itself again and again until it has gone through your entire structure
Get-FolderItems $folder2. Open Management Shell as an administrator.
<ol start="3">
<li>Run the PS script using the path along with the file as shown.</li>
</ol>
<ol start="4">
<li>Here is the required output.</li>
</ol>
Use <a href="http://htmlcheatsheet.com/" target="_blank" rel="nofollow">the HTML Cheat Sheet</a> for color picker, search for special HTML characters, get examples of the most common tags and generate any tags.