Power Platform Community Forum Thread Details

I am trying to mailmerge excel with powerautomate draft message.

it works fine with normal mail . but there is no option to include outlook html table in draft message . like the following

Column 1	column2
<Serial ID>	<Name>

Question

1. is there any option to add html table in draft message in powerautomate ?

2. can i refer/import drafted mail in outlook in powerautomate draft messaage

Categories:

Power Automate Desktop

Hi @SR-13011330-0,

Power Automate Desktop does not provide a native action to insert HTML tables directly into Outlook draft messages. The standard "Create email message" actions in Power Automate Desktop generate plain text drafts, not HTML-formatted content.
Two workarounds

Use Power Automate Cloud with Graph API
Power Automate Cloud flows support creating Outlook drafts with HTML bodies through the Microsoft Graph API. You send an HTTP POST request to https://graph.microsoft.com/v1.0/me/messages with a JSON body containing your HTML table markup. This approach requires switching from Desktop to Cloud flows.

Export draft from Outlook, import to Power Automate
Outlook lacks a direct import feature for draft messages created externally. You could save your HTML table as an .msg file, then use Power Automate Desktop to open the file in Outlook, though this requires the Outlook COM object actions and becomes complex.
Building the Cloud flow solution

Create an HTML table using the "Create HTML table" action in Power Automate Cloud.
Toggle code view </> in the "Body" field when using Graph API's "Send an HTTP request" action.
Paste your HTML table output into the message body property within the JSON request.
Add CSS styling to format the table appearance if needed.

The Graph API method gives you full control over HTML formatting and creates proper draft messages in Outlook that display formatted tables correctly.

Thank you!
Proud to be a Super User!
📩 Need more help?
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping