Get and rename every single item from output with nested body.

[cancel01]

Hi everyone,

I am trying to collect and save data as quick and efficiently as possible.

What I have: I have a working flow that becomes too slow once it has to update/delete/add many rows in my excel tables.

What I am trying to do: I am trying to replace some steps with MSGraph in order to collect/compare data with my excel file and, depending on the result, update/delete/add rows in excel.

Issue: I have nested "body" in my output and still can't find a way to get every single item from "value" in order to rename them accordingly and compare them with the data I have in excel.

For now, I was only able to further filter out my output as follow (I used an expression with the "compose" connector):

But still I am not managing to get every single item neither with further "compose" nor with "parse json" or "filter array".

Any idea how I can get all the information correctly named and listed?

Thank you in advance,

Kind regards

[cancel01 · Accepted solution]

I found a solution to my problem:

After filtering out the values I need with Graph and with a compose node, I select the output of my compose node and for each item I just give the new names I need on the left side and on the right side, if needed, I select an item from that output with item()['realNameoftheItemfromtheOutput'].