Unanswered

Create a CSV file without header

(0) Share

Report

Posted on by Hii_iii

691

I am trying to create a CSV file without a header and then create it in a Sharepoint folder. I retrieve my values from my MySQL database. I would like all the values from my database to be in my CSV file. I don't want to create one CSV file on Sharepoint per line, I want all my lines to be in the same CSV file.

I have this error 😞 :

Échec de l’enregistrement du flux avec le code « InvalidTemplate » et le message « The template validation failed: 'The inputs of template action 'Créer_un_tableau_CSV' at line '1 and column '30340' is invalid. Action 'Appliquer_à_chacun' must be a parent 'foreach' scope of action 'Créer_un_tableau_CSV' to be referenced by 'repeatItems' or 'items' functions.'. ».

Can you help me please 😞 ?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @s44 ,

To remove the header of the CSV table, you just need to delete the first row of the result returned by 'Create CSV table'. I've made a test for your reference:

skip(body('Create_CSV_table'),add(indexOf(body('Create_CSV_table'),decodeUriComponent('%0A')),1))

Result:

Best Regards,

Bof

Was this reply helpful? Yes No
Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

The problem is that it creates one file per line for me. I would like it to create just one file with all the lines from my database inside. I would like to have consecutive lines for all the elements that are in my "valeur_consommation" and "ug" field and consecutive lines for all the elements in my "etiquette_consommation" and 'ug" field

Was this reply helpful? Yes No
Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft

Was this reply helpful? Yes No