Answered

How do I grab values from a select map to output to an Excel table?

(0) Share

Report

Posted on by bballjoe12

Does anyone know the best way to output this body and insert it into an excel file? When I select the action, "Add a row to an Excel table," none of the values from the select are available. This select action is within a "Apply to each." Is there someway I could grab the values from the select map and put those into variables and then output those into the excel table?

The below is what the select action is outputting:

Annotation 2021-04-22 234253.jpg

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

Verified answer

Paulie78 8,424 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Add a row to an Excel table is an item level action, but select produces an array. So if you add a parse JSON step and use the select as the input for it, and paste in a sample of the output into the schema generation tool, then you can go into an apply to each action using the parse JSON as the source. Then within the loop you will be at the item level and Add a row to an Excel table will work.
bballjoe12 6 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked perfect! Thank you SO much!
bballjoe12 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Paulie78,

Is there any other form of output I could use other than an Excel table which would be easily importable to Power BI?

Reason I am asking is because I then use the Excel table inside of Power BI. The issue is the Excel table will have at least 1000 rows but these rows will need to get deleted every morning for a new refresh of data. I'm thinking if I use another apply to each earlier in my flow to go through the Excel file and delete 1000s of rows, the flow will take VERY long.
Paulie78 8,424 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Why not just use a CSV?