Keeping same format when extracting text from Excel Cell (Sending by email)

[RaizenSayen]

Hello guys,
I have a text message in an Excel Cell that I want to send via Email using PowerAutomate. Unfortunately, it doesn't keep the text format, it just collapse all together. Is there a way to keep the same format ? Or even use Word/PDF to keep the format ? Thank you

[MarconettiMarco]

Hello @RaizenSayen ,

can you share the excel cell text?

BR,

Marco

[RaizenSayen]

[v-yujincui-msft · Accepted solution]

Hi @RaizenSayen ,

If it's just keeping newlines it can be done with expressions, if you want to keep font formatting, I'm afraid there is currently no out-of-the-box way to do this. 

1. Here is my excel table. 

2. Here is my flow. 

replace(Dynamic Content,decodeUriComponent('%0A'),'<br>') 

Result Screenshot: 

In addition, here is a similar case for your reference. 

https://powerusers.microsoft.com/t5/General-Power-Automate/New-Lines-in-excel-cell-does-not-support-... 

Best Regards, 

Charlie Choi