cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
limalbert
Level: Powered On

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
Dual Super User
Dual Super User

Re: 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

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

4 REPLIES 4
Dual Super User
Dual Super User

Re: 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

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

limalbert
Level: Powered On

Re: 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

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

multichoice.pngmultichoicelongtext.pnglongtext

Dual Super User
Dual Super User

Re: 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

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

limalbert
Level: Powered On

Re: 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

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

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,465)