How to Find SharePoint Sites Associated with Microsoft Teams?

Requirement: Find the SharePoint Online site of the Microsoft Team.

How to Get the Associated SharePoint Online Site of a Microsoft Team?
Every Microsoft teams created have a SharePoint Site associated behind the scenes to store files. To find the SharePoint site of the team,
  • Navigate to the Microsoft team, Click on "Files" tab and you'll find a button "Open in SharePoint"find sharepoint online site of microsoft teams
This opens the SharePoint Online site of the particular Microsoft teams.

Get a List of All Teams and their associated SharePoint Sites
To retrieve the associated SharePoint sites for Microsoft teams, Use this PowerShell script:
#Get Credentials to Connect
$Credential = Get-Credential

#Connect to Microsoft Teams
Connect-MicrosoftTeams -Credential $Credential | Out-Null
  
#Create a session and connect to Exchange
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ `
           -Credential $Credential -Authentication Basic -AllowRedirection
  
#Import the session
Import-PSSession $Session -DisableNameChecking -AllowClobber | Out-Null

#Get All Teams
$Teams = Get-Team | Select DisplayName, GroupId
Write-host "Total Number of Teams Found:"$Teams.Count

#Iterate through Each team and get SharePoint Site URL
ForEach ($Team in $Teams) 
{
    #Collect SharePoint Sites of the teams
    [PSCustomObject] @{
        TeamName      = $Team.DisplayName
        SharePointURL = Get-UnifiedGroup -Identity $Team.GroupId | Select -ExpandProperty SharePointSiteURL
    }
}

This PowerShell gets the list of all Teams and their associated SharePoint Online sites: 

find sharepoint sites of microsoft teams

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.