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 the Microsoft Teams, do the following:

  • Navigate to the Microsoft team, Click on the “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.

Find All SharePoint Sites Connect with Microsoft Teams

From the SharePoint Online Admin center, You can get a list of all sites connected with Microsoft Teams 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”

microsoft teams sharepoint site url

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: 

Find SharePoint sites of Microsoft Teams

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

5 thoughts on “How to Find SharePoint Sites Associated with Microsoft Teams?

  • How do you connect when you need to use MFA?

    Reply
    • Just leave the Credential parameter! E.g. Connect-ExchangeOnline -ShowBanner:$False

      Reply
  • you might be able to change it using steps – https://www.sharepointdiary.com/2018/08/new-pssession-connecting-to-remote-server-outlook-office365-com-failed.html

    Reply
  • WinRM basic auth is required to be enabled in order to connect to the PS session

    Reply
  • got an error.

    New-PSSession : [outlook.office365.com] Connecting to remote server outlook.office365.com failed with the following error message : The WinRM client cannot process the request. Basic authentication is
    currently disabled in the client configuration. Change the client configuration and try the request again. For more information, see the about_Remote_Troubleshooting Help topic.
    At C:\Scripts\Get-MSteamsandAssociatedSites.ps1:11 char:12
    + $Session = New-PSSession -ConfigurationName Microsoft.Exchange -Conne …

    Reply

Leave a Reply

Your email address will not be published.