Create CSV from Array

[newbi]

Hello,
I have created a flow that should write data from a sharepoint list into a CSV file.

The CSV should be filled based on the array.

I get this error message:I get the Error : The property 'columns' must be specified unless the 'from' property value is an array of objects.

Because of the error message I am a bit confused what I have to do here to write the data into the CSV file.

Can someone here help me with my problem?

Here is my Flow. 

[ManishSolanki]

Hi @newbi 

You need to update the 'Append to array variable' action to incorporate the name of property with value. 'Convert to csv table' will accept those properties of array object as a header. I have designed a sample flow for you to refer:

{"Col1Heading":"<dynamic col1 value>","Col2Heading":"<dynamic col2 value>"}

Please add all the columns in the format as mentioned above.

If it works then please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[newbi]

Hello ManishSolanki, 

Thanks for your helps 

I'm not sure if i understand you correct. I add the values like in the "Append to array variable"

Result in the csv two lines with the same values I added to the array. 

In the csv file I expected the following two lines with different times

371; S11 - Kommt; 2023-04-27T11:56:00

371; S11 - Kommt; 2023-04-27T15:09:00

Thanks

[ManishSolanki · Accepted solution]

Hi @newbi 

You have hard coded the values in 'Append to array variable' action, but these should come from the SharePoint list inside "Apply to each" loop. To correct it, please replace "Append to array variable" action with the mentioned below:

Note: You need to change only the "Append to array variable" (highlighted in the above screenshot).

If it solves your problem, then please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks