Thank you, I appreciated a lot this video. Is it possible to distinguish between type of users or roles (owner/member) in the export table? To me it seems to work only if the user is a owner, simple members are not listed in the output. Thank you very much
Unfortunately, the output of "List group members" does not provide any indication of each member's role. It should return all members, regardless of role. There may be some group types (for example, org-wide teams) that may behave differently, but there are no exceptions mentioned in the documentation for the Office 365 Groups connector (learn.microsoft.com/en-us/connectors/office365groups/).
Not using the Teams connector. This will return their email address and a few other fields (job title, phone number, etc.), but not their department. You could use the Office 365 Users connector to get their full profile, which will have their department.
FOLLOW UP: Seems like the table was limiting itself to 100 rows of data. I updated the flow to show the top 300 results (since I know there are just over 200) and that got me all of my group members.
On most places you see a "top count" setting, the default will be 100, even if it says something else (like "all"). Depending on how much data you want to get, you might also need to enable pagination (in the action's settings).
@@cvkealey I want to set up a recurring task in Power Automate to capture Teams messages from a specific channel (between timestamps), save them to OneDrive in a file, and email them to a designated ID.
@@RamKumar-jo4iu I don't believe that's possible with out-of-the-box actions in the Teams connector. There's a "get messages" action, but it only takes the team and channel as inputs, so it's not possible to filter the results to a specific time frame. I mean, if you REALLY need this, the simplest way would be to use an automated flow (when a message is sent in channel) to record the relevant data (like the message ID) to a table or list along with a sent timestamp, then have your scheduled flow check that list (get items) and filter to sent timestamps within the window. It'd be a lot of work and probably not worth it, but I don't know your use case/requirements.
Assuming you mean private or shared channels, there's no "out of the box" method for that in Power Automate. It may be possible using the Graph API (see stackoverflow.com/questions/66469198/graph-api-getting-team-channel-members-from-private-channel).
Thank you for making this video. How do you do this if you have more than 1 Group ID? Can we merge or join everything in one html table and how do we store everything in a Sharepoint List?
You can repeat the same "list members" step for each group. If you want them all in one table, create an array variable and append the output of each action to it, then use that variable as the input to the create table action. To put the data into a SharePoint list, first create the list, then use the variable as the input to an apply to each loop and add a create item action inside the loop.
First of all, i would like to thank your for this superb guide. Two questions: - in the end, we can see that the data is not sorted alphabetically. Is it possible to do it and send the email sorted by names? - is it possible to get the user department or any other criteria we find relevant? Thanks in advance
Yes, you can use the "Sort" expression to (you guessed it) sort the output. This is a really good video to demonstrate how to use it: www.flowjoe.io/2022/09/29/power-automate-functions-sort-sort-arrays-by-default-or-by-column/
Sorry, I missed your second question. Yes, you can feed the email to the "Get user profile" action (from the Office 365 Users connector) to get the information shown on their contact card (manager, department, etc.).
Perfect! That's exactly what i'm looking for. Thanks!
Thank you, I appreciated a lot this video. Is it possible to distinguish between type of users or roles (owner/member) in the export table?
To me it seems to work only if the user is a owner, simple members are not listed in the output.
Thank you very much
Unfortunately, the output of "List group members" does not provide any indication of each member's role. It should return all members, regardless of role. There may be some group types (for example, org-wide teams) that may behave differently, but there are no exceptions mentioned in the documentation for the Office 365 Groups connector (learn.microsoft.com/en-us/connectors/office365groups/).
Awesome video! Thank you! Is there anyway to pull the member’s departments?
Not using the Teams connector. This will return their email address and a few other fields (job title, phone number, etc.), but not their department. You could use the Office 365 Users connector to get their full profile, which will have their department.
Is there a limit to the number of rows? My data is being cutoff at 100 results but I know the Teams group has 212.
FOLLOW UP: Seems like the table was limiting itself to 100 rows of data. I updated the flow to show the top 300 results (since I know there are just over 200) and that got me all of my group members.
On most places you see a "top count" setting, the default will be 100, even if it says something else (like "all"). Depending on how much data you want to get, you might also need to enable pagination (in the action's settings).
Great Content, How to mail the Teams messages between timestamps from particular channel.
Sorry, I'm not sure I understand your question. I do know that you can't send mail *from* a teams channel. It's not a mailbox.
@@cvkealey I want to set up a recurring task in Power Automate to capture Teams messages from a specific channel (between timestamps), save them to OneDrive in a file, and email them to a designated ID.
@@RamKumar-jo4iu I don't believe that's possible with out-of-the-box actions in the Teams connector. There's a "get messages" action, but it only takes the team and channel as inputs, so it's not possible to filter the results to a specific time frame. I mean, if you REALLY need this, the simplest way would be to use an automated flow (when a message is sent in channel) to record the relevant data (like the message ID) to a table or list along with a sent timestamp, then have your scheduled flow check that list (get items) and filter to sent timestamps within the window. It'd be a lot of work and probably not worth it, but I don't know your use case/requirements.
@@cvkealey Thank you for the detailed response and suggestion. I will try and let you know
Awesome Video. Helped me alot!!!! Thanks :)
how about a channel members?
Assuming you mean private or shared channels, there's no "out of the box" method for that in Power Automate. It may be possible using the Graph API (see stackoverflow.com/questions/66469198/graph-api-getting-team-channel-members-from-private-channel).
Thank you for making this video.
How do you do this if you have more than 1 Group ID? Can we merge or join everything in one html table and how do we store everything in a Sharepoint List?
You can repeat the same "list members" step for each group. If you want them all in one table, create an array variable and append the output of each action to it, then use that variable as the input to the create table action. To put the data into a SharePoint list, first create the list, then use the variable as the input to an apply to each loop and add a create item action inside the loop.
First of all, i would like to thank your for this superb guide. Two questions:
- in the end, we can see that the data is not sorted alphabetically. Is it possible to do it and send the email sorted by names?
- is it possible to get the user department or any other criteria we find relevant?
Thanks in advance
Yes, you can use the "Sort" expression to (you guessed it) sort the output. This is a really good video to demonstrate how to use it: www.flowjoe.io/2022/09/29/power-automate-functions-sort-sort-arrays-by-default-or-by-column/
Sorry, I missed your second question. Yes, you can feed the email to the "Get user profile" action (from the Office 365 Users connector) to get the information shown on their contact card (manager, department, etc.).
Thanks!
Habiluddin(governor).s/o.abdulkarim.2no.balarchar.bngn