Unanswered

How to preserve line breaks from SharePoint multiline columns

(0) Share

Report

Posted on by CU09091757-0

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

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:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
CU09091757-0 299 on at

Like (0)

Report
Copy link

Link copied!
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....

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

Was this reply helpful? Yes No
twolf2286 12 on at

Like (0)

Report
Copy link

Link copied!
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>')

Was this reply helpful? Yes No
DS-21012133-0 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No