SharePoint Multiple lines of text column and Send an email Issue

(1) Share

Report

Posted on by WC-KSTILL

117

Currently if a user writes

In a multiple lines of text column, and then I send that in an email notification it will appear as

A B C D

Is there anyway for me to fix this?

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (3)

Verified answer

Brad_Groux 4,556 on at

Like (2)

Report

You'd want to follow basically what is done here - Retaining Line Breaks In Multi-Line Text Fields From Forms Pro - Megan V. Walker. Compose the multiple lines to URI encoding, a then replace the line break %0A with the desired formatting, such as </br>.

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

Was this reply helpful? Yes No
WC-KSTILL 117 on at

Like (1)

Report

I couldn't get this to work at all. Do you have a screenshot?

Was this reply helpful? Yes No
Brad_Groux 4,556 on at

Like (1)

Report

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

Was this reply helpful? Yes No
Verified answer

WC-KSTILL 117 on at

Like (3)

Report

I actually figured out a fix.

Create a variable (String) - Called it varNewLine. For the value I just hit enter so it has a space in it.

Create a new variable (String) with my multiple lines of text column as the value, in my case I named it varActionRequest.

Then in the email body did an expression

Replace(variables('varActionRequest'),variables('varNewLine'),'<br>')

Was this reply helpful? Yes No
Verified answer

Gumis 15 on at

Like (5)

Report

This is how I solved it at my place:
we need two compose (German "Verfassen") steps:
fx : replace(outputs('Verfassen_5'),decodeUriComponent('%0A'), '<br />')

That's it

Was this reply helpful? Yes No
JM007 3 on at

Like (1)

Report

It worked for me too, thanks!

Was this reply helpful? Yes No
MK-30080731-0 4 on at

Like (1)

Report

@Gumis

Haha! You sir, are a genius!!!

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (1)

Report

hi

So if i can bridge the gap on something.

1) If you are using Rich Text in a Multi-Line, then you are best to using HTML and why the br html worked

2) If you are NOT wanting to use that, then you would need to do what Brad said.

Its a very different situation and it goes further than the Multi-line text control and is why I am explaining. As you build other flows that get responses from APIs and etc you want to format things, or remove them, you have to understand that

deCodeUri etc is used to do thing like replace \n with a real carriage return (as \n means nothing to Power Automate) same for creating Tabs etc.

The standard Char expressions of \t \n etc do not work.

So its not that BR is the answer, its simply one and it depends on what you need long

Was this reply helpful? Yes No
QWales 40 on at

Like (0)

Report

A breakdown of the aforementioned solution from Gumis and a simpler one:

Add the column\field to a componse
Add this line to another compose replace(outputs('Compose'),decodeUriComponent(';">'), '</div>')
You are taking the output from the first compose and just taking the data between to points in the output you’ve been seeing, in this case between: ;”> and <div>

Simpler Solution:
The other way to do it is to add the action HTML to text. I put the field in a variable and added that to the HTML to text action but not sure if that is necessary. I put the Output in the subject field of my email and I just got the required content.

Was this reply helpful? Yes No