Send email action fails with "One or more recipients are invalid." error

Like (0) Share

Report

Posted on 26 Feb 2020 06:25:47 by CU20081036-0

177

I have created a flow that sends email to email address saved in a "single line of text" column in a SharePoint list. Email addresses are separated by ";". When I add this column to To/CC field in the send email action, a new line character gets introduced if the email address contains numeric value. For e.g. if the addresses saved in column is abc13@xyz.com;abc05@xyz.com it appears as below(new line after 13 and 05) in email making it an invalid email address. Has anyone experienced this problem?

abc13

@Anonymous.com;abc05

@Anonymous.com

I have the same question (0)

All responses (14)

Answers (2)

efialttes 14,756 on 28 Feb 2020 at 08:11:45

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

HURRAY!

IT WORKS!

My humble suggestion:

1.-Thanx for marking this topic as "Solved" by clicking "Accept as a solution" on the right answers. This is the way other community members facing this same problem in the future can find a solution faster

2.- Since we cannot reproduce the second issue, open a new thread following the policy: 'One Question, one post'. Many Super Users do pay special attention to topics with 0 responses, and this one has too many so far

3.- (OPTIONAL) Click on 'Thumbs up' in any answer you found valuable in the current topic, if not all

Even though this 3rd step is OPTIONAL, please remember it is the cheapest, easiest way to say thanks to somebody that simply tried to help. And just between you and me, everytime an inspiring answer receive a kudo, an ewok escapes from The Emperor menace 😉

Thanx for taking the time to mark this topic as solved!

Was this reply helpful? Yes No
v-bacao-msft on 28 Feb 2020 at 07:04:59

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Hi @sunithav ,

I am glad that our suggestions are helpful to solve this issue.

I am afraid that I don’t know why this issue appeared on your side. I have made a test on my side but cannot reproduce the same issue.🤔

Best Regards,

Was this reply helpful? Yes No
CU20081036-0 177 on 28 Feb 2020 at 06:47:23

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Thanks @efialttes and @v-bacao-msft. The fix suggested worked.

@v-bacao-msft , The data saved in SharePoint list is output of HtmlToText conversion action. The line break was introduced in this step. Do you know why/how random line break get added? Is this a known issue?

Thanks,
SV

Was this reply helpful? Yes No
CU20081036-0 177 on 27 Feb 2020 at 05:58:03

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Interesting trick. I will give this a try and let you know how it goes.
Thank You
SV

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on 27 Feb 2020 at 03:09:50

Like (1)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Hi @sunithav ,

You can store the value of this field in Compose first. After running Flow, if the output of Compose is shown in the following figure, you can refer to the following method to achieve your needs.

Method:

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on 26 Feb 2020 at 12:50:15

Like (1)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Oops!

Still unclear to me the reason for the bloddy New Line. Is your SP column declared as rich text or so? Jsut guessing what the problem can be...

Another dirty trick:

Let's assume your list of emails is stored in a variable called 'currentEmailList'

Create a dummy Compose (let's call it Compose), add a new line as its value (just hit enter)

Create a second Compose (let's call it Compose 2), use replace() function to remove the new lines:

replace(variables('currentEmailList'),outputs('Compose'),'')

Use this second Compose to fill To / CC

Hope this helps

Was this reply helpful? Yes No
CU20081036-0 177 on 26 Feb 2020 at 12:42:42

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Update - Adding ";" at the end of the email address failed. The workaround doesnt work.

Thanks,
SV.

Was this reply helpful? Yes No
efialttes 14,756 on 26 Feb 2020 at 11:55:44

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Hi again

I agree with you it still sounds weird, but at least we have a workaround up and running 😁

Please note you can automate the addition of the semicolon at the end of your list of emails by means of Power Automate and

function concat()

Hope this helps

Was this reply helpful? Yes No
CU20081036-0 177 on 26 Feb 2020 at 11:14:25

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Adding ";" at the end of the email addresses with ";" works fine. That's one way that we have thought of making this work.

Whats unknown to us is how the "new line" is getting introduced in the email address.

Thanks,
SV

Was this reply helpful? Yes No
efialttes 14,756 on 26 Feb 2020 at 09:54:04

Like (0)

Report

Re: Send email action fails with "One or more recipients are invalid." error

Mmmm....

Can you try to add a ; at the end of one of your email address lists, just for testing purposes, and see if the problem is solved, persists, or gets even worse?

Was this reply helpful? Yes No