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

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

9 REPLIES 9
Super User II
Super User II

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

View solution in original post

@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

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.

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (79,418)