cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WC-KSTILL
Helper III
Helper III

SharePoint Multiple lines of text column and Send an email Issue

Currently if a user writes

 

A

B

C

D


In a multiple lines of text column, and then I send that in an email notification it will appear as

A B C D

 

Is there anyway for me to fix this?

1 ACCEPTED SOLUTION

Accepted Solutions
WC-KSTILL
Helper III
Helper III

I actually figured out a fix.


Create a variable (String) - Called it varNewLine. For the value I just hit enter so it has a space in it.

 

Create a new variable (String) with my multiple lines of text column as the value, in my case I named it varActionRequest.

 

Then in the email body did an expression

 

Replace(variables('varActionRequest'),variables('varNewLine'),'<br>')

View solution in original post

4 REPLIES 4
Brad_Groux
Super User II
Super User II

You'd want to follow basically what is done here - Retaining Line Breaks In Multi-Line Text Fields From Forms Pro - Megan V. WalkerCompose the multiple lines to URI encoding, a then replace the line break %0A with the desired formatting, such as </br>.

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

 

I couldn't get this to work at all. Do you have a screenshot?

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

WC-KSTILL
Helper III
Helper III

I actually figured out a fix.


Create a variable (String) - Called it varNewLine. For the value I just hit enter so it has a space in it.

 

Create a new variable (String) with my multiple lines of text column as the value, in my case I named it varActionRequest.

 

Then in the email body did an expression

 

Replace(variables('varActionRequest'),variables('varNewLine'),'<br>')

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,363)