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:

Using flows

All responses (4)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @s44 ,

Please check this thread:

Create a CSV file without header - Power Platform Community (microsoft.com)

Best Regards,

Bof
Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

.
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 😞
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @s44
can you post an example of what you want the end result to look like with dummy data?