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

Like (4) Share

Report

Posted on 15 Jul 2025 11:00:27 by WorkingRicardo

782

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:

Using Apps Using Formulas

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 150,394 Most Valuable Professional on 18 Jul 2025 at 22:09:33

Like (0)

Report

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

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
stampcoin 4,355 Super User 2025 Season 2 on 18 Jul 2025 at 12:24:02

Like (0)

Report

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

@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
WorkingRicardo 782 on 18 Jul 2025 at 09:55:49

Like (0)

Report

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

@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
Verified answer

stampcoin 4,355 Super User 2025 Season 2 on 15 Jul 2025 at 11:30:02

Like (0)

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

@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