Keep new lines from Excel in emails sent by Power Automate
When using Power Automate with an Excel file, new lines in the text columns may be removed when sending an email. Excel represents new lines with the "\n" character, but Power Automate replaces it with a different character. To keep the new lines in the email, you need to manually replace the flow's new line character with the HTML tag "<br>". This will ensure that the email retains the formatting from the Excel file. It's important to check the data in the flow to understand how Power Automate handles it.
Article 19m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time