Others

How to Fix Inconsistent Text Formatting in Power Automate Emails

Ayan Masood Sep 27, 2026 869 views

Question details

The user needs to standardize the text and label formatting in emails generated by Power Automate to prevent values from unpredictably shifting to new lines.

How to Fix Inconsistent Text Formatting in Power Automate Emails

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Generating automated email notifications containing data extracted from SharePoint lists.
Observed behavior: SharePoint field values display inconsistently in the email body; some values appear beside their labels, while others drop to a new line due to varying HTML structures.

Before you start

Verify the column types in your SharePoint list, taking special note of any 'Multiple lines of text' columns with rich text enabled, as these inherently inject complex HTML tags into your flow.

Solution 1Recommended

Inspect and Standardize the HTML Code in the Email Action

Directly editing the HTML code of the email body ensures all labels and dynamic values follow the exact same structural rules, preventing unexpected line breaks.

Rich text fields from SharePoint often carry their own block-level elements like <p> or <div>. When placed next to plain text in the Power Automate visual editor, these tags force the content to wrap. Normalizing the HTML resolves this.

Open the code view

Open your flow in Power Automate, locate the 'Send an email' action, and click the code view (</>) icon in the email body editor toolbar.

Wrap content in consistent tags

Inspect the raw HTML and manually wrap both your labels and the corresponding SharePoint dynamic content inside consistent <p> (paragraph) or <div> tags.

Use line break tags

Remove unpredictable spacing by using <br> tags strictly for line breaks where you want text to drop to the next line manually.

Save and test

Save your flow and trigger a test run to verify that the email layout renders correctly and consistently across different email clients.

Inspect and Standardize the HTML Code in the Email Action

Consistency Achieved: Using hardcoded HTML tags prevents email clients like Outlook or Gmail from applying their own unpredictable default formatting styles.

Solution 2

Use an HTML Table to Structure the Email Data

Using a pre-formatted HTML table forces your labels and values into a rigid grid, ignoring the default inline behaviors of SharePoint rich text fields.

Free Microsoft Office alternative

Manage Your Office Documents and Data with WPS Office

While Power Automate handles automated workflows, managing the underlying documents, spreadsheets, and reports doesn't have to be complicated or expensive. WPS Office is a free, lightweight, and user-friendly alternative to Microsoft Office, providing seamless compatibility for your exported workflow data without the heavy subscription costs.

1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
3. Open and edit files: Launch WPS Office to easily open, edit, and save your existing Microsoft Word, Excel, or PowerPoint files with zero formatting loss.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Perfect for analyzing exported SharePoint lists and workflow data in a robust spreadsheet environment.Lightweight installation ensures fast loading times for heavy documents.Familiar tabbed user interface makes it incredibly easy to switch and learn.

Frequently Asked Questions

Why do multiple-lines-of-text columns break my email layout?

SharePoint multiple-lines-of-text columns, especially when enhanced rich text is enabled, wrap their content in hidden block-level HTML tags like <div> or <p>. When these are inserted next to plain text labels in Power Automate, the block-level elements force the following content onto a new line.

Can I strip HTML tags from SharePoint fields in Power Automate?

Yes. You can use the uriComponentToString() and replace() expressions within a Compose action to strip out HTML tags, effectively converting the rich text into plain text before adding it to your email body.

How do I align labels and values perfectly in automated emails?

The most reliable method for perfect alignment is utilizing an HTML table. You can either use the 'Create HTML table' action or manually code a <table> structure within the code view (</>) of your email action, placing labels in <td> tags on the left and dynamic values in <td> tags on the right.

Office Quick Solutions