E-mail confirmation for submitter of PowerApps form?

Like (0) Share

Report

Posted on 22 Jan 2020 22:47:41 by Kookykrumbs

Hello,

I'm using Powerapps as a way for my staff to send forms to another department to complete requests for our customers. So the form could be something as simple as telling a department to send a customer a statement by mail. Anyway, I was wondering if there's a way for my staff who fills out the Powerapps form to receive an e-mail confirmation stating that their form was submitted successfully? Or for them to receive a confirmation of some kind in their Outlook? I'm submitting my Powerapps forms to a SharePoint List by the way.

Thank you

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (1)

PamHermano 4 on 11 Jan 2023 at 04:40:44

Like (0)

Report

Re: E-mail confirmation for submitter of PowerApps form?

Would someone be able to give me the formula using the Mail Connector if I want an email notification sent to the user themselves when I hit the submit button in PowerApps. All the formulas I've seen online looks like: Mail.SendEmailV3("mickey@mouse.com","subject","body",false)

But it asks for a specific email in the first quotations. Is there any way I can just set that to go to whoever the submitter was?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on 23 Jan 2020 at 09:58:40

Like (0)

Report
Re: E-mail confirmation for submitter of PowerApps form?

Hi @Kookykrumbs ,

Do you want to send an email with the content of the form when the form is submitted successfully?
I suggest you try office365 outlook connector.

Set the form's OnSelect:

ClearCollect(collection1,Form1.Updates);SubmitForm(Form1) //save the form's data to a collection

Try to set the form's OnSuccess:

Office365.SendEmail("To email address","subject", "<strong> collectionname </strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>field1</th> <th> field2</th> <th> field3 </th><th> field4 </th> </tr> <tr>" & Concat(Cart, "<td>" & field1 & " </td> <td>" & field2 & " </td> <td>" & field3 & " </td> <td>" & field4 & " </td> </tr><tr>") & "</table>", {IsHtml:true})

You could use html text to represent the form's content.

Here's a similar issue for your reference:

https://powerusers.microsoft.com/t5/Creating-Apps/HTML-email-format/td-p/179251

Best regards,

Was this reply helpful? Yes No
mdevaney 29,987 Moderator on 22 Jan 2020 at 23:03:54

Like (0)

Report
Re: E-mail confirmation for submitter of PowerApps form?

@Kookykrumbs

PowerApps and Flow have a couple of mail connectors you could use to do this.

Mail

Outlook 365

Gmail

You could use these to send an email on successful submission of a form.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No