02-19-2020 10:06 AM
02-19-2020 10:06 AM
I wonder how I can export the list of members of a team to an excel or csv file. When there are some assignments, there is an export option in Grades tab and I can delete the extra columns; but I do not have a solution for the teams with no assignments.
02-19-2020 10:19 AMSolution
04-25-2020 01:40 AM
04-25-2020 06:54 AM
@Christopher Hoard I was doing a lot of digging on this because a client requested. I found this awesome script: https://blog.admindroid.com/managing-private-channels-in-microsoft-teams/
Only thing I noticed is before running the script (option 9) I had to manually run Connect-MicrosoftTeams for the script to successfully execute.
05-07-2020 02:58 PM
@Farhad Mazlumi Not the 'prettiest' method, but if you're a member of the MS Team, you should see the group in your Groups drop-down in your left pane in Outlook. Select the group, then create a new email. This should populate the To: line with the group name. Click on the group to expand its members (you may have to click on the "+### others) to fully expand the group. Copy all the members, and you have a semicolon-delimited list that you can import into Excel...
05-13-2020 10:10 PM
Check my Script -
05-21-2020 07:01 AM
05-30-2020 09:14 AM
07-09-2020 11:04 PM
@ChristianRoy, I agree it would be nice to be able to "manage" your Team membership by export as just a Team owner, especially in the app (and not fully blown admin). But I also think it would be good to allow admins to have the ability to pull the membership data without having to use PS like from the Office 365 Admin or Teams Admin dashboards. I know the horrors most of you might have at this idea, but some of us are stuck on other OS's and PS isn't available. If MS is to move to truly cloud based applications, they're going to have to realize some of these requests should be handled on the GUI cross-platform applications. Of all the reports I can pull for user activity (which are great), I can't pull a membership report for SharePoint or Teams for my entire organization (unless I'm missing something).
07-14-2020 08:38 AM
11-30-2020 03:16 AM - edited 11-30-2020 03:19 AM
@UXjoelplasWhen I asked my question, there was no grades tab in Microsoft Teams. But exporting the list of grades may be the best answer to my question these days.
It is noted that there is no grades tab in teams other than Class Teams.