Using either Powershell or other method, I need to export a list of titles of files, their filenames with extensions, their locations, and their URLs into a text or Excel file. This is what I have found so far (for Powershell):
Get-SPWeb https://tenant.sharepoint.com/ |
Select -ExpandProperty Lists |
Where { $_.GetType().Name -eq “SPDocumentLibrary” -and
-not $_.Hidden } |
Select -ExpandProperty Items |
Where { $_.Url -like “*Documents*” } |
Select Name, {$_.File.Length}, url
However, I need something that will give me the information I seek and will look recursively. I looked up the Select-Object
and -ExpandProperty
in SharePoint documentation, but I couldn't find what my options were for other properties I could choose. Also, I am looking to return all files, not just ones with a specific term in them.
Please help, if you can! Thanks, in advance!
-PipelineVariable
or split by using variables for intermediate results. – LotPings Jun 8 '19 at 8:18