Formatting Issues

How to Preserve Excel Conditional Formatting in Power Automate Emails

WPS Editor Oct 7, 2026 869 views

Question details

The user needs to send individualized emails from Excel using Power Automate, preserving visual traffic-light conditional formatting while ensuring each recipient cannot see other students' private data.

How to Preserve Excel Conditional Formatting in Power Automate Emails

Product: Excel
Device & OS: not provided
Scenario: Automating individual student reports or grades via email from a master spreadsheet.
Observed behavior: Automated emails strip native conditional formatting, and standard email generation risks exposing the entire dataset to all recipients if not properly filtered.

Before you start

Before creating your Power Automate flow, ensure your Excel data is formatted as a standard Table and saved in a cloud location like OneDrive or SharePoint.

Solution 1Recommended

Use an HTML Table with Custom CSS for Filtered Data

Filter the dataset to extract specific rows per recipient, convert them into an HTML table, and apply conditional styling within the flow to replicate Excel's formatting.

Power Automate extracts raw text and numbers from Excel but does not natively pull visual styles like traffic-light conditional formatting. To retain this look in an email and strictly protect student privacy, you must filter the data individually and rebuild the formatting using HTML expressions.

Filter the Excel Data

In your Power Automate flow, add the 'List rows present in a table' action. Use the OData Filter Query field to isolate the row for the specific student (e.g., StudentEmail eq 'current_email@domain.com').

Convert Data to an HTML Table

Add a 'Create HTML table' action and use the output from your filtered rows. Set the columns to 'Custom' to include only the necessary columns and avoid exposing irrelevant data.

Replicate Conditional Formatting

Since native Excel icons will not transfer, use a 'Compose' action to write string replacement expressions. Replace specific cell values with colored text, inline CSS styled elements, or emojis (🔴, 🟡, 🟢) to simulate the traffic lights.

Insert Table into Email Body

Add the 'Send an email (V2)' action. Switch the email body to HTML view (</>) and insert the output of your customized HTML table to send the secure, visually formatted data.

Use an HTML Table with Custom CSS for Filtered Data

Data Privacy Ensured: By utilizing the OData Filter Query before creating the HTML table, you guarantee that each recipient receives only their own row, keeping the rest of the dataset strictly confidential.

Free Microsoft Office alternative

Manage Spreadsheet Data Seamlessly with WPS Office

While external tools handle complex email automations, WPS Office provides a lightweight, entirely free, and highly capable environment to organize your data. It flawlessly handles Microsoft Excel formats, ensuring your tables and data structures are always ready for automation workflows.

1. Download and Install: Visit the official WPS website to download the free WPS Office suite for your PC or mobile device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files seamlessly without worrying about data or formatting loss.
3. Prepare the Table: Organize your student data into a structured table format, ensuring it is ready to be linked with external automation platforms.

Completely free to use with a lightweight, fast installationSeamless compatibility with Microsoft Excel (.xlsx) formatsFamiliar user interface requiring no steep learning curvePowerful built-in conditional formatting and data management tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel conditional formatting disappear in Power Automate emails?

Power Automate only extracts the raw data values from an Excel file. It does not read visual styles or conditional formatting rules. To include formatting in an email, you must dynamically recreate it using HTML and CSS within your workflow.

How can I prevent recipients from seeing other students' private data?

Use an OData Filter Query within the 'List rows present in a table' action in Power Automate. By filtering the data based on a unique identifier for the recipient (like an email address), the flow extracts and processes only that specific row, ensuring privacy.

Can I use Excel's native traffic-light icons in my automated emails?

Standard HTML tables generated by Power Automate do not support Excel's native icon sets. You can easily work around this by writing conditional expressions in your flow to insert colored emojis (such as 🔴, 🟡, 🟢) based on the specific cell values.

Document & File Issues