Export a Collection To A CSV

Export a Collection To A CSV Input collection: myOrders37 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2.5 1002 Crayons 15 8.62 1003 Binders 10 13....

Published: Published Jun 1, 2024
Reading time: 1 min read

Before you start

Is this guide for you?

Best entry point: Power Apps
Time investment: 1 min read

Open Power Apps Code hub Compare options

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/export-a-collection-to-a-csv/. Author: Matthew Devaney.

Export a Collection To A CSV Input collection: myOrders37 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2.5 1002 Crayons 15 8.62 1003 Binders 10 13.34 1004 Pencils 21 1.5 1005 Erasers 30 0.89 Output to datasource: mySolution37

OrderID,Item,UnitsOrdered,CostPerUnit 1001,Notebook,25,2.5 1002,Crayons,15,8.62 1003,Binders,10,13.34 1004,Pencils,21,1.5 1005,Erasers,30,0.89 Solution code: //Create a collection

ClearCollect(myOrders37, { OrderID : 1001 , Item : "Notebook" , UnitsOrdered : 25 , CostPerUnit : 2.5 }, { OrderID : 1002 , Item : "Crayons" , UnitsOrdered : 15 , CostPerUnit : 8.62 }, { OrderID : 1003 , Item : "Binders" , UnitsOrdered : 10 , CostPerUnit : 13.34 }, { OrderID : 1004 , Item : "Pencils" , UnitsOrdered : 21 , CostPerUnit : 1.5 }, { OrderID : 1005 , Item : "Erasers" , UnitsOrdered : 30 , CostPerUnit : 0.89 } ); //Collection to CSV code

ClearCollect(myCSV,{ csvString : "OrderID,Item,UnitsOrdered,CostPerUnit" &Char( 10 )}); ForAll( myOrders37, Patch( myCSV, First(myCSV), { csvString : First(myCSV).csvString&OrderID& "," &Item& "," &UnitsOrdered& "," &CostPerUnit&Char( 10 )}) );

Set (mySolution37,First(myCSV).csvString) Code language: JavaScript ( javascript )