how to send data in Table format Through Mail Using Microsoft Power Automate

Step 1: Select the Trigger Type

Let’s create a cloud flow by opening up make.powerautomate.com, The trigger which we are choosing here is a manual trigger that contains a user input named “Status Type”

Step 2: List rows present in a table“. This activity

Lets Take “Excel Online (OneDrive) activity List rows present in a table“. This activity needs the file path and table which are pretty easy to select.

Let’s start by looking at our source file and the Table we are about to read using the Power Automate cloud Excel connector.

Input Excel Data Shown Below

There is a filter query that I am using to filter the data rows based on “Status Type”

Step 3: Create an HTML table

“Create HTML Table” creates a table by mapping the values under defined column names. This activity returns a plain table which we can beautify using the “Compose” activity:

Step 4: Beautify the HTML Table Using Compose Activity

I am using the “Compose” activity with Outputs of “Create HTML Table” to beautify the output table.

<style>
Table {
  font-family: Arial, Helvetica, sans-serif;
  background-color: #EEEEEE;
  border-collapse: collapse;
  width: 100%;
}


Table td, Table th {
  border: 1px solid #ddd;
  padding: 3px 3px;
}


Table th {
  font-size: 15px;
  font-weight: bold;
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: left;
  background-color: #1C6EA4;
  color: white;
}
</style>

with this HTML code, you need to give the output from the “Create HTML Table” activity and this formats the table accordingly.

Step 5: Send An Email Using Outlook

Let’s take the final activity “Send an email from Outlook.com” and Compose the body. You need to take the Output details from compose action and give it in the email body.

Step 6: Run the Flow

Let’s give it a test and run it in test mode:

Once you run it, It asks for your input which will later work as a filter condition (“Status Type”)

If i give it an input as “Not Credited“, below would be the output and the final email result sent out to the receiver.

Final Output Email Results