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?

Microsoft Teams is a collaboration tool that allows team members to communicate and collaborate on projects. Every Microsoft Teams created has a SharePoint Site associated behind the scenes to store files. If you’re looking for a specific SharePoint site associated with Microsoft Teams, there are several ways to find it. To find the SharePoint site of the team from Microsoft Teams, do the following:

1. Navigate to the Microsoft team, Click on the “Files” tab, and you’ll find a button “Open in SharePoint”.

This opens the SharePoint Online site of the particular Microsoft Teams.

Find All SharePoint Sites Connect with Microsoft Teams

You can get a list of all sites connected with Microsoft Teams from the SharePoint Online Admin center by filtering the “Teams” column. Just click on the drop-down under the “Teams” column, Choose “Filter by Teams” and then “Connected to Microsoft Teams”.

Get a List of All Teams and their associated SharePoint Sites using PowerShell

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
  
#Connect to Exchange Online
Connect-ExchangeOnline -Credential $Credential -ShowBanner:$False

#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: