Multiline field displays as single line in a mail send by flow

(0) Share

Report

Posted on by RD

Hello,

I have a flow that sends an email on creation of a new sharepoint list item.

In this list i have multiline fields, when i add the dynamic content of a multiline field it places the content on a single line in the email.

So if the value of "Adres" is:

Straatnaam 1
6677 AA
Plaats

It wil be displayed in the e-mail as

Straatnaam 1 6677 AA Plaats

How can i change this?

regards

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (1)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@RD:

I just ran a quick test and found that I can reproduce your issue if I set "Is HTML" to yes in the email action. If you set it to No, that should resolve the issue. You can access this setting by clicking on Advanced Properties in the email action.

If this solves your problem, please mark your post as Solved.

Scott

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RD,

You could set up Send an email-IS HTML.

If you do not select any options or select No, the message content will be displayed like this:

If you choose Yes, the message content will be displayed like this:

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
victorwc 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft

What if I need to use html format?
Is there anyway to do this with HTML mail?

Was this reply helpful? Yes No
josephspengler 123 on at

Like (0)

Report
Copy link

Link copied!
I recently needed an HTML email that included multi line text from both both sharepoint and a text box within powerapps. I was able to find a solution.

Substitute(MyMultiLineTextField,Char(10),"<br>")

So leaving it as HTML, not plain text, then just converting the new lines to html breaks.

Was this reply helpful? Yes No
vwyankee 360 on at

Like (0)

Report
Copy link

Link copied!

@josephspengler - Can you elaborate on how/where you are adding this? I'm not seeing substitute as an option in an expression, whether using a Compose step or right within the Send an Email body.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (4)

Report
Copy link

Link copied!
@vwyankee this is what you want:

replace(outputs('multiLineText'), decodeUriComponent('%0A'), '<br />')

Hope this helps.

Was this reply helpful? Yes No
vwyankee 360 on at

Like (3)

Report
Copy link

Link copied!

Just about perfect. Thank you, @Paulie78 !!

I found I didn't need the space and forward slash and up with this which worked exactly as I needed:
replace(outputs('Get_item')?['body/MultiLineTextColumn'],decodeUriComponent('%0A'),'<br>')

*Edit*
For others that may have similar struggles the above worked only after I manually went into my test SP list item and set line breaks but didn't work for the items I needed to that were written from a Power App. Digging into the Flow outputs I discovered why. In Power Apps I'm using char(13) for line breaks which translate to %0D, not %0A - result when created using char(10) in Power Apps - in the string value. After updating the formula above to %0D it worked on the data that I needed it to.

I also understand now that @josephspengler is using the substitute operator in Power Apps not in Power Automate. I also had to utilize that for the same reason for a couple emails that are sent from Power Apps.

I don't recall exactly why I'm using char(13) vs char(10) but I want to say it was because I wasn't getting the line breaks to show in Power Apps using char(10). Now to educate myself on what the difference between the two are...

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I didn't find on the Advance mode the option for Sending an email-IS HTML.
My PDP comment value below is sending as a single line
Can you please advise how to get to this option
Appreciate the help
Almog

Was this reply helpful? Yes No
vwyankee 360 on at

Like (0)

Report
Copy link

Link copied!

It's the icon all the way on the right of your toolbar:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Ok, and what now, I want that "PDP Comment" dynamic content will show as Multiline
what I need to do? Do I need to create function or any other expression to enable it?
Thanks

Was this reply helpful? Yes No