Answered

Trying to add a Carriage Return in Email Body

(0) Share

Report

Posted on by Madhatter071

Newbie here... I am trying to insert a carriage return in a hardcoded email, but the Char(13) is not working, I also tried Char(10), Split(), and , all to no avail. You can see in the code below where I am wanting the carriage return. Please help!

Office365Outlook.SendEmailV2(
LookUp('Project Data',Title = RREWInput.Selected.Result).'RREW Manager Email', "Load Quality Audit for " & ProjectInput.Selected.'Store Number' & " on " & Today(), "Hi Team, " & Char(13) & "On" & Today() & " your load was audited for project " & ProjectInput.Selected.'Store Number' & ". Your load was rated as " & ConditionSelection.Selected.Result & ". " & "The following reasons were listed to explain the raiting:" & Char(13) & ActualSelection.Text & Char(13) & "Please see photo's attached", {Importance: "High", Attachments: LoadImages}
);

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Madhatter071

Your formula should be:

Office365Outlook.SendEmailV2( LookUp('Project Data', Title = RREWInput.Selected.Result).'RREW Manager Email', "Load Quality Audit for " & ProjectInput.Selected.'Store Number' & " on " & Today(), "Hi Team, On" & Today() & " your load was audited for project " & ProjectInput.Selected.'Store Number' & ". Your load was rated as " & ConditionSelection.Selected.Result & ". The following reasons were listed to explain the raiting: " & ActualSelection.Text & " " & "Please see photo's attached", {Importance: "High", Attachments: LoadImages} );

Also by using the concat shortcut ($), you can change to:

Office365Outlook.SendEmailV2( LookUp('Project Data', Title = RREWInput.Selected.Result).'RREW Manager Email', $"Load Quality Audit for {ProjectInput.Selected.'Store Number'} on {Text(Today(), ShortDate)}", $"Hi Team, On {Text(Today(), ShortDate)} your load was audited for project {ProjectInput.Selected.'Store Number'}. Your load was rated as {ConditionSelection.Selected.Result}. The following reasons were listed to explain the raiting: {ActualSelection.Text} Please see photo's attached", {Importance: "High", Attachments: LoadImages} );

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,127 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
When you used the did you put it in quotes?

Office365Outlook.SendEmailV2( LookUp('Project Data',Title = RREWInput.Selected.Result).'RREW Manager Email', "Load Quality Audit for " & ProjectInput.Selected.'Store Number' & " on " & Today(), "Hi Team, " & "On" & Today() & " your load was audited for project " & ProjectInput.Selected.'Store Number' & ". Your load was rated as " & ConditionSelection.Selected.Result & ". " & "The following reasons were listed to explain the raiting: " & ActualSelection.Text & " " & "Please see photo's attached", {Importance: "High", Attachments: LoadImages} );

Was this reply helpful? Yes No
Madhatter071 10 on at

Like (1)

Report
Copy link

Link copied!

Yes, that worked!!

Was this reply helpful? Yes No