用于从带有文档URL的csv文件中删除sharepoint库中的文档的Powershell脚本

# 导入SharePoint Online模块
Import-Module -Name Microsoft.Online.SharePoint.PowerShell -DisableNameChecking

# 连接到SharePoint Online
$siteUrl = "https://your-sharepoint-site-url"
$credentials = Get-Credential
Connect-SPOService -Url $siteUrl -Credential $credentials

# 读取CSV文件内容
$csvFile = Import-Csv -Path "C:\path\to\your\csv\file.csv"

# 遍历CSV文件中的每一行
foreach ($row in $csvFile) {
    $documentUrl = $row.DocumentURL

    # 删除SharePoint库中的文档
    Remove-SPOFile -SiteRelativeUrl $documentUrl -Force
}

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