Skip to main content

Notifications

Power Automate - Using Flows
Answered

SharePoint Multiple lines of text column and Send an email Issue

(1) ShareShare
ReportReport
Posted on by 117

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?

  • QWales Profile Picture
    QWales 38 on at
    SharePoint Multiple lines of text column and Send an email Issue
    A breakdown of the aforementioned solution from Gumis and a simpler one:
     
    Add the column\field to a componse
    Add this line to another compose replace(outputs('Compose'),decodeUriComponent(';">'), '</div>')
    You are taking the output from the first compose and just taking the data between to points in the output you’ve been seeing, in this case between:  ;”> and <div>
     
    Simpler Solution:
    The other way to do it is to add the action HTML to text. I put the field in a variable and added that to the HTML to text action but not sure if that is necessary. I put the Output in the subject field of my email and I just got the required content.
  • Verified answer
    FLMike Profile Picture
    FLMike 31,580 on at
    SharePoint Multiple lines of text column and Send an email Issue
    hi
     
    So if i can bridge the gap on something.
     
    1) If you are using Rich Text in a Multi-Line, then you are best to using HTML and why the br html worked
    2) If you are NOT wanting to use that, then you would need to do what Brad said.
     
    Its a very different situation and it goes further than the Multi-line text control and is why I am explaining. As you build other flows that get responses from APIs and etc you want to format things, or remove them, you have to understand that
     
    deCodeUri etc is used to do thing like replace \n with a real carriage return (as \n means nothing to Power Automate) same for creating Tabs etc.
     
    The standard Char expressions of \t \n etc do not work.
     
    So its not that BR is the answer, its simply one and it depends on what you need long
  • MK-30080731-0 Profile Picture
    MK-30080731-0 4 on at
    SharePoint Multiple lines of text column and Send an email Issue
    @Gumis
    Haha! You sir, are a genius!!!
  • JM007 Profile Picture
    JM007 3 on at
    Re: SharePoint Multiple lines of text column and Send an email Issue

    It worked for me too, thanks!

  • Verified answer
    Gumis Profile Picture
    Gumis 15 on at
    Re: SharePoint Multiple lines of text column and Send an email Issue

    This is how I solved it at my place:

    we need two compose (German "Verfassen") steps:

    Gumis_0-1702716783905.png

    fx :  replace(outputs('Verfassen_5'),decodeUriComponent('%0A'), '<br />')

     

    That's it 

  • Verified answer
    WC-KSTILL Profile Picture
    WC-KSTILL 117 on at
    Re: SharePoint Multiple lines of text column and Send an email Issue

    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>')

  • Brad_Groux Profile Picture
    Brad_Groux 4,556 on at
    Re: SharePoint Multiple lines of text column and Send an email Issue

    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 Profile Picture
    WC-KSTILL 117 on at
    Re: SharePoint Multiple lines of text column and Send an email Issue

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

  • Verified answer
    Brad_Groux Profile Picture
    Brad_Groux 4,556 on at
    Re: SharePoint Multiple lines of text column and Send an email Issue

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics

Restore a deleted flow