Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : 3MU7Fpod1WczQKUhm9DI5X
Power Platform Community / Forums / Power Automate - General Discussion / Create CSV table is no...
Power Automate - General Discussion
Answered

Create CSV table is not generating columns with numerical values

Like (0) ShareShare
ReportReport
Posted on 30 Oct 2023 14:45:39 by katarina777 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,292 Most Valuable Professional on 03 Nov 2023 at 00:54:43
    Re: Create CSV table is not generating columns with numerical values

    Are you still struggling?

     

  • katarina777 Profile Picture
    katarina777 5 on 02 Nov 2023 at 13:09:55
    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,292 Most Valuable Professional on 30 Oct 2023 at 15:21:47
    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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans