web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / The result of the eval...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 4

Hey

 

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

 

KevinLaRose_0-1699561979550.png

 

Categories:
  • creativeopinion Profile Picture
    10,508 Moderator on at

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

  • KevinLaRose Profile Picture
    4 on at

    KevinLaRose_0-1699905839220.png

     

    Let me know if you need each function displayed

     

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @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.

    creativeopinion_0-1699906021855.png

    creativeopinion_1-1699906034113.png

     

    The expression is unnecessary. 

     

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

  • KevinLaRose Profile Picture
    4 on at

    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)

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @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.

    creativeopinion_0-1699908271850.png

    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.

    creativeopinion_1-1699908410792.png

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 355

#2
11manish Profile Picture

11manish 336 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard