But he is going too fast

Hi Remixah. You can try getting your list of group using the "List Groups" action. Then, check the prefix, using conditions, if the prefix is XXX, then perform put it into the csv table, else just ignore. For the number of members, just do a count to the output of the group member list generated from "List Group Members" action.

Hi Dany, you can do that by using "List rows present in a table" action to retrieve the list of emails to be added from Excel, then use "add a member to a team" to add the emails into the list. Hope this helps.

Hi there, from what I understand, List group members action could only get members in units of team and not channel. I am not aware of alternatives that can get the Teams channel members

Yes that's what I ended up confirming 😔 Thank you so much for response and your videos!

Hi David, if it's just a transfer of chat without attachment, then it's quite simple and possible to do. However, if attachments is involved, it's still possible, but additional steps are needed (custom connector needs to be created) as the native Microsoft Teams connector do not include the feature of posting a message with attachment.

@@JoelTing Hi Joel, I wasn't thinking of copying chat. I was thinking of copying resources (files and third party apps). If Teams is being used in an educational setting, and a teacher wishes to clone a Teams site (files, folders and digital embeds) and add a different cohort of students, the current set up in Teams does not permit this.That means a teacher has a huge overhead to manually create the same resources for a different class.

@@davidm2143 Hi David, from my understanding, you can Create Teams and use existing Teams as a template which copies channels, apps and the tabs. To copy files over, you can try looking into the Sharepoint of the team you are copying, highlight all the folders and copy them over to your new teams. It's 2 different steps though. Not really automated.

@@JoelTing Hi Joel, I'm thinking of embeds. Let's say you want to embed a KZfaq video, a form as a quiz, and a third party app (for example Planet eStream). All three of those applications embed sweetly into the chat area. If you wanted to clone that Team and replicate those 3 applications, Teams is not set up to do this yet. If a Teacher wants to create a template (including the fore mentioned 3 applications) and replicate that to say 15 other Teams, the teacher will have to create 15 teams and embed at least 2 of those apllications, 15 times. While the teacher can utilise the channel and Tab structure already set up from the template, he or she will not be able to bring those 3 embedded applications through to all 15 Teams. Obviously the more content there is embedded, will present a greater overhead when attempting to roll it out. Microsoft need a solution for this to make Teams/O365 competetive with other Learning Managment Systems. If you know of a work around with Automate or PowerShell, I would love to see you do a video on it?

Hi D S, yes. You will be able to get the team info that you are a member as well. You will get the choice to select them under the 'List Group Members' step. If you are trying to run a report of all the groups and you owned and belongs to, instead of 'List groups that I own', use 'List groups that I own and belongs to'

Hi merbond007, Yes, that's possible, just set an automated flow to get triggered when a new team member is added or new team member is removed, then add an Excel row in the created file that content the member list or remove the Excel row in the case of removal. Hope this helps.

Hi Dany, instead of appending the information of the group member, you can use the Excel connector ("Add a row into a table" step) to send the information over to Excel. Prerequisite here though is that you have to create a table in the Excel file itself so that Power Automate can recognize the table and add new inputs into it. Once you have selected your table, the column header of the table will appear in the step and you can just add the values to each column for every member. Hope this helps! Feel free to let me know if you need more clarification.

@@JoelTing Yes, I was able to achieve this. Thanks

Hi Dany, I'm not able to replicate similar message. You may check in the initialize variable step, make sure it is initialize as an array. Then in the append to array variable step make sure its in the following format: { "Column1Name": , "Column2Name": } This will enable the "Create CSV table" step to recognize the column headers from your array. Hope this helps!

@@JoelTing This is resolved now. I selected custom in create csv table

@@Dany-ns6hg Glad that it has been resolved. Great job on it! 😊

There seems to be a way to do it via Graph API. But using Power Automate, I don't think that's doable at the moment.

Hi! There is this new action now from Microsoft Teams List members Select Group Chat!