Unanswered

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

(0) Share

Report

Posted on by ahhollan

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?

Categories:

Building flows

I have the same question (0)

All responses (26)

Answers (2)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

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

@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

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Tomac 3,924 Moderator on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Tomac 3,924 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

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

filter array action

Was this reply helpful? Yes No
Tomac 3,924 Moderator on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

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

the html table has the expected values.

Was this reply helpful? Yes No
Tomac 3,924 Moderator on at

Like (0)

Report

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

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

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

Was this reply helpful? Yes No