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

[rampprakash]

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

Power Automate:

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

2. Create a new Flow

Now Create a Record in SharePoint List and Save it

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

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

3. Encrypt the Step 2

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

5. Now Decrypt the Variable

6. Now Send an Email

Create a new Record in SharePoint List and Check the Email

That's it 🙂

[Slavi_Tsvetanov]

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 ?

[Obo]

Hi, Thank you !

In one step :

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

[aadhawan]

@Obo 

Thanks you are a life saver. 

[Gumis]

This is how I solved it at my place:

we need two compose (German "Verfassen") steps

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

That's it