Get Total Count of SharePoint Files, Folders, and Items with PnP PowerShell This PowerShell script powered by PnP PowerShell can help to get total count of files, folders, and list items across SharePoint tenant. This script is invaluable for administrators looking to perform audits, verify data migrations, or simply keep tabs on the content sprawl within their environments. The use case of this script was to get a total number of items that would be ingested into a third party application Records365 (provided by RecordPoint) to ensure the number tally for compliance purposes and identify any gaps.

SharePoint Search: Excluding Columns from Search Results SharePoint empowers users to manage and organize vast amounts of data efficiently. However, not all data within a SharePoint site might need to be searchable. Do you miss the functionality to control visibility of sensitive or irrelevant information in column. The Challenge You might have encountered instances where you need certain columns in your SharePoint lists or libraries to be excluded from search results.

#$SiteCollectionUrl = Read-Host -Prompt "Enter site collection URL: "; $list = "Timesheet" $ExportFileDirectory = (get-location).ToString(); $field = Get-PnPField -List $list -Identity "Category" $catChoices = $field.choices $sitesWithTimesheet = @( "https://contoso.sharepoint.com/teams/PMO" "https://contoso.sharepoint.com/sites/In" "https://contoso.sharepoint.com/teams/Security" "https://contoso.sharepoint.com/teams/Dev" "https://contoso.sharepoint.com/teams/SD" ) if(Test-Path $ExportFileDirectory){ $sitesWithTimesheet | foreach { connect-pnponline -url $_ -Interactive $items = Get-PnPListItem -List $list -PageSize 500 -Fields Category ##get distinct choices within column $type = [System.Collections.ArrayList]@(); $items | foreach-object { if($_.FieldValues.Category){ if($catChoices -notcontains $_.FieldValues.Category){ if($type.Name -notcontains $_.