The result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

(0) Share

Report

Posted on by KevinLaRose

Hey

Looking to set up a reoccurring flow that checks a Microsoft list verifying the status of certain columns.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Re: The result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

@KevinLaRose Can you please share a screenshot of the rest of your flow? Thx.

Was this reply helpful? Yes No
KevinLaRose 4 on at

Like (0)

Report

Re: The result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

Let me know if you need each function displayed

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Re: The result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

@KevinLaRose In the Apply to Each action, you should be using the value dynamic content from the Get Items action above which is an array of items.

The expression is unnecessary.

Can you provide more insight on what you are trying to accomplish in your flow?

Was this reply helpful? Yes No
KevinLaRose 4 on at

Like (0)

Report

Re: The result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

Yes, I am developing a workflow that will check a sharepoint list once a week and depending on what one column has in the list it will perform an action (IE email notification or set up a meeting)

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Re: The result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

@KevinLaRose Depending on how large your list is. I would recommend first using the Filter Query in the Get Items action to filter out your SharePoint list. For example, in my list below—I'm filtering out items where the Status is 'Due Soon' or 'Overdue'.

Reason for using the Filter Query is so that you aren't looping through every single item in your list (unless that's a requirement). Instead, you are looping through a smaller amount of items and then performing action(s) on those items returned.
What you can also do is check the count of items returned before continuing on with your flow. This will prevent your flow from unnecessarily running the Apply to Each action if there aren't any items returned.
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No