Answered

Create CSV from Array

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

2023-05-03 16_56_25-Run History _ Power Automate und 1 weitere Seite - Geschäftlich – Microsoft Edg.jpg

Here is my Flow.

2023-05-03 16_52_59-Edit your flow _ Power Automate und 1 weitere Seite - Geschäftlich – Microsoft .jpg 2023-05-03 16_55_05-Edit your flow _ Power Automate und 1 weitere Seite - Geschäftlich – Microsoft .jpg

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No