Import MS Team Members to Excel Spreadsheet

[EdwardSurrey]

Is there away in Excel to import a list of members of a Teams Site? I thought about perhaps using the Microsoft Graph API to do it.

In my company, we create lots of Team Sites and in Excel I want a simple way of being able to drop down to choose people who are in that team.

People get added to the Team Site as the project goes on so I need this approach to be dynamic and be updatable at the touch of a button.

Currently we have to type out all the names and job titles.

 

[GraH]

Maybe this can help. I have not tried it at work, but this was the first thing that came to mind.

Forums | Microsoft Power Platform Community

Quickly search for answers, join discussions, post questions, and work smarter in your business applications by joining the Microsoft Dynamics 365 Community.

powerusers.microsoft.com

Use Power Automate to bulk export members from Microsoft Teams

How can I quickly export a list of all members in a specific Team? As a Microsoft Team's owner you have probably come to the conclusion that managing your Team

nikkichapple.com

And a third one:

 

[EdwardSurrey]

@GraH Thanks for your help. That second link definitely solves part of the problem.

The issue is, the Excel Spreadsheet where I want this information deposited will vary. I can't specify the location or Team ID etc in the flow itself. I need a way to pass that information dynamically from Excel to the Power Automate flow. Is that possible?

 

[GraH]

Honestly, totally clueless here.
Power automate for sure can handle the variable, but if there is a way to trigger a flow from an excel variable input cell, I would not know.

 

[EdwardSurrey]

Honestly, totally clueless here.
Power automate for sure can handle the variable, but if there is a way to trigger a flow from an excel variable input cell, I would not know.

Thanks for getting back to me.

I have actually managed it by using an Office Script in the 'Automate' tab of Excel, which triggers a Power Automate flow. In the headers of the trigger it hands over the information it needs (Teams ID, folder structure, filename), and the flow uses that to then query the members list and the amend the Excel file with their names etc.