Power Apps button to aopen an outlook new message with an Excel-type table

(4) Share

Report

Posted on by WorkingRicardo

818

So I know I can launch the app with this code:

Launch("mailto:recipient@example.com?subject=Email%20Subject&body=This%20is%20the%20email%20body")

But I need something like this

Column1	column2	column3
xxxx	yyyyy	zzzz

copied into the body of the email part.
Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@WorkingRicardo Hi,

Maybe not. Consider using Office365Outlook connector in the app.

For example, i have a button to send the email.

// 1. Put your data in a collection, like a form, SharePoint list, etc ClearCollect( colRows, { Column1:"a", Column2:"b", Column3:"c" }, { Column1:"d", Column2:"e", Column3:"f" } ); // 2. Convert that collection to HTML rows Set( htmlRows, Concat( colRows, "<tr>" & "<td>" & Column1 & "</td>" & "<td>" & Column2 & "</td>" & "<td>" & Column3 & "</td>" & "</tr>" ) ); Set( htmlTable, "<table border='1'>" & "<thead><tr>" & "<th>Column 1</th><th>Column 2</th><th>Column 3</th>" & "</tr></thead>" & "<tbody>" & htmlRows & "</tbody>" & "</table>" ); // 4. Send the e‑mail Office365Outlook.SendEmailV2( "a@b.com", "Subject", htmlTable, { IsHtml: true } );

you can add a screen for preview the content if needed.

Was this reply helpful? Yes No
WorkingRicardo 818 on at

Like (0)

Report

@stampcoin hey hadn't seen this! Thanks for your reply.

Ohh, so it's not possible? Yeah I tried your code but I was asked expressly that they didn't want for the email to be sent automatically. I'm gonna pitch the preview screen, but I know that will be turned down.

They need for the new email pop up to show up and want to send the email themselves for possible tweaking of the email.

Let me know if there's someway :(

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@WorkingRicardo Hi,

Understand, I cannot find any doc that mailto accepts html tag. Maybe others have solution/answer.

Sometimes say 'No' to the end user, but if they can get budget, that will be different story.😊

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @WorkingRicardo,

Just confirming @stampcoin's advice - the output of the mailto: function is interpreted by the Outlook client as plain text, so you have a compromise if you actually want to see the "preview" in Outlook. It is possible that some email clients (mailto: opens the email in the default email client of the user) may support this, but Outlook does not.

I use a HTML "preview" and add a Rich Text box with the body pre-filled and then able to be changed. You would have to add your Table before or after this when sending the email as the editor does not allow Tables.

Was this reply helpful? Yes No