# Break permission inheritance on a list
Set-PnPList -Identity "Documents" -BreakRoleInheritance -CopyRoleAssignments
 
# Restore permission inheritance
Set-PnPList -Identity "Documents" -ResetRoleInheritance

# Complete site export with details
Get-SPOSite -Limit All | Select Url,Title,Owner,Template,StorageUsageCurrent,LastContentModifiedDate |
Export-Csv -Path "C:\temp\SharePointSites.csv" -NoTypeInformation -Encoding UTF8

# Detailed permissions export script
$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

# Expected CSV format: 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 created: $($site.SiteName)" -ForegroundColor Green
    } catch {
        Write-Host "Error creating $($site.SiteName): $($_.Exception.Message)" -ForegroundColor Red
    }
}

# CSV format: 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 "Added $($perm.UserEmail) to $($perm.SiteUrl)" -ForegroundColor Green
    } catch {
        Write-Host "Error adding $($perm.UserEmail): $($_.Exception.Message)" -ForegroundColor Red
    }
}