Skip to main content

Notifications

Power Automate - General Discussion
Answered

Create CSV table is not generating columns with numerical values

(0) ShareShare
ReportReport
Posted on by 5

Hello,

i am new in Power Automate, so maybe my question is trivial, but i would appreciate your advice here.

I am using Create a CSV table function which works perfect when i am using "Automatic" columns, but as i need to reorder and rename columns, i am using Custom set up of columns.

First 2 fields have text values and the rest has numerical values.

 

katarina777_1-1698667131595.png

katarina777_2-1698667856915.png

However output generates only values for first two columns and not for the rest.

katarina777_6-1698669076069.png

I see some values in INPUT, but no within OUTPUT.

katarina777_5-1698669009846.png

 

Any idea pls what am i doing wrong?

I tried to change column names with Select function as well, but had the same issue.

 

Thanks in advance.

 

 

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Create CSV table is not generating columns with numerical values

    Are you still struggling?

     

  • katarina777 Profile Picture
    katarina777 5 on at
    Re: Create CSV table is not generating columns with numerical values

    Hi @SudeepGhatakNZ that helped me in step Create CSV table. Thank you so much!!

    However, in the next step i need to copy the content of that CSV file and add it into XLSX file via Apply Each/Add a row into a table.

    katarina777_2-1698930531063.png

     

    If i am using Output body('Create_CSV_table') from previous step, but i am getting error that it must be an array.

    katarina777_1-1698930095507.png

     

    The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Create_CSV_table')' is of type 'String'. The result must be a valid array.

     

    I tried already array(body('Create_CSV_table') but it didn't help. I got message:

    "The request entity's media type 'text/plain' is not supported for this resource."

     

    I will be glad for any help. Thanks in advance.

     

  • Verified answer
    SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Create CSV table is not generating columns with numerical values

    I think you must have the property names incorrectly defined in the item()['Prperty name'] expression.

    What I suggest is to use Parse JSON action and build a schema based on the output of your Power BI query.

    You can then simply pick the field names from the dynamic content.

     

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard