Unanswered

Flow fails after Filter Array with “An action failed. No dependent actions succeeded”

(0) Share

Report

Posted on by CU22071010-0

Hi everyone,

I’m building a Power Automate flow where I filter Excel data based on the Response ID from a Microsoft Form submission. I use the OData filter query in "List rows present in a table" and combine it with a Filter Array to ensure I only get the row that matches the Response ID. At first, I got no results from the Filter Array because the Response ID in Excel was a number (int) while the form response was a string. After applying a conversion using float() in the “Add to Table” step to match the types, the Filter Array now returns one row correctly.

The condition block now runs successfully. But after that, starting from the ‘For Each’ loops, my flow fails with this error:

ActionFailed – An action failed. No dependent actions succeeded.

I’m not sure what exactly causes it. I’ve tried checking the outputs and they seem valid. Here are more details:

What I’m doing in the flow:

Microsoft Form → Trigger
Get response details
List rows in Excel using OData filter:
>Response ID from list row excel table from previous flow eq Respond ID add row excel list table from this flow
Filter Array to match that row exactly (for Respond ID, I convert to float).
Condition checks a column like Does this environment installation have credentials? == "YES"
If true → Enter a For Each loop to send emails based on matching rows.
But flow fails right after that.

The one I circle red, is the one that failed.
🧪 What I’ve tried:
- Confirmed the Filter Array returns valid row.
- Made sure the column names match.
- Checked data types (string vs int/float).
- Previewed outputs from the Filter Array — it has data.
❓What I need help with:
1. Why do the steps inside For Each fail even though Filter Array are working?
2. I also need help finding the right way to reliably filter Excel rows by Response ID and then extract all columns from that same row for further conditions and email actions. What is the correct method to ensure only one row is used, and how can I trace which action fails inside the loop? Appreciate any help!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Tomac 4,061 Moderator on at

Like (1)

Report
Copy link

Link copied!

First up: don't use chatgpt for help with power automate, it's wrong far more often than it's right and is the source of a significant number of the issues posted here.

Next, your screenshots don't she the action that's failing. Inside of your For Each you've got a Condition, and then in the If True section you've got another Condition. Something inside of that second Condition is failing. Please expand all of the actions until you find the last one with an error and post that action to help resolve.

Was this reply helpful? Yes No
CU22071010-0 10 on at

Like (1)

Report
Copy link

Link copied!

Hi @Tomac,

Thank you so much for taking the time to reply earlier. After checking the last action as you suggested, I was able to identify and solve the issue—really appreciate your help!

However, I have one more problem I’m hoping to get your advice on. After applying the Filter array, I noticed that the email in my flow now keeps sending multiple times. Previously, before I added the filter, the email would only send once.

I understand that I can use the Terminate action to stop the flow, but the challenge is that my email is inside a For each loop. If I put the Terminate action right after sending the email (still inside the loop), the flow fails. But if I place it outside the loop, it doesn’t stop the loop from continuing.

Do you have any suggestions on how I can properly stop the flow after sending the email just once?

Thanks again in advance!

I had also attached my full flow.

Was this reply helpful? Yes No
CU22071010-0 10 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I had attached the clearer picture

Was this reply helpful? Yes No
Tomac 4,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

@CU22071010-0 It's hard to see from your screenshot, everything is very small and blurry. I think the best thing to do is to initialize a string variable at the top, and then inside your Apply To Each loop use a Set Variable action to set the content from the loop that you want to use in your email. Then move the Send An Email action outside of the loop and reference the string variable in the email.

If this and my previous comment resolved your issues, please mark them as the answer to help future users with this problem find the solution quickly.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!
@CU22071010-0 The logic of your flow needs to be adjusted. The number of nested for each loops is unnecessary and will most likely cause you issues. Also, are you running the List Rows Present in a Table action on the same table? If so, why are you running it so many times?

It's hard to offer any recommendations without seeing your full flow and the logic behind it. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.

Additionally, I think that you might be interested in these YT Tutorials to help you with your flow:

Are you using the Microsoft Power Automate Filter Array Action wrong?

Filter Array + Apply to Each: The Best Tip You Need to Know

3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

If you still run into issues while building your flow, share screenshots of your full flow and the logic behind it.
Upload a screenshot of your flow in edit mode.

Hope this helps!

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