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

(1) Share

Report

Posted on by CU26081420-0

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:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

David_MA 13,282 Super User 2025 Season 2 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
Suggested answer

Jon Unzueta 1,834 Super User 2025 Season 2 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