✦Template Printable Ideas Insights

How to Export Org Chart from Microsoft Teams

By

In today's business landscape, collaboration is key, and Microsoft Teams has become an integral platform for fostering this connectivity. As your organization grows and evolves, maintaining a clear understanding of your team structure is crucial. One of the most effective ways to accomplish this is by creating an organization chart. But how do you go about exporting an org chart from Microsoft Teams? Let's delve into detailed, step-by-step instructions to make this process a breeze.

Before we dive into the process, it's essential to understand that Microsoft Teams itself doesn't have a built-in feature to export an organization chart. However, we can leverage a workaround by utilizing the Microsoft Graph API and Power Automate to achieve this task.

Utilizing Microsoft Graph API

The Microsoft Graph API allows you to interact with the Microsoft Cloud service and extract valuable data, including organization details. By using the Graph API, we can retrieve user details and build an organization chart accordingly.

an image of the settings in ubunt's web page on windows 10
an image of the settings in ubunt's web page on windows 10
Microsoft Teams Structure in Office 365
Microsoft Teams Structure in Office 365
Handy Cheat Sheets – Microsoft Office | CustomGuide
Handy Cheat Sheets – Microsoft Office | CustomGuide

To begin, you'll need to register a application in Azure Active Directory (Azure AD) and grant it the necessary permissions to access user data.

Registering an Application in Azure AD

1. Sign in to the Azure portal using an account that has permissions to register applications.

How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Use Microsoft Teams for Project Management
How to Use Microsoft Teams for Project Management
Préparer l’environnement pour un déploiement de Microsoft Teams - Training
Préparer l’environnement pour un déploiement de Microsoft Teams - Training

2. Click on 'Azure Active Directory' in the left-hand menu, then click on 'App registrations' and select 'New registration'.

Granting API Permissions

After registering your application, you'll need to grant it the required permissions to access user data. Here's how:

1. Go to your application in the Azure portal and navigate to 'API permissions' in the left-hand menu.

Microsoft Teams Cheat Sheet for Work, Meetings & Productivity (2026)
Microsoft Teams Cheat Sheet for Work, Meetings & Productivity (2026)
How to use Microsoft Lists in Teams
How to use Microsoft Lists in Teams
How to Create and Manage Teams Templates
How to Create and Manage Teams Templates
the microsoft teams and groups poster
the microsoft teams and groups poster
the microsoft team's dashboard screen is shown in this screenshote, and it shows
the microsoft team's dashboard screen is shown in this screenshote, and it shows
Teams Quick Ref Card Part-1/2
Teams Quick Ref Card Part-1/2

2. Click on 'Add a permission' and select 'APIs my organization uses'. Search for 'Microsoft Graph', then select 'Delegated permissions' and add 'Read all users' permission.

Using Power Automate

Power Automate is a cloud-based service by Microsoft that allows you to automate workflows across multiple applications without writing code. By integrating it with the Microsoft Graph API, we can automate the process of exporting an org chart.

Now that we have our application registered and the necessary API permissions, let's create a flow in Power Automate to extract the organization data.

Handy Cheat Sheets – Microsoft Office | CustomGuide
Handy Cheat Sheets – Microsoft Office | CustomGuide
How to use Workflows in Microsoft Teams
How to use Workflows in Microsoft Teams
Create and Manage All Your Mind Maps in Microsoft Teams! | Microsoft Community Hub
Create and Manage All Your Mind Maps in Microsoft Teams! | Microsoft Community Hub

Setting Up Power Automate Flow

1. Sign in to the Power Automate portal and click on 'People' in the left-hand menu. Select 'Flows' and then click on 'New'.

2. Click on 'Sign in to a service', then select 'Microsoft'. Choose 'Get my profiles' and click on 'Sign in', selecting your account and granting consent.

Extracting Organization Data

Now that we're signed in, let's add the actions to extract the organization data:

1. Click on 'Add an action', then search for and select 'Microsoft Graph'.

2. Choose 'List all users in a group (v1.0)' under 'Users' and click on 'Connect to data source'. Select your application and set the required parameters (e.g., group ID).

Creating the Organization Chart

With the user data extracted, we can now create the org chart. For this, you can use a third-party tool or a simple spreadsheet software like Microsoft Excel. Here's a basic process using Excel:

Importing Data to Excel

1. Export the extracted data from Power Automate as a CSV file.

2. In Excel, go to 'Data' in the main menu, then click on 'Get Data' and select 'From Text/CSV'. Locate and select your exported CSV file.

Formatting the Data

1. Once the data is imported, sort and filter the columns to extract the necessary information for your organization chart.

2. Use Excel's 'Text to Columns' feature to separate data in the 'DisplayName' column, which contains the user's first and last name concatenated.

With this setup completed, you now have a user-friendly process to export an organization chart from Microsoft Teams. By keeping your org chart up-to-date, you can foster better communication, collaboration, and understanding within your organization.

Looking forward, consider exploring advanced features like automated updates using Power Automate and dynamic org charts using data visualization tools. Embrace the power of Microsoft Teams and its integrated services to streamline your workflows and enhance your organization's productivity.