Answered

apply to each error 'action failed'

(1) 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 to know will it work way i wanted to be ?

Hope you will help me.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

NsL Coder 475 Moderator on at

Like (2)

Report
Copy link

Link copied!

The problem is likely the dynamic content you used in your apply to each. If you show the JSON Schema in your Parse JSON action, will be able to tell you exactly what's wrong.

However, I think this is a new designer issue, where the new designer is not putting the right dynamic content from a Parse JSON action, I reported this error a while ago to MS.

a proper dynamic content from a Parse JSON action should be like this:

@{body('Parse_JSON')}

NOT

@{outputs('Parse_JSON')}

Try switching to classic designer and re-add the dynamic content for the apply to each action with the parse json action's dynamic content for transactions.

Was this reply helpful? Yes No
Suggested answer

GA-23070429-0 on at

Like (1)

Report
Copy link

Link copied!

i have tried @{body('Parse_JSON')} but it gives me this error Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'

Was this reply helpful? Yes No
NsL Coder 475 Moderator on at

Like (2)

Report
Copy link

Link copied!

I think you mistaken what I am saying.

The new error you just posted, suggest that your Parse JSON action content field is resolving to NULL. Can you screenshot and show what you have in the Parse JSON action?

Was this reply helpful? Yes No
GA-23070429-0 on at

Like (1)

Report
Copy link

Link copied!

ahh i tried it on old version of it now its pulling from parse but apply each gives me this error "ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')' is of type 'Object'. The result must be a valid array."

Was this reply helpful? Yes No
Suggested answer

GA-23070429-0 on at

Like (1)

Report
Copy link

Link copied!

this is what i am getting from parse json

en this is the error taht i am getting

Was this reply helpful? Yes No
Verified answer

NsL Coder 475 Moderator on at

Like (1)

Report
Copy link

Link copied!

Your Parse JSON is at the top level an object, you cannot "apply to each" on an object.

So what you need to put in your apply to each is the transactions dynamic content, which is the array you are trying to loop

body('Parse_JSON')?['transactions']

Was this reply helpful? Yes No