How to Create Repeating Table in Power Apps? [With Calculate Fields]

Recently, while working on a project for a client, I got a requirement to save repeating table data to a SharePoint list. We can achieve this with Power Apps. It’s a little bit tricky, but we can do it. So, I tried how to create a repeating table in Power Apps.

Repeating table in Power Apps create tables where each row can contain multiple controls (like text boxes, dropdowns, etc.), and users can dynamically add or remove rows.

This feature is helpful for scenarios where you must collect a variable amount of repeating data from users, such as entering line items on an invoice or filling out survey responses.

Refer to the image below for how Power Apps repeating rows look like:

Table of Contents:

How to Create Repeating Table in Power Apps

Let’s discuss how to create repeating sections in Power Apps step by step and see how to calculate field values within the repeating table.

Build Power Apps with Headers and Collection

In Power Apps, add some Text labels for heading purposes: [You can change all the Labels’ Text properties to their respective field names, such as Product Name, Product Quantity, Product Price, etc.]

Next, insert an Add icon(+)/button (place it in the top left corner) and apply the code below on its OnSelect property to create a Power Apps collection.

OnSelect = Collect(
    PurchaseCollection,
    {
        CSerialNumber: Text(Last(PurchaseCollection).CSerialNumber + 1),
        CProductName: "",
        CProductQuantity: "",
        CProductPrice: "",
        CMulQuantityAndPrice: "",
        CVendorPhoneNumber: ""
    }
)

PurchaseCollection = Collection name
CSerialNumber, CProductName, etc. = Collection headers

Add a Blank Vertical gallery and insert input controls

Insert a Blank vertical gallery control and set its Items property to the collection:

Items = PurchaseCollection

powerapps repeating table, Create Repeating Section In Power Apps

Edit the gallery -> add all six fields (Text input controls). Set five fields (except Product Name) Format property to Number. [As the user is going to enter only the number values. If the user puts any text or unique character, it won’t allow to enter].

Next, set all the Text input’s Default property to the codes below:

SerialNumber:Default = ThisItem.CSerialNumber
ProductName:Default = ThisItem.CProductName
ProductQuantity:Default = ThisItem.CProductQuantity
ProductPrice:Default = ThisItem.CProductPrice
ProductQuantity*ProductPrice:Default = Value(txtProdQuantity.Text) * Value(txtProdPrice.Text)     
VendorPhoneNumber:Default = ThisItem.CVendorPhoneNumber

ProductQuantity*ProductPrice = It will multiply the Product Quantity and Price value

Refer to the image below: