Get A Column From A Collection
Get A Column From A Collection Input collection: myCars45 SerialNo Year Make Model 6453 2016 Toyota Corolla 8946 2014 Honda Civic 3571 2019 Toyota Camry 1165...
- 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/get-a-column-from-a-collection/. Author: Matthew Devaney.
Get A Column From A Collection Input collection: myCars45 SerialNo Year Make Model 6453 2016 Toyota Corolla 8946 2014 Honda Civic 3571 2019 Toyota Camry 1165 2018 Honda Civic 8973 2018 Hyundai Elantra 4529 2020 Honda Accord Output collection: mySolution45 SerialNo 6453 8946 3571 1165 8973 4529 Solution code: //Create a collection
ClearCollect(myCars45, { SerialNo : "6453" , Year : 2016 , Make : "Toyota" , Model : "Corolla" }, { SerialNo : "8946" , Year : 2014 , Make : "Honda" , Model : "Civic" }, { SerialNo : "3571" , Year : 2019 , Make : "Toyota" , Model : "Camry" }, { SerialNo : "1165" , Year : 2018 , Make : "Honda" , Model : "Civic" }, { SerialNo : "8973" , Year : 2018 , Make : "Hyundai" , Model : "Elantra" }, { SerialNo : "4529" , Year : 2020 , Make : "Honda" , Model : "Accord" } ); //Get a column from a collection code
ClearCollect(mySolution45,myCars45.SerialNo); 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 nextM365 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