Send an email (V2) - doesn't support line breaks from SP list multi-line column type?

[bryanc78]

In a SP list, I have a multi-line column type where we enter paragraphs with spaces between the paragraphs.  Send Email (V1) correctly shows these spaces . Send Email (V2) runs the sentences together and basically makes this V2 useless for my situation.

Is there a setting I'm missing or is this how it is?

[ChristianAbata]

hi @bryanc78  you can use HTML br to do a line break

[bryanc78]

@ChristianAbata 

Doesn't that creates line breaks for text I enter in the flow itself?  But what about a data field I bring in from a SharePoint list?  How do I get those line breaks to appear?

If you look at the below Evaluation Notes field, that field in SP has say 4 paragraphs with line breaks in-between each paragraph.  I need those line breaks to also show up in the email

[ChristianAbata]

@bryanc78  what you can do is add a compose value to replace your /n or ?n to <br>, this can be made using expression

your expresion could be like replace('YOUR SHAREPOINT COLUMN HERE', '/n','<br>')

then you can use the compose output to send it to mail.

[bryanc78]

@ChristianAbata  do you know of a good blog post or guide that could walk me through that?

[ChristianAbata · Accepted solution]

@bryanc78  I make a tutorial please see my post in my blog

https://www.christianabata.com/2020/07/line-breaks-from-sp-list-multi-line.html

you can found the flow to import here

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Line-breaks-into-an-Email-from-SP-list-m...

[bryanc78]

@ChristianAbata 

That worked like a charm.  The last compose did not have the code visible but I just used the original code and replaced it with decode.

Thank you for taking the time to create this tutorial.  Very useful!

[ChristianAbata]

@bryanc78  excellent, is a good new 🙂

[dimplun]

OMG this is exactly what I need. Thank you very much

[diksha1]

Hi, I tried following the above steps , but looks like neither decodingUriComponent nor uricomponenttoString is working. The mail shows the <br> tag in the body as-is. My multiline field in sharepoint is plain-text. However, I tried with Rich Text as well, but that came as all HTML tags. Please help.

[Calto]

Web developer here. I'm running into the same issue here. You can also solve this with the HTML tag <pre> which respects preformatted text and preserves line breaks. It outputs a monospaced font with quite a large font-size, which I overrule with inline CSS. See https://www.w3schools.com/tags/tag_pre.asp

You should type your email directly in HTML with the Code View. Example:

A line of text.<br>
<pre style="font-size: 9pt; font-family: Calibri, sans-serif;">[Your Power Automate dynamic element with line breaks]</pre><br>
Another line of text.

Btw, I found switching back and forth between the Code View and Html View not working correctly. It seems to "try to correct" my HTML code but instead messing things up, replacing `pt` with `px` and other weird things. So I just keep it in Code View.

[Lasherza]

Hi @ChristianAbata , 

Hope you get to read this...

I am trying to follow this solution for line breaks from Powr automate. I am struggling with the part :Value: in the apply to each field.. Do i need to change something?

Thank you for any help...