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 / flow skips all records...
Power Automate
Answered

flow skips all records in apply to each, even though there is output in previous steps

(0) ShareShare
ReportReport
Posted on by 576

My flow is skipping the apply to each step, where there is a create item in sharepoint step. As you can see below, the previous step has output. thoughts?

ahhollan_0-1710947305685.png

 

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

    @ahhollan What are you looping through? If you are trying to loop through items returned from the Filter Array action, you need to insert the body output from the Filter Array action into the Apply to Each action. Parsing the JSON is unnecessary.

     

    To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

     

    In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

    1️⃣ Cross-Referencing Data

    2️⃣ Filtering by Key

    3️⃣ Substring Matching

     

    Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

     

    IN THIS VIDEO:

    ✅ 3 Ways to Use the Filter Array Action

    ✅ How to use the Scope Action to Group Actions

    ✅ How to Check the Number of Items returned from a Filter Array Action

    ✅ How to Cross-Reference Data in Excel with a SharePoint List

    ✅ How the Filter Array Action Works

    ✅ How to Access the Dynamic Content from a Filter Array Action

    ✅ How to Filter Items by a Key

    ✅ How to Filter Items by Matching a Substring

    ✅ How to Use Multiple Conditions in a Filter Array Action

     

    ---

    For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

     

    IN THIS VIDEO:

    ✅ How to troubleshoot a false Condition action result

    ✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

    ✅ How to troubleshoot an Apply to Each action that isn’t looping through

    ✅ How to troubleshoot a skipped Apply to Each action

    ✅ How to troubleshoot a Filter Query

    ✅ How to use a SharePoint yes/no column in a Filter Query

    ✅ How to use Compose actions to troubleshoot a Power Automate flow

    ✅ How to troubleshoot multiple emails being sent

    ✅ How to troubleshoot multiple Teams messages being sent

     

    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!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

     

     

  • ahhollan Profile Picture
    576 on at

    I've done that and it still skips all records. 

     

    ahhollan_0-1710953888448.png

     

  • ahhollan Profile Picture
    576 on at

    could it be because one side of my filter array is from a join with blank out put? 

  • Tomac Profile Picture
    4,171 Moderator on at

    You've shown us that the Parse JSON action has output, but we can't see what that Filter Array action is doing or outputting. I'd bet the problem is with that Action.

     

    Can you show us the formulas in use in that action and what the output of that action look like, so we can verify the input for the Apply To Each action?

  • ahhollan Profile Picture
    576 on at

    ahhollan_0-1711040031846.png

    The output is 9 records like below. (correct because the table has 9 items)

    ahhollan_0-1711040553525.png

     

  • Tomac Profile Picture
    4,171 Moderator on at

    To be clear, this is the output from the Filter Array action or from the previous Join action?

  • ahhollan Profile Picture
    576 on at

    filter array action

  • Tomac Profile Picture
    4,171 Moderator on at

    For debugging purposes, prior to your Apply To Each action can you add a Format HTML Table action with the output of your Filter Array and a Send An Email action to email that HTML table to yourself and verify that the output is what you're expecting to see.

     

    If the Apply To Each isn't even running, that implies it's being fed an empty array.

  • ahhollan Profile Picture
    576 on at

    the html table has the expected values. 

  • Tomac Profile Picture
    4,171 Moderator on at

    My only suggestion is in your Apply To Each, remove the Body value:

    Tomac_0-1711041854901.png

     

    Then reselect it from the dynamic values list, save the flow and test it again.

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 423

#2
11manish Profile Picture

11manish 308 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 177

Last 30 days Overall leaderboard