creating a CSV Table

[Sobiepan]

Greetings. I have read other entries but they are not working for my scenario. 

High level is I create an array variable called "Initialize variable - CSV "CSVData"  then I am using the get lists and libraries and piping that into my get files properties only which places it in an apply to each.
Next, I use a select action to grab the values from it
I then use a compose for no real reason at all
outside of the loop, i create a csv table with the data from the array variable.

The issue is i canont get anything but the last record. I know the reason, i just dont know how to fix it. I know each time it loops it needs to add that record to an array. I just dont know how to do that. please see below.

How do i get the content of the select or compose above into the CSVData variable above so i can create the csv table out of it?

[Andrew_J]

@Sobiepan,

I do not think you need the variable.  Just create the CSV tabel from the select.  Let me know if that works.

Regards,

Andrew

[Sobiepan]

because it is in a apply to each, i believe that would simply add the last record only to the table but i will give it a try when i get in and let you know. Appreciate the response.

[Sobiepan]

tested and this will not work as an array cannot append to an array. Than you.

[Sobiepan · Accepted solution]

I have figured this out and want to post the solution for those that might stumble across the same question.

Essentially, I create a string variable

Then i used an append to string variable to create my headers. 

Then i use a Select action in an apply to each to grab the record and its properties from Get Files Properties Only Action

Next I create a CSV Table WITHOUT headers and simply grabbing the Values
Next I use an Append to String Variable action to build out the variable outside my loop.

WHALA!

I hope this helps!