Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to preserve line breaks from SharePoint multiline columns

(0) ShareShare
ReportReport
Posted on by 299

I've done some research on here in regards to Power Automate preserving line breaks, but nothing matches my scenario yet.

 

I have a SharePoint list, that has a multiline column with no rich text.  It's plain text.  But I do have line breaks in the column so that its easy to read paragraphs of content.

 

When I attempt to connect to this column content in Power Automate, its stripping? all the line breaks and making it all as one paragraph.  

 

Here is my setup in Power Automate....

 

kensley_0-1614804576706.png

All I want to do is tell Answer (my SharePoint column value) or response, to allow the original lines breaks to be included.  What must I do to accomplish this?

 

Thanks

 

 

  • DS-21012133-0 Profile Picture
    DS-21012133-0 2 on at
    Re: How to preserve line breaks from SharePoint multiline columns

    @twotwo do you have screenshots of your flow to share please?

  • twolf2286 Profile Picture
    twolf2286 12 on at
    Re: How to preserve line breaks from SharePoint multiline columns

    I know this is an old post but I was looking for the same answer so I'll post what I found here.

     

    I simply used <br> (html for line break) and it worked! I think I was going the opposite direction but I think the issue has something to do with it being html, so an html to text may help in the above scenario.

     

    UPDATE:

    Immediately after posting this I noticed I had the same problem going the other way. My solution was to create a string variable called newline, and set it to a carriage return. Then I did a replace on the input, replacing all newlines with <br>.

    replace(<your input>,variables('NewLine'),'<br>')
  • CU09091757-0 Profile Picture
    CU09091757-0 299 on at
    Re: How to preserve line breaks from SharePoint multiline columns

    No because of 2 reasons 

    • I am not a regular expression expert just yet...still learning
    • I am not using my variable to compose an email

    Regardless, I'm trying to apply what you see there and I came up with this....

     

    kensley_0-1614806176590.png

     

    But when I test, its throwing an error.  If this is wrong how I am going about it, please disregard my diagram. I just want to preserve the original line breaks from my "Answer" column from my SharePoint list.

     

    Please help

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: How to preserve line breaks from SharePoint multiline columns

    @kensley

    Have u tried the suggested solution in the below post?

    https://powerusers.microsoft.com/t5/General-Power-Automate/Preserve-line-breaks-from-CDS-Multiline-Text-field-in-HTML-email/m-p/452561#M44987

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard