Concat a new line on outlook

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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
oappdev 901 on at

Like (0)

Report
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
mdevaney 29,989 Moderator on at

Like (3)

Report
@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
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (2)

Report

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
oappdev 901 on at

Like (0)

Report

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

Thank you so much

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

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

"<br>"

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

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 at

Like (0)

Report
@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 68,697 Most Valuable Professional on at

Like (1)

Report
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 at

Like (0)

Report

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

Was this reply helpful? Yes No