Office365Outlook.SendEmailV2 failed: The method 'SendEmailV2' has an invalid value parameter 'To'

[123testing321]

Hello all,

I have a form that sends an email and saves data to SharePoint list. However, I am receiving an error that there is a problem with my "To" parameter.  Therefore, it does not send an email when I complete the form but it saves the data to SharePoint list. The email that I use is an email from the "Requested By" (DataCardValue22.Selected.Email) field is valid because I've tested it by manually entering it in the code below:

Here's the code from OnSuccess property of the form:

Office365Outlook.SendEmailV2(DataCardValue22.Selected.Email,

"New Request: " &DataCardValue30.Text

, HtmlText1_2.HtmlText,

{Cc: DataCardValue35.Selected.Email &";"& DataCardValue39.Selected.Email &";"&DataCardValue40.Selected.Email &";"& DataCardValue41.Selected.Email

,Importance: "High"

,Attachments: RenameColumns(DataCardValue42.Attachments,"Value", "ContentBytes" ) }
);

ResetForm(Form1_2);
NewForm(Form1_2);

For the Submit OnSelect property of the form, this is the only code I have:

SubmitForm(Form1_2);

I'm not sure why it is giving me an error that there is something wrong with my email parameter to "To" when it is a valid email. Is it how I arranged my code OnSelect and OnSuccess property? Anyone had a similar problem like me?

[Ramole]

Hi @123testing321 
Have look this post it is similar 
https://powerusers.microsoft.com/t5/Building-Power-Apps/Office365-SendEmail-failed-The-method-SendEm...  

[123testing321]

Thanks for the reply. I don't think its the selection of email that is wrong because the dropdown menu for selection of email is very explicit:

Therefore, I selected .Email

But thanks for trying anyways. 

I've tried something else which sends an email and sends data to my SharePoint list: I've added this code to the "OnSelect" property of the Submit button:

Office365Outlook.SendEmailV2(DataCardValue22.Selected.Email,

"New Request: " &DataCardValue30.Text

, HtmlText1_2.HtmlText,

{Cc: DataCardValue35.Selected.Email &";"& DataCardValue39.Selected.Email &";"&DataCardValue40.Selected.Email &";"& DataCardValue41.Selected.Email

,Importance: "High"

,Attachments: RenameColumns(DataCardValue42.Attachments,"Value", "ContentBytes" ) }
);



SubmitForm(Form1_2);
ResetForm(Form1_2);
NewForm(Form1_2);

but it does not verify the form because its not on the OnSuccess property. How do I get it so that it verifies the required fields for me and still sends the appropriate email? 

[123testing321]

I was able to solve this I think, keeping the main core of the code on the OnSuccess property of the form while just having the Submit OnSelect property just having the submit form code. What I changed was instead of using DataCardValue straight from the form, I used LastSubmit on the OnSucces property:

Office365Outlook.SendEmailV2(Form1_2.LastSubmit.'Requested By'.Email,

"New Request: " &DataCardValue30.Text

, HtmlText1_2.HtmlText,

{Cc: Form1_2.LastSubmit.'Department Manager'.Email &";"& Form1_2.LastSubmit.'Department Director'.Email &";"&Form1_2.LastSubmit.'Hi Acute Director'.Email &";"& Form1_2.LastSubmit.'Business Sponsor'.Email

,Importance: "High"

,Attachments: RenameColumns(DataCardValue42.Attachments,"Value", "ContentBytes" ) }
);

ResetForm(Form1_2);

This now sends email and still save the data in the SharePoint list. I will test it some more but I think it does what it needs to do unless of course others have issues with it? Let me know.

[Ramole]

Hi @123testing321 
Sorry I was away from my pc, but It looks good