Power Apps

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...

Matthew Devaney
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 )

Share this

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.

Suggest a topic

Keep learning Microsoft 365

Explore more practical guides for SharePoint, Power Platform, Copilot Studio, migration, automation, governance, and security.

Continue learning

Next action

What to do next

Browse all tutorials →