Export a collection data to CSV in the column order of the collection

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi there!

I have several galleries to export to CSV.

So, for example, I put a button with this code:

_________________________________________________________________________________________
ClearCollect(colDataTempDestination , SortByColumns(Inventory_Destinations,"cr815_name"));
ForAll(colDataTempDestination, Collect(ColDataExport, 
{
Destination:ThisRecord.Name, 
Code: ThisRecord.Code, 
Address: ThisRecord.Address, 
City:  ThisRecord.City, 
State: ThisRecord.State, 
ZIP:  ThisRecord.ZipCode, 
Country:  ThisRecord.Country.Name, 
Status_Active: ThisRecord.Active
}));
Set(varJSONData, JSON(ColDataExport));
Set(VarLinkToFile, ExportDataToCSV.Run(varJSONData,"Destinations_" & Now() & ".csv").linktocsvfile);
Launch(VarLinkToFile);
Clear(ColDataExport)
_________________________________________________________________________________________
 
So, the code creates the collection and send this data to a Flow that receives the data, create a CSV Table and save it in OneDrive as CSV file.
 
 
Yes, I choosed Automatic for Columns... So the CSV file created, sorts the columns names in alphabetical order, instead the order I made in the collection:
 
Destination
Code
Address
City
State
ZIP
Country
Status_Active
 
And I want to use the same flow for all the exportations.
 
Is there any way to achive that? Or I need to create a flow for each gallery and format the columns in each of them?
 
Thanks for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

EmilioRoqueta69 565 on at

Like (0)

Report
Copy link

Link copied!

I realized that the collection shows the columns in alphabetical order...

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @EmilioRoqueta69,

If you want to put CSV columns in your desired order, you need to go back to the pre-JSON process as below
With( { _Data: SortByColumns( Inventory_Destinations, "cr815_name" ) }, With( { _Export: "Destination,Code,Address,City,State,ZIP,Country,Status_Active" & Char(10) & Concat( _Data, Name & "," & Code & "," & Address & "," & City & "," & State & "," & ZipCode & "," & Country.Name & "," & Active, Char(10) ) }, Launch( ExportDataToCSV.Run( _Export, "Destinations_" & Now() & ".csv" ).linktocsvfile ) );

You also need to remove the JSON element from the Flow and simply create the file with the valid CSV now sent from Power Apps.

This structure also eliminates a number of "one use" Collections and Variables "hanging around" in your app.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like♥.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Many thanks for your help.

I tell you, If I sent the CSV created with your formula, and removing the json in the Create CSV Table, I get this error:

So, I added a step before , a Compose with:

split(triggerBody()['text'], ',')

And now, I get this error message:

The result of the Compose is this:

[
"Destination",
"Code",
"Address",
"City",
"State",
"ZIP",
"Country",
"ActiveLanzarote",
"ACE",
"C/Reina Sofia 17",
" Local 4",
"Puerto del Carmen",
"Lanzarote",
"35510",
"SPAIN",
"YesADB - Kusadasi",
"ADB",
"Mahallesi Kirazlı Yolu Caddesi A Blok No:3AA",
"Aydin",
"Aydin",
"09400",
"TURKEY",
"YesAGA - Agadir",
"AGA",
"Rue Mohamed Iqbal Amsernat",
"Agadir",
"Agadir",
"8000",
"MOROCCO",
"YesAGP - Malága",
"AGP",
"Avda. Antonio Machado",
" 28",
" Edificio Maryola 1",
" Planta 1A",
" 29630",
" Benalmadena",
"Malága",
"Andalucía",
"29630",
"SPAIN",
"YesALC - Alicante"
]

I do not know, but if you take a look, the last column Active is not separated from the first column of the record.

"YesAGA - Agadir",

"YesAGP - Malága",

I must to be:

"Yes",

AGA - Agadir",

"Yes",

"AGP - Malága",

If I added a comma after the Active column:

With(

{

_Export:

"Destination,Code,Address,City,State,ZIP,Country,Active," & Char(10) &

Concat(

_Data,

Name & "," & Code & "," & Address & "," & City & "," & State & "," & ZipCode & "," & Country.Name & "," & Active & ","

)

},

I get the Active column separately:

[

  "Destination",

  "Code",

  "Address",

  "City",

  "State",

  "ZIP",

  "Country",

  "Active",

  "Lanzarote",

  "ACE",

  "C/Reina Sofia 17",

  " Local 4",

  "Puerto del Carmen",

  "Lanzarote",

  "35510",

  "SPAIN",

  "Yes",

  "ADB - Kusadasi",

But I get the same error on creating the CSV table:

The property 'columns' must be specified unless the 'from' property value is an array of objects.

Thanks for all your help!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @EmilioRoqueta69,

You also need to remove Create CSV Table - the output from Power Apps is already one of these. Simply create the CSV file in OneDrive directly with the output received from Power Apps.

Also note the small addition to my original post - I omitted the Line Return Char(10) from the end of the Concat function

With(

{

_Export:

"Destination,Code,Address,City,State,ZIP,Country,Active" & Char(10) &

Concat(

_Data,

Name & "," & Code & "," & Address & "," & City & "," & State & "," & ZipCode & "," &
Country.Name & "," & Active,

Char(10)

)

},

You also had extra commas at the end of both lines (header and rows). I can assure you this works - I use it on a number of prod apps.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like♥.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much @WarrenBez !

Was this reply helpful? Yes No