Export a Collection To A JSON

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

Export a Collection To A JSON Input collection: myOrders36 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: mySolution36

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

ClearCollect(myOrders36, { 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 JSON code Set (mySolution36, JSON (myOrders36)); Code language: JavaScript ( javascript )