Microsoft Tech Community Live:  Microsoft Teams Edition
November 09, 2021, 08:00 AM - 12:00 PM (PST)
SOLVED

export Organization structure

%3CLINGO-SUB%20id%3D%22lingo-sub-1612752%22%20slang%3D%22en-US%22%3Eexport%20Organization%20structure%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612752%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20export%20the%20org%20structure%20tree%20in%20some%20format%20(CSV%2C%20JSON%2C%20xls%2C%20other)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612764%22%20slang%3D%22en-US%22%3ERe%3A%20export%20Organization%20structure%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612764%22%20slang%3D%22en-US%22%3EAfaik%20no%20unfortunately%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Vote%20for%20it%20here%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F38436874-entire-organisation-org-chart-tab-or-export%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F38436874-entire-organisation-org-chart-tab-or-export%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612791%22%20slang%3D%22en-US%22%3ERe%3A%20export%20Organization%20structure%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612791%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20there%20is%20no%20way%20to%20export%20this%20out%20of%20Teams%2C%20the%20org%20chart%20is%20build%20based%20on%20information%20stored%20within%20your%20directory%2C%20which%20you%20can%20query%20programmatically%20via%20PowerShell%20or%20the%20Graph%20API%20to%20build%20your%20own%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

Is there a way to export the org structure tree in some format (CSV, JSON, xls, other)?

3 Replies
best response confirmed by ThereseSolimeno (Microsoft)
Solution

While there is no way to export this out of Teams, the org chart is build based on information stored within your directory, which you can query programmatically via PowerShell or the Graph API to build your own solution.

@Vasil Michev Not a good response as this does not provide even the request URL nor the Powershell Module/cmdlet to use. I must also point out that Theresa should not have been able to mark this as the best response (should be up to the requester) as a Microsoft agent. The Microsoft agent is pretty byast especially considering the lack of information/direction in the answer (microsoft graph is a huge API you could have at least provided the exact get to call, not to mention provided some template code based off what Teams uses).