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.

Exporting a list of Team members: where do I find the Team's ID?

I want to export a list of email addresses for all members of a Microsoft Team, so I can email them (we need the email to be sent to the individual inboxes, not to the Team channel). Although this seems like a very basic function, apparently I have to use Power Automate to do it. I've got as far...

powerusers.microsoft.com

Use Power Automate to bulk export members from Microsoft Teams

How to use power Automate to easily export all the members from a Microsoft Team you own into an Excel spreadsheet.

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.