SharePoint Online & PNP PowerShell -在所有元数据中将库文档输出到CSV，包括内容类型

# 连接到SharePoint Online
Connect-PnPOnline -Url https://your-sharepoint-site-url -Credentials (Get-Credential)

# 获取文档库
$library = Get-PnPList -Identity "Documents"

# 获取文档库中的所有文档
$documents = Get-PnPListItem -List $library

# 创建CSV文件
$outputPath = "C:\output.csv"
$csvData = @()

# 遍历每个文档，提取元数据
foreach ($document in $documents) {
    $metadata = @{
        "文件名" = $document["FileLeafRef"]
        "内容类型" = $document["ContentType"]
        # 添加其他需要的元数据字段
    }
    $csvData += New-Object PSObject -Property $metadata
}

# 导出CSV文件
$csvData | Export-Csv -Path $outputPath -NoTypeInformation

# 断开与SharePoint Online的连接
Disconnect-PnPOnline