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.
Are you still struggling?
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.
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.