Concat a new line on outlook

Like (0) Share

Report

Posted on 21 Jan 2020 13:10:24 by oappdev

901

Happy Tuesday Power Apps Community.

i'm using the following Concat ( ) function. l'm i missing something ?

Office365Outlook.SendEmail("myemail@email.com","New Pitney Bowes","Now()";Concat(PitneyBowesCollection,DataCardValue7 & "; " &DataCardValue8 & ";" &DataCardValue1 & ";" & Category & "; " & SubCategory & "; " & ProductName & "; " & Quantity, Char(13)))

Categories:

General Questions

I have the same question (0)

All responses (10)

Answers (1)

oappdev 901 on 22 Jan 2020 at 12:59:40

Like (0)

Report

Re: Concat a new line on outlook

Thanks again for all your help @Pstork1 I finally got it working

Was this reply helpful? Yes No
Pstork1 67,989 Most Valuable Professional on 22 Jan 2020 at 12:49:22

Like (1)

Report
Re: Concat a new line on outlook

There is no way to do it automatically. You just have to add those labels to the Concat statement you are already using.

Concat(PitneyBowesCollection,DataCardValue7 & "; " &DataCardValue8 & ";" &DataCardValue1 & "; Category:" & Category & "; SubCategory:" & SubCategory & "; ProductName:" & ProductName & "; Quantity:" & Quantity, Char(13)Char(10))

Was this reply helpful? Yes No
oappdev 901 on 21 Jan 2020 at 13:40:53

Like (0)

Report
Re: Concat a new line on outlook

@mdevaney @Pstork1 Last question how can i add a Title to it
Category: Test | SubCategory: Test2 | ProductName, etc..

Was this reply helpful? Yes No
Pstork1 67,989 Most Valuable Professional on 21 Jan 2020 at 13:34:42

Like (1)

Report

Re: Concat a new line on outlook

I prefer the "<br />" also, but that does require that the email be HTML. If you are in an environment where plain text emails are enforced then the Char(13)Char(10) will still work. So sometimes its necessary.

Was this reply helpful? Yes No
oappdev 901 on 21 Jan 2020 at 13:33:38

Like (0)

Report
Re: Concat a new line on outlook

@mdevaney Now that i got it working. I will also try that approach 👍

"<br>"

Was this reply helpful? Yes No
oappdev 901 on 21 Jan 2020 at 13:31:42

Like (0)

Report

Re: Concat a new line on outlook

That did the trick @Pstork1 Sorry on my first cup of coffee.

Thank you so much

Was this reply helpful? Yes No
Verified answer

Pstork1 67,989 Most Valuable Professional on 21 Jan 2020 at 13:26:30

Like (2)

Report

Re: Concat a new line on outlook

Sorry, I wasn't clear enough. You need BOTH a carriage return and a line feed. So don't replace the one with the other. Use both Char(13) & Char(10)

Was this reply helpful? Yes No
mdevaney 29,987 Moderator on 21 Jan 2020 at 13:26:08

Like (3)

Report
Re: Concat a new line on outlook

@oappdev

Personally, I like to use HTML line breaks in email.

"<br>"

I think you'd do it like this.

Office365Outlook.SendEmail("myemail@email.com","New Pitney Bowes","Now()";Concat(PitneyBowesCollection,DataCardValue7 & "; " &DataCardValue8 & ";" &DataCardValue1 & ";" & Category & "; " & SubCategory & "; " & ProductName & "; " & Quantity & "<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
oappdev 901 on 21 Jan 2020 at 13:20:27

Like (0)

Report
Re: Concat a new line on outlook

Thank you so much for the quick reply @Pstork1

i change it to Char(10)
Office365Outlook.SendEmail("myemail@email.com","New Pitney Bowes","Now()";Concat(PitneyBowesCollection,DataCardValue7 & "; " &DataCardValue8 & ";" &DataCardValue1 & ";" & Category & "; " & SubCategory & "; " & ProductName & "; " & Quantity, Char(10)))

Was this reply helpful? Yes No
Pstork1 67,989 Most Valuable Professional on 21 Jan 2020 at 13:14:31

Like (0)

Report

Re: Concat a new line on outlook

Char(13) is a carriage return. But I think what you are actually looking for is a carriage return with a line feed. That would be Char(13) & Char(10). Char(10) is the actual linefeed.

Was this reply helpful? Yes No