Export a Collection To A Datasource (SharePoint List, Excel, SQL, CDS)
Export a Collection To A Datasource (SharePoint List, Excel, SQL, CDS) Input collection: myOrders54 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2....
- Published
- Reading time
- 1 min read
Before you start
Is this guide for you?
- Best entry point
- SharePoint
- Time investment
- 1 min read
Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/export-a-collection-to-a-datasource-sharepoint-list-excel-sql-cds/. Author: Matthew Devaney.
Export a Collection To A Datasource (SharePoint List, Excel, SQL, CDS) Input collection: myOrders54 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: mySolution54 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(myOrders54, { 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 datasource code
Collect(your_datasource_name, myOrders54); Code language: JavaScript ( javascript )
Tagged
Collections · SharePoint
Have a Microsoft 365 topic idea?
Share article suggestions, community session ideas, corrections, or real-world scenarios for future nxtM365 learning notes.
Keep learning Microsoft 365
Explore more practical guides for SharePoint, Power Platform, Copilot Studio, migration, automation, governance, and security.
Continue learning
Related tutorials
Related questions
Related comparisons
Next action