cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RaizenSayen
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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. 

vyujincuimsft_0-1660714102221.png

2. Here is my flow. 

 

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

 

vyujincuimsft_1-1660714102223.png

Result Screenshot: 

vyujincuimsft_0-1660714319333.png

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 

View solution in original post

3 REPLIES 3
MarconettiMarco
Super User
Super User

Hello @RaizenSayen ,

can you share the excel cell text?

 

BR,

Marco

RaizenSayen_0-1660333904566.png

 

v-yujincui-msft
Community Support
Community Support

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. 

vyujincuimsft_0-1660714102221.png

2. Here is my flow. 

 

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

 

vyujincuimsft_1-1660714102223.png

Result Screenshot: 

vyujincuimsft_0-1660714319333.png

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 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,797)