Unanswered

String concatenate with new line

(1) Share

Report

Posted on by Perumal

604

I am trying to concatenate set of Text values with new line in between. I can't find way to add new line, tried "\n", which does not works. I am using Concatenate function.

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

hpkeong 2,944 on at

Like (2)

Report

Hi

Would you consider using html textbox?
Although html5 is not fully supported (e.g.: Table is OK, but border not supported), most of the html5 syntax can be used in PowerApps.

Was this reply helpful? Yes No
Perumal 604 on at

Like (0)

Report

Thanks for your suggestion.

My case:
---------------
I have a screen with set of TextInput boxes. On button click, I want to send a mail with values entered in the input boxes. In the mail, each value should be on a new line.

Was this reply helpful? Yes No
Verified answer

hpkeong 2,944 on at

Like (3)

Report

Hi

I have a series of Useful Features of PowerApps, and I remember it is No. 12, explain about how to use:
- Collection + Concatenate + Concate...to email with html format.

Hope it helps.

https://powerusers.microsoft.com/t5/PowerApps-Forum/Useful-Features-of-PowerApps-12-Email-amp-Concat/m-p/4554#M2125

The results from my Shopping Apps is sent to out with results as follow (this is actual results).

Actual email received

Hope this really helps.
(I spent weeks on this and wish it is what you want as no guidance in LEARN Tutorial)

Was this reply helpful? Yes No
Perumal 604 on at

Like (0)

Report

Okay, I can understand there is no direct way to a add concatenate new line with strings, we need to use a hidden HTML text control.

Thanks for your solution.

Was this reply helpful? Yes No
davidni on at

Like (19)

Report

Hi Perumal,

You can add a new line by using Ctrl+Enter in the formula bar, and new lines are perfectly valid withing quoted strings. Type the following formula for example:

"Hello" & "
" & "world"

Notice how there is a line break within the quotes.

Was this reply helpful? Yes No
Perumal 604 on at

Like (0)

Report

Thanks @davidni, I will try it.

Was this reply helpful? Yes No
rgruian on at

Like (12)

Report

Even though this post accepted a solution, for the record please note that you can append newline (CR) characters to any string.

    "new" & Char(13) & "line"

or:

    "new" & "
    " & "line"

If you need CRLF sequences instead, please use Char(13) & Char(10).

Was this reply helpful? Yes No
michowl Microsoft Employee on at

Like (0)

Report

I'm finding that when I use the newline in the text box

"My title
Has 2 lines"

It looks correct initially. But when I preview the app or reopen the app, the line break remains in the fx field, but visually, the linebreak has been removed entirely.

Visual representation:
My titleHas 2 lines

Was this reply helpful? Yes No
Mordikus 12 on at

Like (0)

Report

Hello hpkeong,

which app are you using in this screenshot ?

Thanks and have a nice day !

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

Hi, you may be interested in voting up this idea:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Add-optional-parameter-for-separator-string-to-Concat-and/idi-p/42394

Was this reply helpful? Yes No