Answered

Add Paragraphs to a multiline text box in a form when emailing

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have the below code in the body of an email (OnSuccess of a form), 1st Approver Comments and 2nd Approver Comments are a multiline text box that currently comes through in the email in one line rather than in paragraphs as the user has filled it out, I believe I need to use CHAR 10 or CHAR 13 for this but can you advise where I need to add that in please?

<b>1st Stage Comments: </b>" & EditForm_1.LastSubmit.'1st Approver Comments'&"<br>
<b>2nd Stage Comments: </b>" & 	EditForm_1.LastSubmit.'2nd Approver Comments'&"<br><br>

Thanks in advance

Categories:

Using Apps Using Formulas

All responses (4)

Answers (1)

WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report

Re: Add Paragraphs to a multiline text box in a form when emailing

@Dave-ITMan ,

That is not really evident from your initial post, but glad you solved it
Verified answer

Dave-ITMan on at

Like (0)

Report
Re: Add Paragraphs to a multiline text box in a form when emailing

Hi,

I've worked this out using the below code if anyone else has this issue in future

1st Stage Comments: " & Substitute(EditForm_1.LastSubmit.'1st Approver Comments', Char(10), " ") &" 2nd Stage Comments: " & Substitute(EditForm_1.LastSubmit.'2nd Approver Comments', Char(10), " ") &" 
Dave-ITMan on at

Like (0)

Report

Re: Add Paragraphs to a multiline text box in a form when emailing

Hi @WarrenBelz ,

Yes, that's what i'm using but it's putting all the text on one line e.g. test description of change line 3 and it should be:

test description of change

line 3

Regards
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report

Re: Add Paragraphs to a multiline text box in a form when emailing

Hi @Dave-ITMan ,

If you use Office365Outlook.SendEmailV2, you code will resolve as you expect.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps