How to Add Column in Power Apps Collection?

Are you new to Power Apps and waiting to learn how to add column in Power Apps Collection? No worries!

This Power Apps tutorial will teach all the information about Power Apps AddColumns() and how to add a column in the Power Apps collection.

Here, we will discuss how to add a column to an existing Power Apps collection or add a column from another Power Apps collection.

Power Apps AddColumns()

Power Apps AddColumns() function helps to add a column to a table or collections and a formula defines the values in that column.

Syntax:

AddColumns( Table, ColumnName1, Formula1 [, ColumnName2, Formula2, ... ] )

Where,

  • Table = Specify the Table to operate on.
  • ColumnName(s) = It is Required. Provide the Name(s) of the column(s) to add. You must specify a string for this argument.
  • Formula(s) = Specify the Formula(s) to evaluate for each record. The result is added as the value of the corresponding new column.

How to Add Column in Power Apps Collection

Now, we will see how to add a column in the Power Apps collection with a simple example.

Example:

I have a Power Apps collection named “colProductDetails” containing the below columns.

How to Add Column in Power Apps Collection

I would like to add a column [TotalAmount] in the collection using the AddColumns() function, as in the screenshot below.

How to Add Column in Power Apps Collection

To work around this example, follow the below steps. Such as:

1. Create a Blank canvas app -> Select Power Apps Screen [ProductDetailsScreen] and set Its OnVisible property to the code below.

OnVisible = ClearCollect(
    colProductDetails,
    {
        ProductID: "SP001",
        ProductName: "Torch",
        Color: "Red",
        Quantity: 2,
        Price: 500
    },
    {
        ProductID: "SP002",
        ProductName: "Rice cooker",
        Color: "White",
        Quantity: 5,
        Price: 2000
    },
    {
        ProductID: "SP003",
        ProductName: "Mobile Phone",
        Color: "Black",
        Quantity: 4,
        Price: 3000
    },
    {
        ProductID: "SP004",
        ProductName: "Digital camera",
        Color: "Brown",
        Quantity: 2,
        Price: 1000
    },
    {
        ProductID: "SP005",
        ProductName: "Mixer",
        Color: "Grey",
        Quantity: 3,
        Price: 1500
    }
);

Where,

  • colProductDetails = Power Apps Collection Name
  • ProductID, ProductName, etc… = Collection Headers/Columns
  • “SP001”, “Torch”, “Red”, etc… = Collection Records/Rows
Add a Column in Power Apps Collection

2. I want to add another column in the collection using this source collection. To do so, use this collection in the Screen’s OnVisible property, as shown below.

OnVisible = ClearCollect(
    colAddColumn,
    AddColumns(
        colProductDetails,
        "TotalAmount",
        ThisRecord.Quantity * ThisRecord.Price
    )
)

Where,

  • colAddColumn = New collection name
  • AddColumns() = This function helps to add a column to a table or collections
  • colProductDetails = Power Apps source collection
  • “TotalAmount” = New column name
  • ThisRecord.Quantity * ThisRecord.Price = We can multiply these two columns to get new column records
How to Add a Column in Power Apps Collection

3. Save, Publish, and Reload the app to get this collection. Then, insert a Data table to display the Power Apps collection and set its Items property as:

Items = colAddColumn
Add Column in the Power Apps Collection

4. Next, to display the collection fields on a data table, click the Edit fields option, choose your respective fields, and click the Add button below.

See also  How to Display SharePoint List Items in PowerApps Gallery?
Add a Column in the Power Apps Collection

5. Once, you added collection fields, the data table will display all the records with respective columns.

How to Add Column in the Power Apps Collection

6. If you want to find the final collection, go to the Variables section, click the Collections drop-down, and select a respective collection [colAddcolumn] like below.

How to a Add Column in the Power Apps Collection

This is how to add a column in the Power Apps collection.

Add Column to Existing Power Apps Collection

Next, we will discuss how to add a column to an existing Power Apps collection or add a column from another Power Apps collection with a simple scenario:

Scenario:

I have two Power Apps Collections, i.e., colProductDetails and colProducts. The first collection [colProductDetails] has the below headers/columns:

  • ProductID
  • ProductName
  • ProductColor

The second collection [colProducts] has the below columns:

  • ProductID
  • ProductPrice

Refer to the below screenshot:

Add column to existing Power Apps collection

Now, I want to look up this Price column to the 1st collection, i.e. [colProductDetails], and the result will be stored in a new collection, i.e. [colFinal]. Refer to the table below:

Add a column to existing Power Apps collection

To achieve the above example, follow the below-mentioned steps. Such as:

1. Open the Power Apps app -> select the App (from the left navigation) and choose the OnStart property to create collections like the below:

OnStart = ClearCollect(colProductDetails,{ProductID:"SP001",ProductName:"Torch",Color:"Red"},{ProductID:"SP002",ProductName:"Rice cooker",Color:"White"},{ProductID:"SP003",ProductName:"Mobile Phone",Color:"Black"},{ProductID:"SP004",ProductName:"Digital camera",Color:"Brown"},{ProductID:"SP005",ProductName:"Mixer",Color:"Grey"});
ClearCollect(colProducts,{ProductID:"SP001",Price:200},{ProductID:"SP002",Price:400},{ProductID:"SP003",Price:1000},{ProductID:"SP004",Price:800},{ProductID:"SP005",Price:700})

Where,

  • colProductDetails= Power Apps Collection Name
  • colProducts = Second Collection Name
How to add column to existing Power Apps collection

2. Next, click on the More commands () option and click on the Run OnStart option to get our collection.

3. Then, go to the Variables section (x) -> Select Collections drop-down to find collections, as shown below.

How to add a column to existing Power Apps collection

4. To see your created collections, click the View Table option and select the respective collection like below.

How to add column to the existing Power Apps collection

5. Here, we must add a column in the respective collection (colProductDetails) based on the lookup column in another collection (colProducts).

See also  How to Use Power Apps AddColumns Function? [With Examples]

6. To do so, insert another screen -> add a Button control -> Set its OnSelect property to the code below:

OnSelect = ClearCollect(
    colFinal,
    AddColumns(
        colProductDetails,
        "Price",
        LookUp(
            colProducts,
            ProductID = colProductDetails[@ProductID],
            Price
        )
    )
)

Where,

  • colFinal = You can set a collection to add a lookup column
  • colProductDetails = It is 1st name of the Power Apps collection
  • “Price” = This is the lookup column I want to add to the 1st collection
  • LookUp = You can use this function to find a record matching one or more criteria
  • colProducts = It is 2nd name of the Power Apps collection
  • ProductID = This is a lookup column that we used in both collections
Add column from another Power Apps collection

7. Then, insert a Data table and set its Items property as:

Items = colFinal

8. Also, you can add some collection fields from the Edit fields option [from the Properties pane].

Add a column from another Power Apps collection

9. Now, click on the button control to display the records and especially, and we can get the price column from another collection, as in the screenshot below.

How to add column from another Power Apps collection

This is all about how to add a column to an existing Power Apps collection or add a column from another Power Apps collection.

Conclusion

I hope this Power Apps tutorial taught in detail information on how to add a column in the Power Apps collection.

Also, we discussed how to add a column to an existing Power Apps collection or add a column from another Power Apps collection.

Additionally, you may like some more Power Apps tutorials:

>