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
Solved! Go to 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'].
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'].
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
66 | |
23 | |
16 | |
16 | |
13 |
User | Count |
---|---|
116 | |
35 | |
32 | |
28 | |
26 |