Unanswered

apply to each error 'action failed'

(2) Share

Report

Posted on by GA-23070429-0

Hello i have been trying to make a flow that runs every 20 minutes to get transaction data from bank but it giving me this error "An action failed. No dependent actions succeeded." from apply each.

Here is what i am trying to do I'm new to power automate.

Trigger: Recurrence (every 20 minutes).
HTTP: Make an HTTP request to get JSON data.
Parse JSON: Parse the response from the HTTP request.
List rows present in a table: Get existing data from Excel.
Apply to each: Loop through JSON data.
- Output: @{outputs('Parse_JSON')?['transactions']}
- Condition: Check if Amount is greater than or equal to 0.
  - If yes:
    - Apply to each: Loop through Excel table rows.
      - Output: value (from List rows present in a table).
      - Condition: Check if JSON ID matches any Excel ID.
        
        If no: Add a row into the table

My main goal is to recieve bank data to excel without any duplication and only income data. also i'd like o know will it work way i wanted to be?

Hope you will help me. thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

narayan225 2,547 Super User 2025 Season 2 on at

Like (1)

Report

You need to go to the exact iteration that caused the issue and find the error from there.

You can achieve what you are trying to do but need to check where it is failing.

Go through each step of apply to each and one of the actions should have the error you are looking form.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
ManSed 2 on at

Like (1)

Report

As far as I see, you should verify if all conditions are working correctly. To do this, you can disable the second "foreach" loop and add an array or string variable after the first condition. Then, observe the results you obtain. If the results are good, move on to the next set of conditions and repeat the process.

Once you are confident that the results are accurate, it's important to verify the final step, which involves inserting data into the Excel table.

Was this reply helpful? Yes No
NC 2 on at

Like (1)

Report

The problem is in the condition_1 step of you flow. It says invalidTemplate. Can you expand on whats happening in condition_1?
My best guess is you are not accessing the excel column value correctly in the for each.
I always like to use compose to see the data in cases like this. Use a compose to see the data before condition_1 to see if its returning the data in the way you wanted.

I would also like to add that the second for each can be replaced with the excel action 'Get a row' and with the ID from parsed json as key value, and remove the entire 'list rows from excel' action.
Another way is to use filter array on the excel table and check its length instead of for each.

Was this reply helpful? Yes No
Suggested answer

GA-23070429-0 on at

Like (1)

Report

hello i have used the get row action but i think i am using it wrong here are all of the error that i am getting

Was this reply helpful? Yes No
narayan225 2,547 Super User 2025 Season 2 on at

Like (1)

Report

The error message says that the record was not found which is why it is returning 404 error.

I suggest you investigate the Get row action and find fi the row actually exists with the matching Record value.

Hope this helps.

Cheers!

Was this reply helpful? Yes No