Send an email when Yes/No field checked

(0) Share

Report

Posted on by emfuentes27

578

I'm building an an app that uses SharePoint data, and I need to send an email when a Yes/No field is checked. I added to onCheck the standard:

Office365Outlook.SendEmailV2(
 "billgates@microsoft.com",
 "Email Subject",
 "Email Body",
 {
 Cc:"pepe@microsoft.com"
 }
)

It works, and it sends the email when I toggle it to Yes. The issue that when I submit the form, it sends another email. Is there a way to make this one or the other? I really don't care which one.

Thanks.

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @emfuentes27

The best approach is to send an email after submitting the form successfully. To do that, Remove OnCheck event code.
Submit the form.
Set the OnSuccess property of the Form to
If(EditForm1.LastSubmit.BooleanfieldName, Office365Outlook.SendEmailV2( "billgates@microsoft.com", "Email Subject", "Email Body", { Cc:"pepe@microsoft.com" } ) )

If you not storing the boolean field in Sharepoint then send an email when submitting the form

SubmitForm(EditFormName); If(Controlname.Value, Office365Outlook.SendEmailV2( "billgates@microsoft.com", "Email Subject", "Email Body", { Cc:"pepe@microsoft.com" } ) )