Unable to use the results of Parse JSON step

Hi all

I'm hoping someone can help me with this because i'm causing a bold spot with all the head scratching i'm doing!

ok so i'm running a query against a dataset in power bi, sending that data through a Parse JSON and i want to put all of that information into an array so i can filter it down and send the relevant information to those that need to know based on a boolean column and the information in the linemanagerEmail column.

I've been working on this for a while so i've tried many variations but I keep coming to the same brick wall

No matter the equation i just can't seem to get power automate to see the data within the JSON output.

This is the beginning of the output from the Parse JSON step which i'm trying to access info from

{"body":{"results":[{"tables":[{"rows":[{"Briefings[Employee Information.EN]":

the variable has to be of type object so i'm sure that i'm going to have to put multiple steps in to actually get this information into an array, any and all assistance would be super appreciated!

Equations currently tested;

first(body('Parse_JSON')?['body']['results']['tables']['rows'])['Briefings[Employee Name]']

body('Parse_JSON')?['body']['results'])['Briefings[Employee Name]']

first(body('Parse_JSON')?['body']['results'])

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

(i'm only using first as a test to see if i can get 'something' out)

Quick Links

Leaderboard > Power Automate - Building Flows