How to include Line Breaker from Long Text box and remove [" "] format from Multiple Choice answer (MS FORM) when sending HTML Email using MS FLOW

[Anonymous]

I have a couple questions related to sending HTML Email from MS Form values using MS Flow:

1. How to include Line Breaker from MS Form Long Text box when sending HTML Email using MS Flow

Currently, it's converting the multi line values as a single line in the email. How do I keep the original format to include linebreaker in the email?

2. How to remove [" "] format from MS Form Multiple Choice answer when sending HTML Email using MS Flow

Multivalues are represented in array format, how do I remove this is MS Flow process?

[RezaDorrani · Accepted solution]

Hi @Anonymous 

for multi choice field use expression

replace(replace(replace(dynamiccontentmultichoicefield,'["',''),'"]',''),'","',',')

for long text line break 

First create a compose action (rename it to NewLine)

and add following expression

decodeUriComponent('%0A')

Then in email use expression

replace(dynamiccontentlongfield,outputs('NewLine'),'</br>')

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

@RezaDorrani, unfortunately this doesn't work. I'm getting literally string output. Could you please advise me?

multichoicelongtext

[RezaDorrani]

Hi @Anonymous 

You need to use the expression syntax

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Thank you so much! This is really helpful. Is there some kind of documentation to go through for more advanced flows like this?

[Tazfiend1]

Thank you for that! What a relief.

[AlexPMayer42]

Reza,

This fails if the Multiline Text field is NULL. This expression will first check that it is not NULL prior to trying to make the string change:

if(equals(coalesce([FIELDNAME],'NULL'),'NULL'),'',replace([FIELDNAME],outputs('NewLine'),'</br>'))

-Alex Mayer