What are Collect, Clear, and ClearCollect Functions in Power Apps?

What are Collect, Clear, and ClearCollect Functions in Power Apps?

Collections are temporary data storage structures in Power Apps that allow developers to store, manipulate, and display data within an application. Power Apps provides three important functions for working with collections: Collect(), Clear(), and ClearCollect().

Understanding these functions is essential for building efficient Canvas Apps that handle data effectively and improve user experience.

What is a Collection?

A collection is an in-memory table used to temporarily store data during the app session.

• Store temporary records
• Improve performance
• Reduce data source calls
• Enable offline scenarios

Collect Function

The Collect() function adds records to an existing collection or creates a new collection if it does not exist.

Collect(
EmployeeCollection,
{
   Name:"Mahesh",
   Department:"IT"
}
)

This function appends new records to the collection.

Clear Function

The Clear() function removes all records from a collection while keeping the collection structure intact.

Clear(
EmployeeCollection
)

After execution, the collection becomes empty.

ClearCollect Function

ClearCollect() combines Clear() and Collect() into a single operation.

ClearCollect(
EmployeeCollection,
Employees
)

The function first clears existing records and then loads fresh data.

Business Scenario

Suppose you have an Employee Management App. When users click Refresh, the application should load the latest employee records without creating duplicate entries.

ClearCollect(
EmployeeCollection,
Employees
)

This ensures the collection always contains the latest data.

Comparison Table

Benefits

• Improves application performance
• Reduces data source calls
• Supports offline capabilities
• Enables temporary data storage
• Simplifies data manipulation

Key Takeaways

• Collect() adds records to collections.
• Clear() removes all records from collections.
• ClearCollect() refreshes collection data.
• Collections improve Power Apps performance.
• These functions are essential for Canvas App development.