# Briser l'héritage des permissions d'une liste
Set-PnPList -Identity "Documents" -BreakRoleInheritance -CopyRoleAssignments
 
# Restaurer l'héritage des permissions
Set-PnPList -Identity "Documents" -ResetRoleInheritance

# Export complet des sites avec détails
Get-SPOSite -Limit All | Select Url,Title,Owner,Template,StorageUsageCurrent,LastContentModifiedDate | 
Export-Csv -Path "C:\temp\SharePointSites.csv" -NoTypeInformation -Encoding UTF8

# Script d'export des permissions détaillées
$sites = Get-SPOSite -Limit All
$results = foreach($site in $sites) {
    Connect-PnPOnline -Url $site.Url -Interactive
    $groups = Get-PnPGroup
    foreach($group in $groups) {
        $members = Get-PnPGroupMember -Group $group.Title
        foreach($member in $members) {
            [PSCustomObject]@{
                SiteUrl = $site.Url
                SiteTitle = $site.Title
                GroupName = $group.Title
                MemberName = $member.Title
                MemberEmail = $member.Email
                MemberType = $member.PrincipalType
            }
        }
    }
}
$results | Export-Csv -Path "C:\temp\SharePointPermissions.csv" -NoTypeInformation -Encoding UTF8

# Format CSV attendu : SiteName,SiteUrl,Owner,Template
$sites = Import-Csv -Path "C:\temp\NewSites.csv" -Delimiter ";"
 
foreach($site in $sites) {
    try {
        New-SPOSite -Url $site.SiteUrl -Title $site.SiteName -Owner $site.Owner -Template $site.Template -Wait
        Write-Host "✓ Site créé : $($site.SiteName)" -ForegroundColor Green
    } catch {
        Write-Host "✗ Erreur création $($site.SiteName) : $($_.Exception.Message)" -ForegroundColor Red
    }
}

# Format CSV : SiteUrl,UserEmail,Permission
$permissions = Import-Csv -Path "C:\temp\SitePermissions.csv" -Delimiter ";"
 
foreach($perm in $permissions) {
    try {
        Connect-PnPOnline -Url $perm.SiteUrl -Interactive
        $groupName = switch($perm.Permission) {
            "Read" { "Site Visitors" }
            "Contribute" { "Site Members" }
            "FullControl" { "Site Owners" }
        }
        Add-PnPGroupMember -Group $groupName -LoginName $perm.UserEmail
        Write-Host "✓ Ajouté $($perm.UserEmail) à $($perm.SiteUrl)" -ForegroundColor Green
    } catch {
        Write-Host "✗ Erreur ajout $($perm.UserEmail) : $($_.Exception.Message)" -ForegroundColor Red
    }
}