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

[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:

[Paulie78 · Accepted solution]

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]

This worked perfect! Thank you SO much!

[bballjoe12]

@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]

Why not just use a CSV?