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
Amountis greater than or equal to 0.- If yes:
- Apply to each: Loop through Excel table rows.
- Output:
value(fromList rows present in a table). - Condition: Check if JSON
IDmatches any ExcelID.- If no: Add a row into the table
- Output:
- Apply to each: Loop through Excel table rows.
- If yes:
- Output:
My main goal is to recieve bank data to excel without any duplication and only income data.
Hope you will help me.
284
