web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Generating HTML Email ...

Power Automate

Suggested Answer

Generating HTML Email Drafts from Excel Inputs (Saved to Drafts Only)

(1) Share

Report

Report

Posted on by CU26081420-0

2

I would like to create an email draft in Outlook using values entered into an Excel file stored in Teams.
Ideally, the email should be sent from a group address.

The email should be formatted in HTML, and I do not want it to be sent automatically.
I would prefer to have it saved as a draft instead.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Jon Unzueta 1,834 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@CU26081420-0

1. Trigger

Start with a manual trigger or scheduled flow depending on your needs.

2. Read Excel from Teams

Use “List rows present in a table” from the Excel Online (Business) connector.

Make sure the Excel file is stored in a Teams-connected SharePoint site.

Ensure the data is in a table format.

3. Build HTML Email Body

Use a Compose action to format the email body using dynamic content from Excel:

Hello,

Here is the summary:

Name: @{items('Apply_to_each')?['Name']}

Project: @{items('Apply_to_each')?['Project']}

4. Create Draft Email via Microsoft Graph API

Use the HTTP action (premium connector) to call Graph API:

Endpoint:

POST https://graph.microsoft.com/v1.0/users/{group_email}/messages

Headers:

{

  "Authorization": "Bearer YOUR_ACCESS_TOKEN",

  "Content-Type": "application/json"

}
Body
{

  "subject": "Project Summary",

  "body": {

    "contentType": "HTML",

    "content": "

Your formatted HTML content here
"
  },

  "toRecipients": [

    {

      "emailAddress": {

        "address": "recipient@example.com"

      }

    }

  ],

  "saveToSentItems": "false"

}
This will create a draft email in the group mailbox.

This content may have been partially translated, structured, or generated with Copilot 🏷️ Tag me if you have any further questions or if the issue persists. ✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems. ❤️ Give it a Like if you found the approach useful in any way.

1 people found this reply helpful.

Was this reply helpful? Yes No
David_MA 14,485 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Set your flow up like this and be sure to use a filter query to return the row you need from Excel to populate the e-mail with or you will generate as many e-mails as there are rows in the spreadsheet (well, up to 256 if you don't enabled paging).

Just note that the e-mail will be saved in the draft folder of the owner of the flow.

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation