Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Step 1:
Create a Flow using the blank template and select "Recurrence" as the Trigger
Step 2:
Define the schedule for the Flow trigger to send the summary email for MS Team conversations/posts.
In my scenario I have selected a weekly schedule for sending the summary email (every Monday at 8 am)
Step 3:
Add the Get Messages (Preview) action from the Microsoft Teams connector and select the MS Team and Channel for retrieving the messages
Step 4:
Filter the messages to only retrieve the latest messages (based on the Created Date of the message) .
Use the "Filter array" action to retrieve messages created in last 7 days (weekly).
This can be customized based on your schedule requirements.
Utilize the ticks function to compare dates as shown in figure below
Filter array From - "Message List" from the "Get messages" action
Filter condition - "@greater(ticks(item()?['CreatedDateTime']), ticks(addDays(utcNow(), -7)))" checks if the message created date time is greater than 7 days from today
Step 5:
List all MS Team (Office 365 group) members using the "List group members" action from the "Office 365 Groups" connector.
Select the Office 365 group related to the Microsoft Team
Step 6:
Create comma separated list of email addresses for each group member retrieved
Use Select action to retrieve only the Mail property from the list of group members
Then utilize the Join action to Join the mail addresses obtained from Select statement with ";"
Step 7:
Create email message body from filtered array of MS Teams messages
Use Select action to fetch only the required attributes from the filtered array of Messages
Utilize the "Switch to text mode" to create your own email message summary from the "Body" output of the "Filter array" action of the Message list obtained
Map attribute : "Posted By <b> @{item()?['from']?['user']?['displayName']} </b>on @{formatDateTime(item()?['createdDateTime'],'MM-dd-yyyy')}</br></br>@{item()?['body']?['content']}"
The above mapped attribute renders the display name of the user creating the message along with the created date & time and the message body content
Create Join action to combine each message (utilize the Output from the previous select statement)
This creates a string of messages to be sent to the email body
Step 8:
Send the email to the group members
Email to - Output from Join statement of group members list
Body - Output from Join statement of message body
Complete Flow looks like below
And the weekly summary email looks like the followingThanks for reading!!
Comments
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
This seems to only apply to Teams/Channels which we don't use. Is there a way to get the same daily summary with group and individual chats?
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Greetings!
I got the flow to work with one channel in out Teams, is there a way to have it combine posts within multiple channels?
Thanks!
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Hi there
Super useful, but I am a total novice and I am struggling with Step (
Step 8:
Send the email to the group members
Email to - Output from Join statement of group members list
Body - Output from Join statement of message body
Where in the world do I get the Output from Join statement etc? I cannot figure out where or how I can find the necessary information. Please help!
Thanks
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Hi @RezaDorrani @BenUK @Anonymous @BryceHarvey @he-man ,
My flow works but the weekly summary does not pull in replies to a post. Is it possible to do that? Please help.
Thanks!
Carclea -
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
This is a bit tricky for those new to PA, which I am.
Same as Geoff, it doesn't keep the double quotes for the message part on the flow.
But the email address selection doesn't seem to work, keep getting run-time error of email not being string/value. All the steps work except the final email bit due to that error.
Also, screenshot of flow steps doesn't look to match step order detailed in text. When I arrayed to match the screenshot it worked, with the email sent to a typed in address.
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
so i have the flow running, there are t
@RezaDorrani i have the flow running, couple of issues.
1. it keeps dropping and i have to cut and paste it each time...."Posted By <b> @{item()?['from']?['user']?['displayName']} </b>on @{formatDateTime(item()?['createdDateTime'],'MM-dd-yyyy')}</br></br>@{item()?['body']?['content']}"
2. i cant seem to pull the posts from teams into the summary, its blank...
any tips.
geoff
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Hi @RezaDorrani i just built this with the idea of the flow pulling a weekly summary of all of the posts my team has made to a specific channel. I have them using a tag teamcanadawins in the post. I have the flow working but its not pulling their posts. any tips to help grab the posts made with the tags?
Geoff.
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Thank you @RezaDorrani for this article. I'm interested in what I would need to add to have the direct link for the post in teams to show up in the body of the email with the post? Is this possible? Thank you in advance for your assistance.
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Thanks @RezaDorrani for this! I am also interested if there's any solutions for what @he-man has posted regarding fixing the display of Teams images in the summary email. It would be a great, added feature to be able to see the images that accompany the text.
-
Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule
Images from the Teams Posts doesn't work when using this recipe. I think it might be because the images in the emails are embedded with reference to the Graph API of Teams, in which you don't have a valid access token directly from Outlook
So, any ideas on how to fix this?
*This post is locked for comments