Answered

Weekly Teams Summary - Based on "Forward emails to a channel"

(0) Share

Report

Posted on by DaRockwilda83

Hello everyone, I am currently experimenting with Power Automate and have already watched various tutorials. I have a specific scenario in mind, but I'm not getting anywhere (maybe it's not even possible?). Maybe someone can help me.

I have a Teams Channel "XYZ". When I receive an email with the subject "Article", a post is created in channel "XYZ". This works.

Now I would like to say after 1 week that a 2nd flow goes over it and summarizes these posts (let's say there are 7 of them) in a new post. So the individual 7 posts should not be posted separately again, but simply in one post one below the other.

I had thought about using "Get messages" (see screenshot) to get the previous messages. This also seems to work when I look at the output.

What would be the next step to display the messages in a new Weekly Report Post? Do I have to go over the entries via "Apply to each"? Or should I try another way?

All responses (3)

Answers (1)

DaRockwilda83 6 on at

Like (0)

Report

Re: Weekly Teams Summary - Based on "Forward emails to a channel"

Many thanks for this detailed flow, which works perfectly as I imagine.
Above all, I realized that I still have a lot to learn and that it was already too complicated at my level. Because honestly, I wouldn't have come up with this solution at the moment.
So thank you again!
Verified answer

harshdeol 412 Super User 2025 Season 1 on at

Like (1)

Report

Re: Weekly Teams Summary - Based on "Forward emails to a channel"

Hi @DaRockwilda83 ,

You're on the right way and as a next step use the Filter array to Filter these messages based on specific condition. After that use an "Apply to each" to iterate on Each message and append them in a String Variable (Initialize that variable at the Top) and send that "Weekly Report Post" message in the channel.

I create a Sample flow based on the requirements, please review, try it at your end and adjust accordingly.

//Here is the Complete Flow:

//Filter Array:

Get messages gives all messages in from the channel, so "Filter array" is used to Filter messages based on the condition.

<<Note: I configured it to get last 7 days messages. Please change it accordingly based on your requirements.>>

//Append to string Variable

Used to Append all messages in string, to post it into the channel.

<<You can use HTML here with message to format your message in Teams chat.>>

//Post a Message in Chat or Channel

Switch to Code view and use Variable here from the Dynamic Content.

//Input:

//Output

Please try and let me know if you face any issues.

-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.

Thank you,
Harsh Deol
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (1)

Report

Re: Weekly Teams Summary - Based on "Forward emails to a channel"

Hi @DaRockwilda83

so you want post something like this format :

Post Day 1

This is post for day 1

Post Day 2

This is post for day 2

Like that right ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌