Power Apps - Building Power Apps

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

(0) Share

Report

Posted on by EmilioRoqueta69

525

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:

Using Apps Using Formulas

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

WarrenBelz 149,319 Most Valuable Professional on at

Like (0)

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

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 ) }, 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 Buy me a coffee

Was this reply helpful? Yes No
EmilioRoqueta69 525 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No