Unanswered

SharePoint List Automated Reminder

(0) Share

Report

Posted on by cgrath

I'm new to power automate. I set up this flow but I get this error when I test it. "The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')' is of type 'Object'. The result must be a valid array." The flow is based on two columns in the List: Date and Time, and Person / Group.

How do I fix this?

My flow looks like this:

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

Tonisv73 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
The outer apply to each is taking already all rows one-by-one from the result of get items.
So ditch the inner apply to each (it's referring to one result anyhow, there is no multiple things to go through) and move the send emails into outer apply to each cycle.
cgrath 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I don't know how to make that change. Whenever I build the flow, the extra apply each automatically appears when I add the Send email action.
cgrath 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to remove the extra 'apply to each' loop. But I still get an error when I test the flow.
"One or more recipients are invalid."
The Assignment Email field is a person/group column in the list.
cgrath 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I don't know how to make that change. Whenever I build the flow, the extra apply each automatically appears when I add the Send email action.