cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ilpao73
New Member

Problem to send email to email groups when an element of sharepoint is modified

Hello,

I have this problem:

I have this list, where TEST_QM_e_SPE is a group of 2 people (Omar e Marco)

Ilpao73_2-1657545112184.png

TEST_QM_e_SPE group:

Ilpao73_1-1657545289701.png

The flow is:

Ilpao73_1-1657544738133.png

But I have this error:

"status"400,
  "message""One or more recipients are invalid.\r\nclientRequestId: b3fe5397-8c24-48eb-b7f5-da3b57aadd8a\r\nserviceRequestId: eb638ba1-352f-ce06-183c-33aea9c7e4b6",
  "error": {
    "message""One or more recipients are invalid.",
    "code""ErrorInvalidRecipients",
    "originalMessage""At least one recipient is not valid., Recipient 'Gambuzzi' is not resolved. All recipients must be resolved before a message can be submitted."
  },
  "source""office365-ne.azconn-ne-002.p.azurewebsites.net"
}

Could you help me?

If I write, for exemple, 10 email, the flow is ok, but if I use a group with 2 or more emails, I will have the error above.

Thanks for your help

Marco

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @Ilpao73 ,

 

It seems that you have two lists and the column 'Riceraca_email_gruppoutenti' is a Lookup column.

vyujincuimsft_0-1657868330198.png

vyujincuimsft_1-1657868514204.png

If so, i have made a simple test for your reference.

1. Here are my lists.

vyujincuimsft_0-1657869099705.png

2. Here is my Flow.

 

@not(equals(triggerBody()?['Created'], triggerBody()?['Modified']))
InternalColumnName eq 'Dynamic Content'

 

vyujincuimsft_1-1657869670122.png

vyujincuimsft_2-1657869715635.png

Result Screenshot:

vyujincuimsft_3-1657869776863.png

 

 

Best Regards,
Charlie Choi

View solution in original post

3 REPLIES 3
Koen5
Continued Contributor
Continued Contributor

Dear Ilpao73,

It seems that the flow bucks on the 'group'. Would it be possible to identify the group into its individual members first by using any of the 'User' actions? View below.

Koen5_0-1657548275268.png

 

 

Happy flowing,

Koen

 

 

 

 

Ilpao73
New Member

Now, during the test I have 0 errors, but the emails don't arrive.

Ilpao73_0-1657549388507.png

 

v-yujincui-msft
Community Support
Community Support

Hi @Ilpao73 ,

 

It seems that you have two lists and the column 'Riceraca_email_gruppoutenti' is a Lookup column.

vyujincuimsft_0-1657868330198.png

vyujincuimsft_1-1657868514204.png

If so, i have made a simple test for your reference.

1. Here are my lists.

vyujincuimsft_0-1657869099705.png

2. Here is my Flow.

 

@not(equals(triggerBody()?['Created'], triggerBody()?['Modified']))
InternalColumnName eq 'Dynamic Content'

 

vyujincuimsft_1-1657869670122.png

vyujincuimsft_2-1657869715635.png

Result Screenshot:

vyujincuimsft_3-1657869776863.png

 

 

Best Regards,
Charlie Choi

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,435)