How to send multiple rows in an email body to me

[Adrian_Boo]

Hi,

I have a flow where I import a daily turnover csv file, then format and group data to get to this table:

Then, I want to send me all that data in only 1 email, putting all the rows in the same body of the email, not an email for each row.

I could do it to putting all the rows in the same json to send to an api.

How can I do this?

[daniel]

Hey @Adrian_Boo,

This can be done using an “Insert Text Column” step along with a “Merge duplicate rows” step. This will merge your rows using a unique identifier and a delimiter. Here’s an example of my mock data:

This is an example of what the final flow could look like:

Since you want your data in a single row, use the “Insert Text Column” step to create a Merge column and give it a unique value of 1.

Using the “Merge duplicate rows step” you should now be able to merge the rows in each column together using a comma delimiter and using the Merge column as the unique identifier.

The “Select columns” step is used to remove that Merge column. If you need to format your data as JSON, feel free to use additional “Insert Text Column”, “Find and Replace”, and “Combine columns” steps to further format your data. Otherwise, the “Send emails by row” step should do the trick.