Answered

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

(0) Share

Report

Posted on by 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?

I have the same question (0)

All responses (12)

Answers (1)

ChristianAbata 8,949 Most Valuable Professional on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
bryanc78 98 on at

Like (0)

Report

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

@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

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (1)

Report

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

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

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

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

Was this reply helpful? Yes No
bryanc78 98 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Verified answer

ChristianAbata 8,949 Most Valuable Professional on at

Like (9)

Report

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

@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-multi-line-column/td-p/643147

Was this reply helpful? Yes No
bryanc78 98 on at

Like (0)

Report

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

@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!

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

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

@bryanc78 excellent, is a good new 🙂

Was this reply helpful? Yes No
dimplun 16 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
diksha1 4 on at

Like (1)

Report

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

Hi, I tried following the above steps , but looks like neither decodingUriComponent nor uricomponenttoString is working. The mail shows the 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.

Was this reply helpful? Yes No
Calto 8 on at

Like (3)

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

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. <pre style="font-size: 9pt; font-family: Calibri, sans-serif;">[Your Power Automate dynamic element with line breaks]</pre> 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.

Was this reply helpful? Yes No