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
Solved! Go to 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.
Best Regards,
Charlie Choi
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.
Best Regards,
Charlie Choi
User | Count |
---|---|
93 | |
46 | |
20 | |
20 | |
16 |
User | Count |
---|---|
134 | |
56 | |
44 | |
36 | |
26 |