Unanswered

Multi-line variable inserted into email as single line

(0) Share

Report

Posted on by ericmabkv

Hello community,

I have a simple PAD flow that will run a PS script and output the results to a variable. The variable appears to have multiple lines as it should:

I then insert the variable into an email. When the email is sent, the contents of the variable appear as a single line only.

How can I get the variable to appear in multiple lines in the email?

Thanks,

Eric

Categories:

Power Automate Desktop

I have the same question (0)

All responses (14)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try a split text by NewLine.

Then try to rejoin it with JoinText...should look more like this:

Try putting JoinedText into the email and see if that works.

If it doesn't...let us know, we will look further into it.

Do you have access to change the python output? If so, we may look into changing that code to do a new line character like <NL> or , something that we can find with split text and replace rather than having the output show up like it is.

Good luck!

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ericmabkv ,

You can also try this in this way.Please find the solution.

Code:
Please copy the below code into your flow.
SET PowershellOutput TO $'''The user: Eric Test2 is not in Insperity The user: Eric Test is not in Insperity''' Variables.CreateNewList List=> Output_List Variables.AddItemToList Item: PowershellOutput List: Output_List Outlook.Launch Instance=> OutlookInstance Outlook.SendEmailThroughOutlook.SendEmail Instance: OutlookInstance Account: $'''Varikutivishnuvardhan.reddy@acme.com''' SendTo: $'''Varikutivishnuvardhan.reddy@acme.com''' Subject: $'''Sample''' Body: Output_List IsBodyHtml: False IsDraft: False

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
ericmabkv 12 on at

Like
a
(0)

Report
Copy link

Link copied!

This almost worked. I had to use "." as a delimiter and I can see that the output was added to separate lines in the TextList, however when emailed it still appeared on one line.

Was this reply helpful? Yes No
ericmabkv 12 on at

Like
a
(0)

Report
Copy link

Link copied!

This option also did not work. I also tried splitting text then adding to list but all list formatting is lost when inserted into the email body.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ericmabkv

Could you please share screenshot of your full flow screenshot and outlook send email screenshot like below?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I really thought that was going to work. Here is my Custom GPTs recommendation, but I haven't tested this:

To ensure that the variable's content maintains its multi-line format in an email when using Power Automate Desktop, you need to ensure that the email body is set to accept HTML formatting. This will allow you to use HTML tags to format the text, including line breaks. Here's a step-by-step process to modify your Power Automate Desktop flow:

Convert Newlines to HTML Breaks: Before sending the email, replace newline characters in your PowerShell script output with  HTML tags. This can be done using the Text.Replace action. The newline character is typically represented as \r\n (carriage return and newline).

Text.Replace Text: %PowershellOutput% TextToFind: "\r\n" ReplaceWith: " " Result=> FormattedOutput

Send Email: When configuring the Email.SendEmail action to send the email, ensure you set the IsBodyHtml property to True. This will tell the email client that the body of the email is HTML and should render as such.

Email.SendEmail.Send SMTPServer: "your.smtp.server" Port: 25 EnableSSL: True SendFrom: "your-email@example.com" SendTo: "recipient@example.com" Subject: "Your Subject Here" Body: %FormattedOutput% IsBodyHtml: True

By setting IsBodyHtml to True and replacing newline characters with , the email client will interpret the line breaks correctly, preserving the multi-line format of your variable's content in the sent email.

It basically replaces the text with the HTML tab .

Good luck!

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@ericmabkv

Follow the steps outlined below if the text appears in a single line.

After splitting your PowerShell script, you will obtain your texts in list variables as shown below.

Then, create a variable named `strhtmlbody` with an empty value. Next,

Iterate through your `TextList3` variable and concatenate each list value with " " as illustrated in the screenshot below.

Finally, pass the same variable into the email body and enable the "Body is HTML" option as depicted in the second screenshot.

Code:
SET PowershellOutput TO $'''The user: Eric Test2 is not in Insperity The user: Eric Test is not in Insperity''' Text.SplitText.Split Text: PowershellOutput StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> TextList3 Outlook.Launch Instance=> OutlookInstance SET Strhtmlbody TO $'''%''%''' LOOP FOREACH CurrentItem IN TextList3 SET Strhtmlbody TO $'''%Strhtmlbody% %CurrentItem% ''' END Outlook.SendEmailThroughOutlook.SendEmail Instance: OutlookInstance Account: $'''deenu@office365journey.onmicrosoft.com''' SendTo: $'''deenucse@gmail.com''' Subject: $'''Sample''' Body: Strhtmlbody IsBodyHtml: True IsDraft: False

How to copy/paste the above code into your PAD?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ericmabkv ,

I have not splitted the text. I have just created the list and added the variable to the list.
Just once go through my previous post.It working fine for me.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
ericmabkv 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I have already attempted to replace \r\n with \br but that did not work either. The preview of the output variable appeared correct but it did not retain the formatting when inserted into an email. The email Body Is HTML is enabled as well.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ericmabkv
Have you tried my above suggestion?

if it’s not working, then please share the screenshot of your full flow(hide all sensitive data). I will assess your flow and assist you further.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No