Answered

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

(2) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

RezaDorrani 12,145 on at

Like (4)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tazfiend1 5 on at

Like (1)

Report
Copy link

Link copied!

Thank you for that! What a relief.

Was this reply helpful? Yes No
AlexPMayer42 4 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No