Skip to main content

Notifications

Power Automate - General Discussion
Answered

Create CSV from Array

(0) ShareShare
ReportReport
Posted on by

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​ .jpg2023-05-03 16_55_05-Edit your flow _ Power Automate und 1 weitere Seite - Geschäftlich – Microsoft​ .jpg

  • Verified answer
    ManishSolanki Profile Picture
    ManishSolanki 15,075 on at
    Re: Create CSV from Array

    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:

    ManishSolanki_0-1683183727569.png

     

    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

     

  • Re: Create CSV from Array

    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"

    2023-05-04 08_14_13-Edit your flow _ Power Automate und 6 weitere Seiten - Geschäftlich – Microsoft​.jpg

     

     

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

     

    2023-05-04 08_16_11-Run History _ Power Automate und 6 weitere Seiten - Geschäftlich – Microsoft​ Ed.jpg

    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 Profile Picture
    ManishSolanki 15,075 on at
    Re: Create CSV from Array

    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>"}

    ManishSolanki_0-1683130605686.png

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard