Insert Multiple Rows Into A Collection
Insert Multiple Rows Into A Collection Input collection: myTestScores32a FullName Age TestScore David Jones 32 78 Anne Lisbon 45 92 Penlope Parra 26 56 Input...
- Published
- Reading time
- 1 min read
Before you start
Is this guide for you?
- Best entry point
- Power Apps
- Time investment
- 1 min read
Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/insert-a-new-row-into-a-collection/. Author: Matthew Devaney.
Insert Multiple Rows Into A Collection Input collection: myTestScores32a FullName Age TestScore David Jones 32 78 Anne Lisbon 45 92 Penlope Parra 26 56 Input collection: myTestScores32b FullName Age TestScore Harold Reimer 50 65 Jerry Farrel 18 73 Stacy Fenton 35 84 Output collection: mySolution3 2 FullName Age TestScore David Jones 32 78 Anne Lisbon 45 92 Penlope Parra 26 56 Harold Reimer 50 65 Jerry Farrel 18 73 Stacy Fenton 35 84 Solution code: //Create a collection
ClearCollect(myTestScores32a, { FullName : "David Jones" , Age : 32 , TestScore : 78 }, { FullName : "Anne Lisbon" , Age : 45 , TestScore : 92 }, { FullName : "Penelope Parra" , Age : 26 , TestScore : 56 } ); //Create multiple rows
ClearCollect( myTestScores32b, { FullName : "Harold Reimer" , Age : 50 , TestScore : 65 }, { FullName : "Jerry Farrel" , Age : 18 , TestScore : 73 }, { FullName : "Stacy Fenton" , Age : 35 , TestScore : 84 } );
//Insert multiple new rows into collection code
ClearCollect(mySolution32,myTestScores32a); Collect(mySolution32,myTestScores32b); Code language: JavaScript ( javascript )
Tagged
Collections · Power Apps
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