A collection in Power Apps is a temporary, in-memory table used to store multiple records and fields inside an app. It works like a small local database that exists only while the app is running.
Collections are useful when you need to:
- Store data temporarily
- Manipulate records before saving
- Work with offline data
- Improve performance by reducing repeated data source calls
They are created using functions such as:
Collect() and ClearCollect()
Example
ClearCollect(
Products,
{ Name: "Laptop", Price: 500 },
{ Name: "Phone", Price: 300 }
)
This clears any existing data in the Products collection and then adds two records to it.
Difference Between Collect and ClearCollect in Power Apps
| Function | What It Does |
| Collect() | Adds new records to an existing collection without removing existing data |
| ClearCollect() | Deletes existing records first, then adds new records |
Key Characteristics
- Can store multiple rows and columns
- Accessible across the app
- Not automatically saved to a data source
- Exists only during the app session unless stored externally
Interview-Ready Definition
A collection is a temporary table stored in memory that holds multiple records and can be used anywhere in a Power Apps app.
