Create CSV table is not generating columns with numerical values

(0) Share

Report

Posted on by katarina777

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.

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

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

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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
katarina777 5 on at

Like (0)

Report
Copy link

Link copied!

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.

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

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.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you still struggling?

Was this reply helpful? Yes No