cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JR-BejeweledOne
Super User
Super User

Concat with new line

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:

 

ConcatFormula.png

 

It returns this:

ConcatResults.png

 

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



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
7 REPLIES 7
BitLord69
Memorable Member
Memorable Member

Hi,

 

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

 

Good luck!

mdevaney
Super User
Super User

@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."

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



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

@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.

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 )

 



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

@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."

Unfortunately that did not work.



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,244)