Answered

Send a form OnSuccess email notification to multiple email addresses with one variable email address

(0) Share

Report

Posted on by tagustin2020

Hello,

I need to send an email to 2 engineers plus the user who filled out the new request form. The notification email isn't going through. I've tried I've tried every quote, semi-colon, etc. variation I can think of. Can you please help me spot what I am doing wrong? Thanks!

Office365Outlook.SendEmailV2("jane.doe@company.com; john.doe@company.com" && varUser.Email,
"New Tool Support Request Notification",
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(NotificationEmailHTML.HtmlText,
"<recordID>", Text(frmNewRequest.LastSubmit.ID)),
"<fullName>", frmNewRequest.LastSubmit.'Created By'.DisplayName),
"<requestTitle>", frmNewRequest.LastSubmit.'Request Summary Title'),
"<description>", frmNewRequest.LastSubmit.Description),
"<neededBy>", Text(frmNewRequest.LastSubmit.'Needed By',ShortDate)
)
);
Set(HighlightRecord, frmNewRequest.LastSubmit);
ResetForm(frmNewRequest);
Navigate(HomeScreen, Transition.None);
Set(varPlaySpinner,false)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@tagustin2020

Hello again 🙂

Email sends properly if going to one person...correct?

Change your to line to the following:

"jane.doe@company.com; john.doe@company.com;" && varUser.Email

Note the additional semicolon after the second email to separate the added user email.

I hope this is helpful for you.

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

Like (0)

Report
Copy link

Link copied!
UPDATE: - I see @RandyHayes had already spotted it while I was composing my reply.

Hi @tagustin2020 ,

I think you are missing a semi-colon after johndoe@company.com;

Office365Outlook.SendEmailV2( "jane.doe@company.com; john.doe@company.com;" && varUser.Email, "New Tool Support Request Notification", Substitute( Substitute( Substitute( Substitute( Substitute( NotificationEmailHTML.HtmlText, "<recordID>", Text(frmNewRequest.LastSubmit.ID) ), "<fullName>", frmNewRequest.LastSubmit.'Created By'.DisplayName ), "<requestTitle>", frmNewRequest.LastSubmit.'Request Summary Title' ), "<description>", frmNewRequest.LastSubmit.Description ), "<neededBy>", Text(frmNewRequest.LastSubmit.'Needed By',ShortDate) ) ); Set( HighlightRecord, frmNewRequest.LastSubmit ); ResetForm(frmNewRequest); Navigate(HomeScreen, Transition.None); Set(varPlaySpinner,false)

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
tagustin2020 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
@WarrenBelz

Hello Randy and Warren,

Thank you for the advice. Yes, the email does work when going to one person. When I put the extra semi-colon in the place you suggested I get red squigglies and the pink email error message from MSFT when I submit a new form.

Teresa

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@tagustin2020

LOL...I should have noticed this right away...Change your line to this:

"jane.doe@company.com; john.doe@company.com;" & varUser.Email

You were using an AND operator (&&) not a Concatenation operator (&)

Enjoy!

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

Like (0)

Report
Copy link

Link copied!

@tagustin2020 ,

Bit of the forest and the trees going on - I should have spotted that as well. @RandyHayes is a bit sharper than me today.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz I looked at it a hundred times and said...what is wrong with that. Took a phone call, then looked back and it was immediately obvious. Go figure the mind!!

Was this reply helpful? Yes No
tagustin2020 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes
@WarrenBelz

Thank you! It seems to be working now. I see all 3 emails in the To line now. I know what you mean about tiny things making a difference. I had a flow that wasn't working yesterday because I was using double quotes instead of single quotes. It helps to have a second and third pair of eyes on things. Have a nice evening!

Was this reply helpful? Yes No