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 as Manually trigger a flow, then Choose an action. In Azure AD I can see an option to Get Group Members. If this is the option I need, I fail at the next step, which requires me to enter the group ID. I have no idea where to find the group ID for a Teams group. Can anybody point me in the right direction, please? I'm not a technical admin - I don't use any of the AD backend functions, or PowerShell. I just a simple way of getting the ID.
So you at least have the Team's name and you are one of its members, right?
If so, please note every TEams has an Office 365 group behind
So I would add 'Office 365 group' 'List group members' action block and select my target team from the drop down menu:
This action block will provide you an array of object, each object represents a member of the Team. Some useful attributes inside: email, Name, etc.
Hope this helps
Thank you @efialttes - I was looking in the wrong place. I started by searching for 'members' within the Teams option, but drew a blank. Then I did a global search, and the first likely option was Azure AD - 'get team members'. Selecting that option doesn't give you a drop-down list of teams - you have to manually enter a team ID, hence my confusion.
The flow has run correctly. Now I need to figure out where the data has been exported to!
Hi ! How do you configure the List group members action to get all of the members? Default is 100, but when you set (increase) the top to retrieve more, it still only brings a subset, not all of them.
@Gbubu havent tested myself Tems with more than 100 members, but according to your description seems there is a limitation in either the API call, or the way the connector is implemented.
You always get 100, no matter the value assigned as the top value?
It happens in other connectors also, Planner also has a limit and cannot read more than 400 tasks
The good news for your use case are, you can obtain up to 1000 members of a Team, according to the Office 365 connector documentation. Just remember to activate pagination under 'Settings':
|List group members||
This operation returns a list of all members in the given group and their details such as name, title, email, etc. You can query up to 1000 items using Top parameter. In case you need to retrieve more than 1000 values please turn on Settings->Pagination feature and provide Threshold limit.
Not in my laptop, unable to test
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.