cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
limalbert
New Member

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

Hi @limalbert 

 

 

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')
Capture.PNG

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

View solution in original post

6 REPLIES 6
RezaDorrani
Dual Super User II
Dual Super User II

Hi @limalbert 

 

 

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')
Capture.PNG

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

View solution in original post

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

multichoicemultichoicelongtextlongtext

Hi @limalbert 

 

You need to use the expression syntax

 

Capture.PNG

 

Regards,

Reza Dorrani

 

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

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

Thank you for that! What a relief.

AlexPMayer42
New Member

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

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (3,787)