Sending Emails using Office365.SendEmail()

[Anonymous]

I want to send the email when a SharePoint list item is added and have several questions on how to process.

1. I found that I can connect to Office 365 Outlook and use Office365.SendEmail() function which is pretty simple. The only question here is what is better in terms of which practice seems to be accepted or works the best. Compared to Sending Emails with using Microsoft Flow on PowerApp event, Microsoft Flow on SharePoint list event or sending within PowerApp using Office365.SendEmail(). Is there benefits of using one option over another?
2. I have trouble getting email from a field. The field is People/Group in SharePoint. I have this function in the OnSuccess trigger of the form:
   

   Office365.SendEmail(DataCardValue17.Selected.Email,"TEST","TEST");Navigate(MainPage,ScreenTransition.Fade); ResetForm(FormCreateTravelRequest)

   
   When I run the app and the form I get the following error on the Office365.SendEmail() function:
   

   The service returned an error: Office365!SendEmail: The method ‘SendEmail’ has an invalid value for parameter ‘To’

   Here is the pic:
   
   Now I thought maybe it is not pulling the email correctly from the form field, to test that out I created the Label1 and its text changed to:
   

   DataCardValue17.Selected.Email

   
   It appears to show the correct email. To test if it would work I changed the OnSuccess function to:
   

   Office365.SendEmail(Label1.Text,"TEST","TEST");Navigate(MainPage,ScreenTransition.Fade); ResetForm(FormCreateTravelRequest)

   
   I tried to run it again and now I get this error:
   

   The service returned an error: Office365!SendEmail: {“status”:404,”Message”:”User account does not exist”,”source”:”127.0.0.1”}

   Here is a pic:
   

   

   I thought maybe its because it has mail.onmicrosoft.com suffix, even though I tried to send myself an email with the mail.onmicrosoft.com and it worked same as just using my real email address. To remove that I changed the text function of the label to:

   Substitute(DataCardValue17.Selected.Email,"mail.onmicrosoft.com","ca")

   
   

   However, this still produces same error (User account does not exist)

   So now I am at a loss, what I am doing not right when trying to send the email?

3. I want to send a complex HTML email. How would I have to change the Office365.SendEmail() to do that?
   

   Is writing this function enough?

   Office365.SendEmail(Label1.Text,"<b>HTML TEXT</b><br><em>Hello World</em>","TEST",”isHtml:true”);

   Does it matter that I put all HTML in the Office.SendEmail() function, would it be better if I added an HTML text control and made it hidden and then just linked it to the function?

Any help really appreciated!

[JMAFO]

I'll explore the option with Flow. I'm also integrating this powerapp onto a sharepoint page so that might be better anyway. Thanks tomgardzinski.

[AlexisHA · Accepted solution]

Hey there you can use concat function to solve it. Save your mail in a Collection and Office365.SendEmail(Concat(Mail;Email;";");"TEST";"TEST").

It works ^^

[JMAFO]

@AlexisHA clever workaround. Thanks!!

[echodapogi]

Hello there, I know its an old thread, but i have a quick question. can you send an email from a mail distro as "Send As"?

Thanks