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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

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