"Apply to Each" fails to send email when a Dynamic Value is used for the email address

[marmot777]

I'm trying to generate a reminder email only for items that are NOT complete and in between a reminder date and a due date. It works and sends the email when the email is hard-coded (blah@blah.com) , but fails if I try to use the "Author email" field from the associated SharePoint list.

My Power Flow is associated with a SharePoint list.

1. Get items:
   1. Only items with a "Status" NOT EQUAL to "Complete". "Status" is a column from the SharePoint list.
   2. Filters columns by using "Limit Columns by View". I made sure to include the multiple person/group column, "Author" which I use later for the email.
2. Condition: Today's date is greater than the "Reminder Date" and less than or equal to the "Due Date".
3. Switch on "Status": For testing, I am only handling the case where Status equals "Writing Report".
4. Send an email: This is where I need help. If I hard-code an email address, it sends the emails without error. But if I use the Dynamic Value "Author Email" it errors and fails to send the email. NOTE: The "Apply to each 2" step with "Current item" was generated automatically when I added the Author Email field.

The ERROR:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

 

 

 

 

[v-yetonggu-msft]

Hi @marmot777 ,

Please try to replace the current item dynamic content with Author dynamic content.

Best Regards,

Sunshine Gu

[marmot777]

Hi Sunshine Gu, thanks so much for taking a look at my problem. I tried to do exactly what you said, but it instead it created another "Apply to each" step (see below). It won't let me put in just "Author Email" by itself. When I tried running it, it gave me the exact same error in the exact same place.

 

[v-yetonggu-msft]

Hi @marmot777 ,

Your Author column should be a multi-select person column, right?

If so,please check this test:

In my scenario:

item()?['Email']
join(body('Select'),';')

Best Regards,

Sunshine Gu

[marmot777]

Novice here...but I can't make my flow look like yours. Again, it added another "Apply to each".

 

 

[v-yetonggu-msft]

Hi @marmot777 ,

Please carefully check the configuration parameters in 'Select':

Best Regards,

Sunshine Gu

[marmot777]

I tried both "Author" and "Author email" but ended up with the same error.

 

 

 

[v-yetonggu-msft · Accepted solution]

Hi @marmot777 ,

Please delete Apply to each3 and change Author Email to Author.

Best Regards,

Sunshine Gu

[marmot777]

With your help, I was able to get the following working and sending emails. Is this the solution, or was this a test and you have something else in mind.

THANK YOU!!

 

 

[marmot777]

Also, if this is the solution, what is the most efficient way to add more email addresses to CC to?

[v-yetonggu-msft]

Hi  @marmot777 ,

If I solve your problem, please mark my response as a solution so I can help more people who are experiencing this challenge in the future.

For your new question, you can re-post it on the forum so that more people can see it, which will solve your problem more efficiently.

Best Regards,

Sunshine Gu

[marmot777]

Hi Sunshine Gu, I don't feel like my problem is solved yet because I don't know how to send the email to multiple email addresses. Also, I don't understand your solution enough to compose a clearly written question. Was this your intended solution, or a test case like you said before. 

[v-yetonggu-msft]

Hi @marmot777 ，

1)In the Send an email, we already use the join function to join the email addresses of multiple authors together to send an email to multiple email addresses.

You can check in the running records whether the ‘To’ of send an email is multiple email addresses separated by ';'.

2)Also, this is just a test example I'm showing you how to send emails to multiple authors' email addresses.

If you have other questions, please create a new post and provide more description information, and more people will help you answer it.

Best Regards,

Sunshine Gu

[marmot777]

Hi Sunshine Gu, I need to also CC multiple "Leads" and "Managers" in the same way. How do I expand on  your solution to include groups to CC? I tried the following...with the "To" field Expression filled in as

join(body('Select_2'), ';')

 

With the following error:

 

 

[v-yetonggu-msft · Accepted solution]

Hi @marmot777 ,

Please enter the expression manually.

Do not directly select the 'Author Email' and 'Lead Email' dynamic content.

This will cause unnecessary loops and flow will report an error.

In addition, I found another problem.

If your 'Status' is a single-choice column, you should use ’Status Value‘ instead of ’Status‘.

Like this:

item()?['Email']
join(body('Select'),';')
join(body('Select_2'),';')

Best Regards,

Sunshine Gu