How to preserve line breaks from Microsoft Forms when sending emails with Power Automate?

(2) Share

Report

Posted on by OC-05102118-0

Hello everyone.

I am using a form in Forms where people need to respond by skipping lines, for example:

Item 1
Item 2
Item 3
Item 4

and I use the Send an email (V2) function to collect the information in the forms to send the email.

With this code:

@{body('Get_response_details')?['ra6608fb4e70b489e84fba2b0bdab8552']}

Then the email is sent as:

Item 1 Item 2 Item 3 Item 4

Is there any way to identify so that the items are on each line?

* The email is sent in html format

Any ideas or support would be appreciated!

Categories:

General topics

I have the same question (4)

All responses (4)

Answers (1)

Sort by

Suggested answer

Amardeep Raj 74 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi

You can try both expression which mentioned below

@{replace(body('Get_response_details')?['ra6608fb4e70b489e84fba2b0bdab8552'], decodeUriComponent('%0A'), '<br>')} OR @{replace(body('Get_response_details')?['ra6608fb4e70b489e84fba2b0bdab8552'], '\n', '<br>')}

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Verified answer

Nandit 1,568 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi OC-05102118-0,

Just add a Compose action in your flow with the following expression:

replace(body('Get_response_details')?['ra6608fb4e70b489e84fba2b0bdab8552'],decodeUriComponent('%0A'),'<br>')

Then use the Compose output in your "Send an email V2" action. This will help you preserve the line breaks.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
OC-05102118-0 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Nandit.

Thanks for the solution!

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

Just to add though onto Nandits answer as its important to make sure your email is in HTML mode, if not it will not work.

For future reference

Secondarily, you can create an Array, and store the values there.

Then use the Create HTML table, and pass in your array.

It will automatically add "returns"

Was this reply helpful? Yes No