cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thunter
Post Prodigy
Post Prodigy

UpdateContext to send Emails

I am trying to use the UpdateContext function to send emails. I am getting an error when I click submit button on my form. Anyone know if I am using the UpdateContext correctly. Thank you!

powerapps2.jpg

Here is my formula:

 

UpdateContext({e:If(DeptTxt.Text="Office","clericaltimeoff@xxxx.com", If(DeptTxt.Text="Operations","dispatchtimeoff@xxxx.com", If(DeptTxt.Text="Maintenance","mowens@xxxx.com", If(DeptTxt.Text="Management","managertimeoff@xxxx.com"))))});

Office365.SendEmail(e,"Time Off Request", "<b>Time Off Request for " & UserName.Text & "<br></b>" & "Department: " & DeptTxt.Text & "<br>" & "Date Submitted: " & TodaysDate & "<br><br>" & "Start Date: " & StartDate & "<br>" & "Start Time: " & StartTime.SelectedText.Value & "<br><br>" & "End Date: " & EndDate & "<br>" & "End Time:" & EndTime.SelectedText.Value & "<br><br>" & "Time Off Code: " & TimeOffRadio.SelectedText.Value & "<br>" & "Description: " & BriefDescription & "<br>" & "<br><br>" & "<b>REQUIRED FOR HOURLY EMPLOYEES</b>" & "<br>" & "Paid Compensation: " & Radio4.SelectedText.Value & "<br>" & "Makeup Time: " &  Radio4_1.SelectedText.Value & "<br>" & "Makeup Hours: " & MakeupTime.Text & "<br>" & "Makeup Date: " & MakeupDate & "<br>" &  "<br>" & "Go to the MANAGER screen to Approve/Reject the Time off Request" & "<br>" & "https://apps.powerapps.com/play/fa97404b-6670-4390-880a", {IsHtml: true});

Office365.SendEmail(User().Email, "Time Off Request Submitted", "Your Time Off Request has been submitted successfully.", {IsHtml: true});

SubmitForm(RequestForm);
ResetForm(RequestForm);
Navigate(LogoutScreen,ScreenTransition.Fade)
1 ACCEPTED SOLUTION

Accepted Solutions

@thunter 
I think you should be using the function Office365Outlook.SendEmailV2 instead of Office365Outlook.SendEmail.

 

Can you please try that and let me know the result?  Also, do you have the Office365Outlook connector added to the app?

 

---
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."

View solution in original post

8 REPLIES 8
mdevaney
Super User
Super User

@thunter 
This code is massive.  Are you able to isolate the error?  Trying removing sections of the code to figure out what works and what doesn't.

 

Also, is it possible that none of your conditions in UPDATECONTEXT are being met resulting in a blank email?

 

 

One suggestion I have is to make your UPDATECONTEXT more readable by using SWITCH instead of nested IF statements.

UpdateContext({
    e: Switch(DeptTxt.Text
        "Office","clericaltimeoff@xxxx.com",
        "Operations","dispatchtimeoff@xxxx.com",
        "Maintenance","mowens@xxxx.com",
        "Management","managertimeoff@xxxx.com"
})

 

---
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."

@mdevaney 

 

I ran the app using the Monitor tool to see if that would help. I have attached the data. It shows on line 35 of the Monitor report  a Bad Request. Any ideas? Thank you.

 

 

@thunter 

The problem appears to be with the 'createRow' open so maybe it has to do with submitting the 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."

@mdevaney 

 

I removed my data sources and then saved, and then re-added data sources to see if that would fix the problem. Now the only error i have is: Invocation of unknown or unsupported function on the SendEmail formula

 

powerapps3.jpg

@mdevaney 

 

I did some reading and found out the connector I was using Office365.SendEmail, was incorrect. It should be Office365Outlook.SendEmail. So now I have no errors showing, however, it still is not successful when clicking Submit button. Still have the Bad Request. Also, the App Checker shows zero errors in formulas. Strange....

@thunter 
I think you should be using the function Office365Outlook.SendEmailV2 instead of Office365Outlook.SendEmail.

 

Can you please try that and let me know the result?  Also, do you have the Office365Outlook connector added to the app?

 

---
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."

View solution in original post

@mdevaney 

 

Does the Office365Outlook.SendEmailV2 connector work differently?

@thunter 

Yes.  Additionally, V1 is deprecated so it could be removed at any time.

 

---
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."

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,745)