Unanswered

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

(0) Share

Report

Posted on by 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.

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.
Condition: Today's date is greater than the "Reminder Date" and less than or equal to the "Due Date".
Switch on "Status": For testing, I am only handling the case where Status equals "Writing Report".
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.

Categories:

Using flows

I have the same question (0)

All responses (14)

Answers (2)

v-yetonggu-msft on at

Like (0)

Report

Hi @marmot777 ,

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
marmot777 33 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
marmot777 33 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @marmot777 ,

Please carefully check the configuration parameters in 'Select':

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
marmot777 33 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report

Hi @marmot777 ,

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
marmot777 33 on at

Like (0)

Report

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!!

Was this reply helpful? Yes No
marmot777 33 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No