Power Platform Community Forum Thread Details

Hi,

Solution 1: Fix the Parse JSON Step

Step A: Check the actual data structure

Go to your flow run history

Look at the output of "Run a query against a dataset"

Expand the JSON to see the actual structure

Check what ['results'][0]['tables'][0]['rows'] actually contains

Step B: Generate proper schema

In Parse JSON step, click "Generate from sample"

Use the actual output from your query step

Paste the content of the rows array

This will create the correct schema

Solution 2: Alternative Expression Approaches

Option A: Use a different expression in Apply to each
Instead of body('Parse_JSON'), try:

outputs('Parse_JSON')

Option B: Parse the string if it's JSON
If the rows data is a JSON string, add a Compose action before Apply to each:

json

json(body('Parse_JSON'))

Then use outputs('Compose') in Apply to each.

Solution 3: Complete Rebuild (Recommended)

Step 1: Initialize Variable

Add "Initialize variable" action after your query

Name: ParsedRows

Type: Array

Value:

body('Run_a_query_against_a_dataset')['results'][0]['tables'][0]['rows']

Step 2: Skip Parse JSON

Remove the Parse JSON step entirely

Use the variable directly

Step 3: Apply to Each

Input: variables('ParsedRows')

Solution 4: Debugging Steps

Add these temporary actions to debug:

Debug Action 1: Compose - Check Query Output

json

body('Run_a_query_against_a_dataset')

Debug Action 2: Compose - Check Rows Structure

json

body('Run_a_query_against_a_dataset')?['results']?[0]?['tables']?[0]?['rows']

Debug Action 3: Compose - Check Type

json

string(body('Run_a_query_against_a_dataset')?['results']?[0]?['tables']?[0]?['rows'])

Solution 5: Handle Different Data Types

Add a condition before Apply to each:

Condition: Check if it's an array

json

equals(string(type(body('Parse_JSON'))), 'Array')

If True: Use body('Parse_JSON') in Apply to each
If False: Use array(body('Parse_JSON')) or handle as string

Recommended Fix (Step by Step)

Remove Parse JSON step completely

Add Initialize Variable after your query:
- Name: TableRows
- Type: Array
- Value: body('Run_a_query_against_a_dataset')['results'][0]['tables'][0]['rows']

Update Apply to each input to: variables('TableRows')

In Switch condition, reference current item as: item()

In Add new row, use: item()['ColumnName'] for specific values

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Community site session details

Power BI Query to Parse JSON to Dataverse giving apply to each error of string looking for array

Solution 1: Fix the Parse JSON Step

Solution 2: Alternative Expression Approaches

Solution 3: Complete Rebuild (Recommended)

Solution 4: Debugging Steps

Solution 5: Handle Different Data Types

Recommended Fix (Step by Step)

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Power BI Query to Parse JSON to Dataverse giving apply to each error of string looking for array

Solution 1: Fix the Parse JSON Step

Solution 2: Alternative Expression Approaches

Solution 3: Complete Rebuild (Recommended)

Solution 4: Debugging Steps

Solution 5: Handle Different Data Types

Recommended Fix (Step by Step)

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates