Answered

Help! Office365Outlook.SendEmail Fail using If Statements

(0) Share

Report

Posted on by Enriquitio

I new to Powerapps and have created a simple application which enables user to write data to a SharePoint List. I am also using the Office365Outlook.SendEmail function to send a fancy html email upon submission of the form.

I am using if statements to send emails depending on what data is inputted or selected on the entry form. Here is my formula:

Office365Outlook.SendEmail(
"jon@hotmail.co.uk" & If(
DataCard1.Selected.Value = "Chicken Soup",
"jane@hotmail.co.uk"
),
"Subject: " & DataCard2,
'HTMLEmail'.HtmlText,
{
IsHtml: true,
Importance: "High"
}
) & SubmitForm(Form1);
NewForm(Form1);
Navigate(
'Thank You Screen',
ScreenTransition.Fade
)

So when a user submits a form, all emails are sent to jon@hotmail.co.uk. But if Chicken is selected in the DataCard1 Combo box, then this includes jane@hotmail.co.uk into the email also.

This worked for a bit, but now when DataCard1 meets the criteria of "Chicken" it seems to break and I get the attached error message and no email is sent to anyone.

Not sure if its me or something else, but I need someones help to resolve this.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Enriquitio ,
Try this and note the comments on the datacard - xxxx means Value/Distinct/FieldName depending on Items if Dropdown/Combo
Office365Outlook.SendEmail( If( DataCard1.Selected.Value = "Chicken Soup", "jon@hotmail.co.uk"; "jane@hotmail.co.uk", "jon@hotmail.co.uk" ), DataCard2.Text, //Note if dropdown will be DataCard2.Selected.xxxx 'HTMLEmail'.HtmlText, { IsHtml: true, Importance: "High" } ); SubmitForm(Form1); NewForm(Form1); Navigate( 'Thank You Screen', ScreenTransition.Fade )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks for the speedy response. I think this works, however, it sends an email separately to each email and I would like it to add the 'If' email addresses to the static emails.

Also I want to avoid duplicated the static email (jon@hotmail.co.uk) like you have in your example. I would like to expand this to more values also from the combo box but not sure how.

Thanks,

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Enriquitio ,
I am not quite clear on your requirements - are you wanting to select multiple recipients from a Combo Box and send to them all?
Using ComboBox1 as the name of your control
Office365Outlook.SendEmail( Concat(ComboBox1.SelectedItems, Value & "; "), DataCard2.Text, //Assume subject is a text box 'HTMLEmail'.HtmlText, { IsHtml: true, Importance: "High" } ); SubmitForm(Form1); NewForm(Form1); Navigate( 'Thank You Screen', ScreenTransition.Fade )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Apologies, let me try and explain this better.

So when a user submits a new report form on the app I want to send an email notification to multiple colleagues. When I say static, I mean regardless of what is being entered onto the edit form, these people will get an email.

Now when a user selects certain value, say "chicken" from the one of the combo boxes, I want to use an If statement to add that person or persons into the email chain along with the static emails addresses already getting the email? Does that help?

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Thanks @Enriquitio ,
When you say one of the combo boxes, how may are there and what is the Items property of these - a screenshot would be good.
This is also getting quite a bit different from your post which asked for valid code to send an email (which has been solved).

Was this reply helpful? Yes No
Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz I really do appreciate your support with this. Your solution helped and worked, but wasn't right to progress the project and yes this is evolving and again I appreciate your support.

So there is just the one combo box that I wa target a certain value, the item property is IncidentType. Please see the example of the dropdown options attached. So for example, if I was to choose "Disease" then I would like to add a certain work colleague into the email chain, otherwise they don't need to be sent an email. That help?

Was this reply helpful? Yes No
Verified answer

Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz I have figured it out. All this needed was a semicolon adding to the first email address.... Thank you so much for your time and support though!

Office365Outlook.SendEmail(
"jon@hotmail.co.uk;" & If(
DataCard1.Selected.Value = "Chicken Soup",
"jane@hotmail.co.uk"
),
"Subject: " & DataCard2,
'HTMLEmail'.HtmlText,
{
IsHtml: true,
Importance: "High"
}
) & SubmitForm(Form1);
NewForm(Form1);
Navigate(
'Thank You Screen',
ScreenTransition.Fade
)

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Happy to help @Enriquitio ,
You have accepted your own response as a solution rather than the original item of mine solving this.
Please consider correcting this to help others find the answer.

Was this reply helpful? Yes No
Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Yes absolutely!

Thanks,
Harry

Was this reply helpful? Yes No