PowerShell script to remove User account from SharePoint Online Site collections
SharePoint Online is based on the old SharePoint solution in its core system. The User Account management is part of, and you can confirm that looking the SPUsers management: https://YourTenant.sharepoint.com/sites/YourSiteCollection/_catalogs/users/simple.aspx This page will show you the list of user accounts referenced into your current site collection. The challenge is when there is an issue into that User identification, like a user account changing the name or in case of duplication of email address (2 accounts with the referenced same email address). There is no solution to remove the SPOUser from any visual screen, and the only solution I found is via the PowerShell command: Remove-SPOUser The following script will give you the capability to remove the defined login account from any Site collection you want (based on the filtering you can use into the Get-SPOSite options): [string]$username = "AdminAccount@yourTenant.onmicrosoft.com" [string]$PwdTXTPath = "C:\SECUREDPWD\ExportedPWD-$($username).txt" [string]$SiteCollectionURL = "https://yourTenant.sharepoint.com" [string]$LoginAccounttoRemove = "i:0#.f|membership|User.Login@yourTenant.com" function Load-DLLandAssemblies { [string]$defaultDLLPath = "" # Load assemblies to PowerShell session $defaultDLLPath = "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.dll" [System.Reflection.Assembly]::LoadFile($defaultDLLPath) $defaultDLLPath = "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.Runtime.dll" [System.Reflection.Assembly]::LoadFile($defaultDLLPath) $defaultDLLPath = "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.Online.SharePoint.Client.Tenant.dll" [System.Reflection.Assembly]::LoadFile($defaultDLLPath) } cls Write-host " ------------------------------------------------------------ " Write-host " Removing Specific Account from specific Site collection " Write-host " ----------------------------------------------------------- " Load-DLLandAssemblies $secureStringPwd = ConvertTo-SecureString -string (Get-Content $PwdTXTPath) $adminCreds = New-Object System.Management.Automation.PSCredential $username, $secureStringPwd Connect-SPOService -Url https://yourTenant-admin.sharepoint.com -credential $adminCreds -ErrorAction SilentlyContinue -ErrorVariable Err #Retrieve all site collection infos #$sitesInfo = Get-SPOSite -Template "STS#0" -Limit ALL | Sort-Object -Property url | Select * #$sitesInfo = Get-SPOSite -Filter {Url -like "https://yourTenant.sharepoint.com/sites/YourSiteCollection"} -Limit ALL | Sort-Object -Property url | Select * $sitesInfo = Get-SPOSite -Template "BLANKINTERNET#0" -Limit ALL | Sort-Object -Property url | Select * [int]$i = 1; Write-host " ===>>> ", $sitesinfo.count + " site collections found." -ForegroundColor green foreach ($site in $sitesInfo) { $CheckUser = $null Write-host " ------------------------------------------------------------ " Write-host "SiteColl Number:", $i, "- of:", $sitesInfo.Count -ForegroundColor green $i += 1; Write-Host "SPO Site collection:", $site.Url, "- Title:", $site.Title -ForegroundColor magenta Write-Host " => External Sharing:", $site.SharingCapability Write-Host " => Site Template Used:", $site.Template $CheckUser = Get-SPOUser -Site $site.Url -LoginName $LoginAccounttoRemove if($CheckUser.count -gt 0) { write-Host " >>>> Removing User Account:", $LoginAccounttoRemove -ForegroundColor magenta $CheckUser | Format-Table Remove-SPOUser -Site $site.Url -LoginName $LoginAccounttoRemove } else { write-Host " >>>> User Account", $LoginAccounttoRemove, "does not exist into the site collection:", $site.Url -ForegroundColor Yellow } Write-host " ------------------------------------------------------------ " } You can adapt that code as you want for your own case. Fabrice Romelard French version: http://blogs.developpeur.org/fabrice69/archive/2018/11/19/office-365-script-powershell-pour-supprimer-des-comptes-utilisateur-de-collections-de-sites-sharepoint-online.aspx Sources used for that script: https://support.office.com/en-ie/article/how-to-remove-users-from-sharepoint-online-9e470280-e822-42ca-b3f5-744c12d0955a https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/get-spouser?view=sharepoint-ps https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/remove-spouser?view=sharepoint-ps
