cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78
Helper III
Helper III

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

10 REPLIES 10
ChristianAbata
Community Champion
Community Champion

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

 

linebreak.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@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

 

2020-07-30_10-21-25.png

 

 

 

 

 

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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

 

 

 

 

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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

@bryanc78  excellent, is a good new 🙂



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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

diksha1
Regular Visitor

diksha1_0-1610012660968.png

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
New Member

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (4,404)