How to Create a Repeating Table in PowerApps? [With Calculate Fields]

Recently, while working on a project for a client, we received a requirement to save repeating table data to a SharePoint list. This can be achieved using Power Apps. Although it’s a bit tricky, it is definitely possible. So, we attempted to create a repeating table in Power Apps.

Repeating tables in PowerApps 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.

How to Create Repeating Table in Power Apps

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

Build Power Apps with Headers and Collection

In PowerApps, 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 PowerApps 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

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:

txtSerialNumber: Default = ThisItem.CSerialNumber

txtProductName: Default = ThisItem.CProductName

txtProductQuantity:Default = ThisItem.CProductQuantity

txtProductPrice:Default = ThisItem.CProductPrice

product*price:Default = Value(txtProductQuantity.Text) * Value(txtProductPrice.Text)

VendorPhoneNumber:Default= ThisItem.CVendorPhoneNumber

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

Remove Specific Row from Repeating Table

Suppose you want to remove any specific unwanted rows, then the best option is to add a Cancel icon (inside the gallery) and write the code below on its OnSelect property:

OnSelect= RemoveIf(PurchaseCollection, CSerialNumber=ThisItem.CSerialNumber)

Save, Publish, and Test the App

Finally, save, publish, and close the app. Play the app and click on the + icon to add new lines. Also, enter values into the fields.

Also, it will calculate the price and quantity value correctly under the Quantity*Price field.

If you want to remove any particular row, click the Cancel button.

It will remove the specific row.

This way, we can create repeating rows in Power Apps.

How to Overcome with Default Calculated Value in PowerApps Repeating Table

However, you will realize that whenever you add a new line (after filling the first row), every time, it takes the first calculated value (Quantity*Price) in every row instead of a blank one. Apart from this, all the fields appear with blank values.

Also, resolving the problem in the PowerApps repeating table is challenging. I referred to many articles and didn’t find a solution, so I tried my own, and somehow, I achieved it.

To overcome it, go to the created collection on the Add(+) icon’s OnSelect property and replace the Blank() function in each field instead of an inverted comma (” “).

Collect(PurchaseCollection,{CSerialNumber:Text(Last(PurchaseCollection).CSerialNumber+1),CProductName:””,CProductQuantity:Blank(),CProductPrice:Blank(),CMulQuantityAndPrice:Blank(),CVendorPhoneNumber:Blank()})

Also, ensure that, except for the Product Name field, all the remaining text input controls’ Format property is Number.

Save, Publish, and Play the app. Now, whenever you add a new row, the calculated field value will appear with a Blank or zero value, as shown below.

Save Power Apps Repeating Rows in SharePoint List.

We will store all these repeating row values in a SharePoint list.

Set up a SharePoint List

Below is the SharePoint list [Purchase Order Details]. Create all six columns based on the Repeating table:

Column	Data Type
Serial Number	Number
Product Name	Title – Single line of text
Product Quantity	Number
Product Price	Number
Quantity*Price	Number
Vendor Phone Number	Number

Save Repeating Table Data in SharePoint List

Insert a Save or Submit icon outside of the gallery (mainly on the header) and set its OnSelect property to the code below:

ForAll(Gallery1.AllItems,Patch(‘Purchase Order Details’,Defaults(‘Purchase Order Details’),{‘Serial Number’:Value(txtSerialNumber.Text),’Product Name’:txtProductName.Text,’Product Price’:Value(txtProductPrice.Text),’Product Quantity’:Value(txtProductQuantity.Text),’Quantity*Price’:Value(‘product*Price’.Text),’Vendor Phone Number’:Value(VendorPhoneNumber.Text)}));Notify(“Your Order Has Been Submitted Successfully”,NotificationType.Success);

• Gallery1 = Gallery control name
• ‘Serial Number‘, Product Name, ‘Product Price‘, etc. = SharePoint Columns
• txtSerialNumber, txtProductName, txtProductPrice, etc. = Text input controls

As all the fields are numbers (except Product Name), we need to convert this text field to a number using the Power Apps Value() function.

Save, Publish, and Preview the app. Enter the values in the table and save the app. You will see a success notification in the top left corner.

Also, the items have been submitted in the SharePoint list as below.

We can create a PowerApps repeating section and save the records into a SharePoint list in this way.