cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emfuentes27
Super User
Super User

Send an email when Yes/No field checked

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.

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

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"
    }
)
)

 

 

 

 

View solution in original post

1 REPLY 1
StalinPonnusamy
Super User
Super User

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"
    }
)
)

 

 

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,335)