Skip to main content

Notifications

Send an Email With Line Breaks From Share Point List : Multi-Line Column ​

Implemenation Steps:

First you need to Create a Multi-Line Text in Share Point List

SharePoint List :

1. Open SharePoint Site 

2. Click Add Column

3. Select Multiple Lines of Text

4. Click Create

 

1.jpg

 

Power Automate:

 

1. Navigate to https://make.powerautomate.com

2. Create a new Flow

 

2.jpg

 

Now Create a Record in SharePoint List and Save it

3.jpg

 

 

Once Saved the Microsoft Flow will trigger and you can see the Email in your Inbox

 

4.jpg

 

 

Now Compared with Email and SharePoint List Record Creation the email not came with Line Breaked. Lets see how we can achive this.

 

Steps to Follow to Achive:

 

Create a Power Automate flow 

Steps :

1. When a Record is Crated

2. Initialize Variable to get the Multiple Line Text

5.jpg

 

3. Encrypt the Step 2

6.jpg

4. Now Use Replace Option to Replace '%0A' with '<br>'

7.jpg

5. Now Decrypt the Variable

8.jpg

6. Now Send an Email

10.jpg

 

Create a new Record in SharePoint List and Check the Email

 

9.jpg

That's it 🙂

Comments

*This post is locked for comments

  • Gumis Profile Picture Gumis 15
    Posted at
    Send an Email With Line Breaks From Share Point List : Multi-Line Column ?

    This is how I solved it at my place:

    we need two compose (German "Verfassen") steps

    Gumis_0-1702716616540.png

     

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

     

    That's it 

  • aadhawan Profile Picture aadhawan 111
    Posted at
    Send an Email With Line Breaks From Share Point List : Multi-Line Column ?

    @Obo 

    Thanks you are a life saver. 

  • Obo Profile Picture Obo
    Posted at
    Send an Email With Line Breaks From Share Point List : Multi-Line Column ?

    Hi, Thank you !

    In one step :

    decodeUriComponent(replace(encodeUriComponent(pick_your_MultiLine_value_here),'%0A','<br>'))

  • Slavi_Tsvetanov Profile Picture Slavi_Tsvetanov
    Posted at
    Send an Email With Line Breaks From Share Point List : Multi-Line Column ?

    Hi, the workaround works perfectly but power automate tries to sabotage my work. I made all the four Compose things above and after saving it gets changed by itself from

    outputs('Compose_1')

    to

    outputs('Compose_1')?['$']

    which is causing red exclamation and the flow just stuck there and nothing.

    Is there another workaround about this or a fix for my problem ?