Answered

Line breaks missing in Power Automate workflow email for SharePoint multiline columns

(0) Share

Report

Posted on by itchel123

Hello,

I have a SharePoint list which contains multiple multiline columns that's plain text. I have a Power Automate workflow that triggers when a SharePoint item is created or modified. Also, in the workflow, I have a Send an email (V2) action. In the Send an email (V2) action, I've switched the content editor to html by clicking </> and added columns from the SharePoint list as dynamic content.

In the Send an email (V2) action, I've added replace(<your input>, '\n',' '). I've also tried initializing a variable, adding '\n' as the value and then adding in the Send an email (V2) action, replace(<your input>,variables('NewLine'),' ').

In the SharePoint list item, I add content to a multiline column which contains line breaks. However, when the workflow is triggered and sends an email, the column's contents are in one line and doesn't contain line breaks as intended.

Is there a way to fix this?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mark Nanneman 991 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello itchel123.

Try putting an actual new line in a Compose, then use a replace function to replace all instances of that in your multiline text.

Here's an example.

One.

I use a select to select the "Multiline Text" column from a sharepoint list with multiline text values.

I also used a concat() to include each record's title, and to wrap it in to make it bold.

concat('',item()?['Title'],' ',item()?['MultiLineText'])

Two.

I store an actual new line in a compose action (literally just press enter once in it to create a new line character).

Three.

I join the output array from my select with a ' ', then wrap it in a replace() function to replace each new line (by referencing your Compose_New_Line compose) with " "
replace( join( body('Select'), ' ' ), outputs('Compose_New_Line'), ' ' )

Test Run

Hope that helps! If it does please give me a like and mark this as an answer.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

itchel123 46 on at

Like (1)

Report
Copy link

Link copied!

Hi Mark Nanneman,

Your suggested answer works for me. First, I've created a Compose action and pressed enter to create a new line character. Second, in the Send an email (V2) action, I've added the following: replace(<your input>,outputs('Compose_New_Line'),' ').

Thanks

2 people found this reply helpful.

Was this reply helpful? Yes No