Answered

Put Multiline filed data into an HTML email

(0) Share

Report

Posted on by BatInDaCave

Hi,

I've been working on this for a day and couldn't figure this out. I read all the post from the forum and cannot find a single post that can help me.

I have a multiline column called "Comments" in SPO list, it is also set to plain-text, it is taking input from a PowerApp.

2019-07-10 23_17_09-digitaltools - PA-EPS-EMPLOYMENT-TOOL - All Items.png

Then I want to pass this data to an email. If I use "Send an Email" the format comes out right, but I want to use HTML. but when I do, I get everything outputs on one line:

---------------------------------

"Hello, Please help to look after this guy Thank you Regman"

---------------------------------

I tried simply adding an after select "Comments" as dynamic content does not work.

Then I tried to do this:

2019-07-10 23_24_06-PowerApps.png

it gives me:

---------------------------------

Hello%2C%0A%0APlease%20help%20to%20look%20after%20this%20guy%0A%0AThank%20you%0A%0ARegman

---------------------------------

I can replace the %0A with ,

uriComponentToString(replace(uriComponent(body(triggerBody()?['Comments'])),'%0A',''))

However, as expected, it does the carriage returns but I still have all the other gibberish in the line:

---------------------------------

Hello%2C

Please%20help%20to%20look%20after%20this%20guy

Thank%20you

Regman

---------------------------------

Am I even on the right track guys? could you help me?

Categories:

General topics

I have the same question (267)

All responses (7)

Answers (2)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @BatInDaCave

I just made a test at my end and this is how it worked:

In the body, directly select the Multi lines of text column from the dynamic data selector.

In the send an email action, set the IsHTML option to NO.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

266 people found this reply helpful.

Was this reply helpful? Yes No
BatInDaCave 25 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply.

Like mentioned in my initial post, I know it works if I only use "Send an Email"

However, I want to use HTML when sending an email so I can do some advanced formatting in the email. So I did meant to set IsHTML to "Yes"

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @BatInDaCave

In that case, please see the screenshot below:

Here, I am creating a string variable with enter key. (initialise the variable and hit an enter in the value). another array variable to split the multi line at the enter key.

Expression:

split(body('Get_item')?['tahs'],variables('test'))

Then, in the email action, the expression is:

join(variables('dd'),' ')

Set the HTML option to true and it should work.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

1 people found this reply helpful.

Was this reply helpful? Yes No
benzed 6 on at

Like (0)

Report
Copy link

Link copied!

I had this exact problem yesterday. What I ended up doing was changing the column type to rich text format. This will save markup with the text for the HTML message.

1 people found this reply helpful.

Was this reply helpful? Yes No
BatInDaCave 25 on at

Like (0)

Report
Copy link

Link copied!
Thank you again for helping...but still not working.

So,
split(body('Get_item')?['tahs'],variables('test'))
for "tahs", I think you meant "Comments" in my case

if that is the case, should it be like this? and what are you Splitting here? what is the separator here? (or how can the variable of 'test" be the separator?)
split(body(('Get_item')?['tahs']),variables('test'))

either way, I couldn't make it work, this is what I have.

1 people found this reply helpful.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @BatInDaCave

Yes, by 'tahs', i meant the 'Comments' of your SP list. Please note that I have copied the exact formula from my working flow so you don't have to add the extra () in that. About the test variable, as you can see in my screenshots earlier, you have to put the cursor in the value of the initialise test variable (RecieveComponent) in your flow and hit an enter so that it goes to a new line and then click save. Then in the split function we are splitting the comments content at every new line and then using the tag to get through. Makes sense?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
BatInDaCave 25 on at

Like (0)

Report
Copy link

Link copied!

I missed that "invisible" Enter in the initialize variable.

Now it works! Thank you so much, it's been bothering me for so days!

Was this reply helpful? Yes No