Concat with new line

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I would like to know if it's possible to add a line return to a concatenate string.

I have this in the Text property of a label:

It returns this:

I would like it to return like this, but only if it will keep that formatting when patched to a SharePoint multi-line (Rich Text) field:

European Union, Austria, AT

European Union, Belgium, BE

European Union, Bulgaria, BG

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

BitLord69 914 on at

Like (5)

Report

Hi,

Add a "& Char(13)" at the end of the line. It adds a new line character to your string.

Good luck!

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (4)

Report
@JR-BejeweledOne

To add a line return you can use either of these:

Char(10)
Char(13)

The HTML version of this for Rich Text would be

<br>

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Sorry for the 'Noob' question, can you show me where in that line I would add it?

I am sure I will mess it up about a dozen times if I try myself.

Thanks

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@JR-BejeweledOne
Yes, but can you supply the current code in Text format please? I don't want to retype it from your image. I'm too lazy for that lol.

1 people found this reply helpful.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

I had to laugh because that's the exact reason I did a screen shot, although I suppose I 'could have' copied and pasted. I think it's a little easier to read when it's got the colors, and I am FAR to lazy for that.

Left( Concat( Filter(Markets, !IsBlank(Region) && !IsBlank(Country) && !IsBlank(CountryCode)), Region & ", " & Country & ", " & CountryCode & "; " ), Len(Concat(Markets, Region & ", " & Country & ", " & CountryCode & "; ")) - 2 )

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@JR-BejeweledOne

Here's where the code should be placed:

Left( Concat( Filter(Markets, !IsBlank(Region) && !IsBlank(Country) && !IsBlank(CountryCode)), Region & ", " & Country & ", " & CountryCode & "; " ), Len(Concat(Markets, Region & ", " & Country & ", " & CountryCode & ";"&Char(13))) - 2 )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Unfortunately that did not work.

Was this reply helpful? Yes No
xanax220 20 on at

Like (0)

Report

Did you ever find the correct way to do this?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report

Label.Text code: Label15.Text & ", " & Char(10) & TextInput6.Text

Was this reply helpful? Yes No
Cosmic_Kitchen 105 on at

Like (0)

Report

The Char(10) and/or Char(13) approach is not working for me right now - Am I doing something wrong?

Was this reply helpful? Yes No