web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to preserve line b...
Power Automate
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

 

 

Categories:
I have the same question (0)
  • DS-21012133-0 Profile Picture
    2 on at

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

  • twolf2286 Profile Picture
    12 on at

    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
    299 on at

    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
    11,415 Moderator on at

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 258 Super User 2025 Season 2

#2
trice602 Profile Picture

trice602 205 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 204 Most Valuable Professional

Last 30 days Overall leaderboard