Parse JSON into Apply to each not identifying each item, only allows me to choose Body

[qphalen]

Hello - I have the below flow but am struggling as I cannot get my Parse JSON to separate the different items from the query to then add the individual rows into excel.

My query is as follows: 

// DAX Query
DEFINE
	VAR __DS0FilterTable = 
		FILTER(
			KEEPFILTERS(VALUES('TrainingRequests'[Training Request])),
			AND(
				'TrainingRequests'[Training Request] IN {1,
					2},
				'TrainingRequests'[Training Request] IN {1,
					2}
			)
		)

	VAR __DS0FilterTable2 = 
		TREATAS({BLANK()}, 'DataSource'[Certification Date])

	VAR __DS0Core = 
		SUMMARIZECOLUMNS(
			'TrainingRequests'[Region],
			'TrainingRequests'[Location],
			'TrainingRequests'[Repair Item Name],
			'TrainingRequests'[Franchise],
			__DS0FilterTable,
			__DS0FilterTable2,
			"Total_Requests", 'TrainingRequests'[Total_Requests],
			"Total_Gaps", 'TrainingRequests'[Total_Gaps],
			"DataPulledON", 'TrainingRequests'[DataPulledON]
		)

	VAR __DS0PrimaryWindowed = 
		TOPN(
			501,
			__DS0Core,
			'TrainingRequests'[Repair Item Name],
			1,
			'TrainingRequests'[Region],
			1,
			'TrainingRequests'[Location],
			1,
			'TrainingRequests'[Franchise],
			1
		)

EVALUATE
	__DS0PrimaryWindowed

ORDER BY
	'TrainingRequests'[Repair Item Name],
	'TrainingRequests'[Region],
	'TrainingRequests'[Location],
	'TrainingRequests'[Franchise]

and then the content for the schema is the following function: 

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

and the schema itself:

{
    "TrainingRequests": [
        {
            "TableName": "TrainingRequests",
            "DatePulledON": "01/25/2024",
            "Region": "UK",
            "Franchise": "Workshop",
            "Repair Item Name": "Item 1",
            "Training Requests": 1,
            "Training Gaps": 0
        },
        {
            "TableName": "TrainingRequests",
            "DatePulledON": "02/25/2024",
            "Region": "UK",
            "Franchise": "Workshop",
            "Repair Item Name": "Item 2",
            "Training Requests": 1,
            "Training Gaps": 0
        },
        {
            "TableName": "TrainingRequests",
            "DatePulledON": "03/25/2024",
            "Region": "UK",
            "Franchise": "Workshop",
            "Repair Item Name": "Item 3",
            "Training Requests": 1,
            "Training Gaps": 0
        },
        {
            "TableName": "TrainingRequests",
            "DatePulledON": "01/25/2024",
            "Region": "UK",
            "Franchise": "Workshop",
            "Repair Item Name": "Item 4",
            "Training Requests": 1,
            "Training Gaps": 0
        }
    ]
}

so I would expect that when I get to the apply to each that I would have a JSON option for each field: Region, Franchise, etc. but instead I get:

Any idea where I am going wrong? 

[v-yueyun-msft · Accepted solution]

Hi , @qphalen 

According to your description, you want to use the "Parse Json" before add a row.

This is my test flow you can refer to :

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

Then we can select the field value under the Parse Json action:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[qphalen]

Amazing - works perfectly!