Email output separate rows by new lines

How To
1

Hi there, I have a really basic question, I think. How to separate rows inside an email content.

A pretty simple Scenario with 4 steps:

  • Get weather forecast from the weather app (for 3 days)
  • Text Aggregate them into one text SEPARATED by LINES
  • Set a Variable with the text
  • Send text by email

Scenario

image
image1516Ă—392 50.4 KB

The Text Aggregator seems to be separating the rows correct:

image
image1249Ă—790 87.3 KB

The input of the email looks OK, separated by rows:

image
image906Ă—632 52.5 KB

This is the Email module, taking the data from the variable (I also tried taking directly from the text aggregator and got the same result as below)

image
image430Ă—574 25.9 KB

All working well besides the fact I’m getting the text by email like this:
Oct 13 : Min: 16.11 - Max: 19.54 Rain (moderate rain) Oct 14 : Min: 14.74 - Max: 24.09 Clouds (overcast clouds) Oct 15 : Min: 17.01 - Max: 25.91 Clear (sky is clear)

whereas the desired result would be like this:
Oct 13 : Min: 16.11 - Max: 19.54 Rain (moderate rain)
Oct 14 : Min: 14.74 - Max: 24.09 Clouds (overcast clouds)
Oct 15 : Min: 17.01 - Max: 25.91 Clear (sky is clear)

any thoughts on how to fix?

2

This is a commonly-asked question.

You’ll need to send HTML, not plain text as output by the Text Aggregator.

To do that you need to use a Text Replace module to add paragraph tags to the start and end of each line before you can use it in the email.

Original string:

Screenshot_2023-10-01_184844

Output, HTML:

Screenshot_2023-10-01_185004
Screenshot_2023-10-01_185004874Ă—557 53.2 KB

For more information on how to do this, see https://community.make.com/t/how-to-start-a-new-paragraph-adding-signature-in-email/16781/2 and https://community.make.com/t/claude-gpt-new-line-outputs-for-html-email/16805/2

3 Likes
3

Thank you @samliew your direction and example solved the issue and I will mark it as solved !

I’m adding the module that solved the issue below.

IF you can explain the syntax as a bonus step it would be great, because I simply copy/paste without really understanding what it means:
Pattern
New Value
Text

image
image605Ă—888 59.5 KB

2 Likes
4

Sure, the pattern is basically replacing

  1. Unlimited spaces before

    \s*

  2. As many newlines and carriage returns

    [\n\r]+

  3. and unlimited spaces after

    \s*

With a closing paragraph tag and a new paragraph tag (see “New value”). So,

abc
def

ghi

becomes

abc</p>
<p>def</p>
<p>ghi

But those are all replacing newlines in-between each line, so you still need a starting paragraph tag and closing paragraph tag for the first and last line. Hence putting it here:
Screenshot_2023-10-13_141022

so you get

<p>abc</p>
<p>def</p>
<p>ghi</p>
5 Likes
5

Thank you @samliew I need some time to digest it, seems a bit complicated :laughing:

6

All good, there are no silly questions here, so if you have any further questions about the pattern or why it is done this way instead of another you thought of, just ask!

Here are more resources to learn about regular expression patterns:

Hope this helps!

2 Likes