Unanswered

Sending email fails because of microsoft email address

(0) Share

Report

Posted on by StephenGW

583

I have an app that has worked for a long time. Now all of the sudden it is failing to deliver to a Microsoft address that I don't have in the list of emails. I keep the list of emails in an Excel sheet and they are pulled into the app based on a dropdown selection as well as a people picker combobox. It is adding the email address microsoft@powerapps.com into my list. Not at the beginning or end but in between other emails. Here is what happens when the button is selected.

Mail.SendEmailV3(DataCardValue59.Text&","&Concat(DataCardValue35.SelectedItems,Mail&","),DataCardValue21.Text,HtmlText1.HtmlText,true,{filenames:DataCardValue26.Selected.Result&DataCardValue27.Selected.Result&DataCardValue28.Selected.Area&Now()&".jpeg",files:UploadedImage1.Image}))

And a couple days later I get an email that says the message was undeliverable because of the recipient microsoft@powerapps.com. It shows the email addresses and it shows this microsoft email as the second in line.

Anybody have any ideas why this is happening?

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I'd recommend putting two labels on your app temporarily. Then put

DataCardValue59.Text

in one of them, and

Concat(DataCardValue35.SelectedItems,Mail&",")

in the other and see if you cannot narrow down where the issue is coming from
StephenGW 583 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush

Sorry, I should have put. I put one label and placed the whole thing in there and it only shows the emails in my list and does not include the microsoft email address.

DataCardValue59.Text&","&Concat(DataCardValue35.SelectedItems,Mail&",") returns only my list plus an extra comma at the end if the CB is empty.
StephenGW 583 on at

Like
a
(0)

Report
Copy link

Link copied!

Problem appears to be with the empty CB, if I fill that in then it sends. I will have to play around with this and see how I can exclude the extra comma and empty CB.
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
would you try typing this and see if it fixes your issue

Concat(DataCardValue35.SelectedItems,Mail,", ")
StephenGW 583 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush

I tried switching to this DataCardValue59.Text&","&Concat(DataCardValue35.SelectedItems,Mail,",") and some people are getting the emails but some are not. I removed all groups so it is only individual emails and it is still not working properly.

I went a step further and removed the CB from the whole thing down to only this Mail.SendEmailV3(DataCardValue59.Text and I am still not getting the emails but some are.
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

the updated version i sent you was just to get rid of your blank at end form a blank combobox. as for mail not reaching its targets, try sending an email to yourself with DataCardValue59.Text in the body and see if it leaves any of the data out maybe? If they are all there then if any of these emails are not internal, their server could just be blocking your delivery address. I know of some places that auto block stuff from hotmail, so could see it happening from microsoft servers. If they are all internal I am not sure what could be happening to you, as I email out tons of stuff via powerapps daily and do not experience this issue.
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

the updated version i sent you was just to get rid of your blank at end form a blank combobox. as for mail not reaching its targets, try sending an email to yourself with DataCardValue59.Text in the body and see if it leaves any of the data out maybe? If they are all there then if any of these emails are not internal, their server could just be blocking your delivery address. I know of some places that auto block stuff from hotmail, so could see it happening from microsoft servers. If they are all internal I am not sure what could be happening to you, as I email out tons of stuff via powerapps daily and do not experience this issue.
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Curious, have you tried using Office365.SendEmailV2() tool instea of the generic Mail()? It would probably be less likely to be bounced by servers if that is issue
StephenGW 583 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush

I think it was an issue with the groups and I needed to refresh the data source. This is the one I ended up using and it appears to be working now. I can't use the Outlook connector because of exchange server emails or something.

Thanks for your help!
mhoward 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Same issue here. We have three flows run every Monday morning, gathering data and sending out emails with attachments.

Today the emails did not arrive, but each of the flows show successful completion. Sending via Email Notification V3, so the emails are coming from microsoft@powerapps.com