# Power Automate: Add a table in Email

Hi guys, \
Last week, my client approached me with a request: **they wanted the system to be capable of sending email notifications to the sales manager, containing a list of new Deals daily.** (It means the list of Deals has "New" status)

...and I said, "Yes, sure".  -> Now, we will do that.

## My propose: Using Power Automate

The details of my Power Automate:

* Type of Power Automate: **Scheduled.**
* Frequency: **Daily** at 00:05 am
* The flow will filter all **Deal records** that have the **status reason** "**New**"
* Then send this list to the Sales Manager. \
  \&#xNAN;*For instance, I will send it to a specific email: **"<dung@ntd.asia>"***
* Using the **Create HTML table {}** action of **Data Operation** is to generate a table from Dataverse records.

{% hint style="info" %}
My steps:\
\&#xNAN;*<mark style="color:green;">**Schedule Flow -> Get List rows (from Dataverse) -> Create HTML Table -> Send Email (V2)**</mark>*
{% endhint %}

First of all, I have the list of ***Active Deals*** below and I expect the system will send 2 Deals with the **New** Status to my email **"<dung@ntd.asia>".**

<figure><img src="/files/8j6POEvvYayX7N6Let5A" alt=""><figcaption><p>List of dealss</p></figcaption></figure>

## Creating Power Automate

In my solution, choose **Cloud Flow** > click **New** to create

<figure><img src="/files/XkG2Vdxq3Va7TkUmH8YV" alt=""><figcaption><p>Scheduled Cloud Flow</p></figcaption></figure>

After creating, I added new step **"List rows"** from "Dataverse" > select my table **Deal** and set **Filter** for this step.

<figure><img src="/files/5YfQdpH4TezVcyFNAsP4" alt=""><figcaption><p>List Rows: Deals has New status</p></figcaption></figure>

{% hint style="info" %}
My sample, I filter Deals has Status Reason = "New"' ==> *<mark style="background-color:orange;">**statuscode eq**</mark>*<mark style="background-color:orange;">**&#x20;**</mark><mark style="background-color:orange;">**1**</mark>
{% endhint %}

## **\*\*Action: Create HTML Table {}**

In the 3rd step, I added an action <mark style="background-color:green;">**Create HTML Table {}**</mark> in **"Data Operation"**

<figure><img src="/files/A7gy7p864FHVsF2ieCwO" alt=""><figcaption><p>Action: Create HTML table from "List rows Deals" step</p></figcaption></figure>

Run testing and check the Output of step **"Create HTML table".** \
Because I selected the option <mark style="background-color:orange;">**Automatic**</mark> of ***Columns,*** so all columns of the **Deal** entity will be shown below.

<figure><img src="/files/q0CmT8SwswdYSsM9E6u2" alt=""><figcaption><p>The output of step "Create HTML table"</p></figcaption></figure>

Then I edit the option **Column** to <mark style="background-color:orange;">**Custom**</mark>**&#x20;->** and create the custom mapping for the table

<figure><img src="/files/Jk9O3FiVjmtHfyuo9wGQ" alt=""><figcaption><p>Custom mapping</p></figcaption></figure>

After using custom mapping, we have the result:

<figure><img src="/files/0W8cIFu5TuV7S8ijwop9" alt=""><figcaption><p>The output of step "Create HTML table": Using Custom Mapping</p></figcaption></figure>

## Add step Send Email (V2)

I added the **Send Email (V2)** to the final step. In this step, I used the **Output** of action **"Create HTM table {}"** and added it to the email's body.

<figure><img src="/files/5AcjX94kppuZEo78mUrQ" alt=""><figcaption><p>Final Power Automate</p></figcaption></figure>

## First Testing...

After finishing the first version, I tested and saw the table has no border:

<figure><img src="/files/ifkuTRvp8rUmqOFCTYt1" alt=""><figcaption><p>1st version -Default table has no border</p></figcaption></figure>

## \*\*Using Compose {} action & Final Flow

Then, I edit my Power Automate and use the action **Compose {}** of **Data Operation.** This action I used this to add **a border** for the table.

{% hint style="info" %}
I used the expression ***Replace()*** to take the table and replace the reference to the table object to include a format style.&#x20;
{% endhint %}

My expression:

```html
replace(body('Create_HTML_table'),'<table>','<table border=”1″>')
```

And the latest version of Power Automate, in the email body, I used the Output of step **"Compose".**

<figure><img src="/files/sFwntNky5rAoV90d49le" alt=""><figcaption><p>Latest version - using "Compose {}" and "Replace ()"</p></figcaption></figure>

-> Running Test and check the result: The table has a border :)

<figure><img src="/files/hoomCGYCE5MVA1ygO3qt" alt=""><figcaption><p>The table with border.</p></figcaption></figure>

Thank you and hoping well. :tada:\
\&#xNAN;**\[NTD]yns.asia**\ <mark style="color:red;">...</mark>[<mark style="color:red;">invite me a cup.</mark>](https://ko-fi.com/ntdyns/?ref=qr\&amp;v=2) :coffee: Thank you. :heart:


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://dyns.ntd.asia/power-dynamics/power-platform/power-automate/power-automate-add-a-table-in-email.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.