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.