Collection variables are another powerful feature in Canvas apps that allow us to store and manipulate data within app. Collection variables are essentially tables of data that can be created and modified by app.
To create a collection variable in a Canvas app, we can follow these steps:
- Open app in Power Apps Studio.
- Click on the “View” tab at the top of the screen.
- Click on “Collections” in the ribbon to open the collections pane.
- Click on the “New collection” button to create a new collection.
- Give collection a name and define the columns and data types for your table.
- Click “Create” to create collection.
Once you have created a collection variable, we can use it to store and manipulate data within app. We can add new rows to the collection, modify existing rows, or delete rows as needed. We can also use formulas and functions to filter, sort, and transform the data within the collection.
Collection variables are often used to store data retrieved from external data sources such as SharePoint, SQL Server, or Dynamics 365. By storing the data in a collection variable, We can manipulate and display the data within app in a more flexible and user-friendly way.