Hi everyone, I need help with a weekly summary email workflow.
I have a table called Competition Results, and each row has a Date and some other details.
Goal:
Send one single email per week that lists all rows that happened in the last 7 days.
Current Issue:
Right now, my workflow is sending one email per row, because the Send Email action is inside the loop. I want to combine all the rows into one message and send one email only.
What I need guidance on:
- How to collect all rows from the last 7 days .
- How to join all of those rows into one text block.
- How to send one single email after joining the text.
You can use the Generate CSV action.
- In your Competition Results table, create a Math column that returns the Date 7 days ago. (
Now-7)
- Create a Query column that targets the Competition Results, and filter where Date is after 7 days ago.
- Use that Query as the source of a Generate CSV action, and include that in an email.
As long as your Competition Results table is not a Big Table, that should work.
1 Like
Thanks for the response!
I’ll break down my requirement a bit more:
I don’t want to send it as a CSV attachment.
The number of rows per week is small (around 10–15), so I want the details to be shown directly in the email body, as a readable list — not as a file to open.
So basically:
- Filter rows where Date is within the last 7 days
- Take those rows
- Join them together using Joined list
- And send one single email containing that text
Right now, my workflow is sending one email per row, because of the loop.
I’m trying to figure out the right way to combine all matched rows into a single text block and then send only one email.
Okay, so use the Query column as I described, create a Template column that concatenates the columns in each row that you need, then use a Joined List through the Query to gather all rows. In the workflow, just send the result of the Joined List in a single step - don’t use a loop.
1 Like