{"id":7335,"date":"2025-01-24T07:26:02","date_gmt":"2025-01-24T07:26:02","guid":{"rendered":"https:\/\/softreetechnology.com\/blog\/?p=7335"},"modified":"2025-01-24T07:26:03","modified_gmt":"2025-01-24T07:26:03","slug":"how-to-create-a-repeating-table-in-powerapps-with-calculate-fields","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/","title":{"rendered":"How to Create a Repeating Table in PowerApps? [With Calculate Fields]"},"content":{"rendered":"\n

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\u2019s a bit tricky, it is definitely possible. So, we attempted to create a repeating table in Power Apps.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

How to Create Repeating Table in Power Apps<\/strong><\/p>\n\n\n\n

Let\u2019s discuss how to create repeating sections in PowerApps step by step and see how to calculate field values within the repeating table.<\/p>\n\n\n\n

Build Power Apps with Headers and Collection<\/strong><\/p>\n\n\n\n

In PowerApps, add some Text labels for heading purposes: [You can change all the Labels\u2019 Text properties to their respective field names, such as Product Name, Product Quantity, Product Price, etc.]<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

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.<\/p>\n\n\n\n

OnSelect = Collect(PurchaseCollection,{ CSerialNumber:Text(Last(PurchaseCollection).CSerialNumber + 1),CProductName: “”,  CProductQuantity: “”, CProductPrice: “”, CMulQuantityAndPrice: “”,      CVendorPhoneNumber: “”})<\/p>\n\n\n\n

  • PurchaseCollection = Collection name<\/li>
  • CSerialNumber, CProductName, etc. = Collection headers<\/li><\/ul>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n

    Add a Blank Vertical gallery and insert input controls<\/strong><\/p>\n\n\n\n

    Insert a Blank vertical gallery control and set its Items property to the collection:<\/p>\n\n\n\n

    Items = PurchaseCollection<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    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\u2019t allow to enter].<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    Next, set all the Text input\u2019s Default property to the codes below:<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    txtSerialNumber: Default = ThisItem.CSerialNumber<\/p>\n\n\n\n

    txtProductName: Default = ThisItem.CProductName<\/p>\n\n\n\n

    txtProductQuantity:Default = ThisItem.CProductQuantity<\/p>\n\n\n\n

    txtProductPrice:Default = ThisItem.CProductPrice<\/p>\n\n\n\n

    product*price:Default = Value(txtProductQuantity.Text) * Value(txtProductPrice.Text)<\/p>\n\n\n\n

    VendorPhoneNumber:Default= ThisItem.CVendorPhoneNumber<\/p>\n\n\n\n

    ProductQuantity*ProductPrice<\/strong> = It will multiply the Product Quantity and Price value<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    Remove Specific Row from Repeating Table<\/p>\n\n\n\n

    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:<\/p>\n\n\n\n

    OnSelect= RemoveIf(PurchaseCollection, CSerialNumber=ThisItem.CSerialNumber)<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    Save, Publish, and Test the App<\/p>\n\n\n\n

    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.<\/p>\n\n\n\n

    Also, it will calculate the price and quantity value correctly under the Quantity*Price field.<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    If you want to remove any particular row, click the Cancel button.<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    It will remove the specific row.<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    This way, we can create repeating rows in Power Apps.<\/p>\n\n\n\n

    How to Overcome with Default Calculated Value in PowerApps Repeating Table<\/strong><\/p>\n\n\n\n

    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.<\/p>\n\n\n\n

    Also, resolving the problem in the PowerApps repeating table is challenging. I referred to many articles and didn\u2019t find a solution, so I tried my own, and somehow, I achieved it.<\/p>\n\n\n\n

    To overcome it, go to the created collection on the Add(+) icon\u2019s OnSelect property and replace the Blank() function in each field instead of an inverted comma (\u201d \u201c).<\/p>\n\n\n\n

    Collect(PurchaseCollection,{CSerialNumber:Text(Last(PurchaseCollection).CSerialNumber+1),CProductName:””,CProductQuantity:Blank(),CProductPrice:Blank(),CMulQuantityAndPrice:Blank(),CVendorPhoneNumber:Blank()})<\/p>\n\n\n\n

    \"\"\/<\/figure>\n\n\n\n

    Also, ensure that, except for the Product Name field, all the remaining text input controls\u2019 Format property is Number.<\/p>\n\n\n\n

    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.<\/p>\n\n\n\n

    Save Power Apps Repeating Rows in SharePoint List.<\/p>\n\n\n\n

    We will store all these repeating row values in a SharePoint list.<\/p>\n\n\n\n

    Set up a SharePoint List<\/strong><\/p>\n\n\n\n

    Below is the SharePoint list [Purchase Order Details]. Create all six columns based on the Repeating table:<\/p>\n\n\n\n

    Column<\/td>Data Type<\/td><\/tr>
    Serial Number<\/td>Number<\/td><\/tr>
    Product Name<\/td>Title \u2013 Single line of text<\/td><\/tr>
    Product Quantity<\/td>Number<\/td><\/tr>
    Product Price<\/td>Number<\/td><\/tr>
    Quantity*Price<\/td>Number<\/td><\/tr>
    Vendor Phone Number<\/td>Number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n

    Save Repeating Table Data in SharePoint List<\/strong><\/p>\n\n\n\n

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

    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);<\/p>\n\n\n\n

    • Gallery1<\/strong> = Gallery control name<\/li>
    • \u2018Serial Number\u2018<\/strong>, Product Name<\/strong>, \u2018Product Price\u2018<\/strong>, etc. = SharePoint Columns<\/li>
    • txtSerialNumber<\/strong>, txtProductName<\/strong>, txtProductPrice<\/strong>, etc. = Text input controls<\/li><\/ul>\n\n\n\n

      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.<\/p>\n\n\n\n

      \"\"\/<\/figure>\n\n\n\n

      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.<\/p>\n\n\n\n

      \"\"\/<\/figure>\n\n\n\n

      Also, the items have been submitted in the SharePoint list as below.<\/p>\n\n\n\n

      \"\"\/<\/figure>\n\n\n\n

      We can create a PowerApps repeating section and save the records into a SharePoint list in this way.<\/p>\n","protected":false},"excerpt":{"rendered":"

      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\u2019s 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 […]<\/p>\n","protected":false},"author":1,"featured_media":7316,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[306],"tags":[549,547,551,323,545,546,548,555,554,550,552,553],"class_list":["post-7335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerapps","tag-create-repeating-table-in-power-apps","tag-dynamic-data-entry-in-powerapps","tag-how-to-create-a-repeating-table-in-powerapps","tag-powerapps","tag-powerapps-collection-example","tag-powerapps-gallery-control","tag-powerapps-repeating-table","tag-powerapps-repeating-table-tutorial-step-by-step","tag-repeating-table-with-dynamic-rows-in-powerapps","tag-save-repeating-table-data-in-sharepoint","tag-saving-powerapps-repeating-table-data-to-sharepoint-list","tag-using-powerapps-to-calculate-fields-in-repeating-rows"],"yoast_head":"\nHow to Create a Repeating Table in PowerApps? [With Calculate Fields] - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Repeating Table in PowerApps? [With Calculate Fields] - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"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\u2019s 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 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-24T07:26:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-24T07:26:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Create-a-Repeating-Table-in-Power-Apps.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Repeating Table in PowerApps? [With Calculate Fields] - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Repeating Table in PowerApps? [With Calculate Fields] - Softree Technology","og_description":"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\u2019s 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 […]","og_url":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/","og_site_name":"Softree Technology","article_published_time":"2025-01-24T07:26:02+00:00","article_modified_time":"2025-01-24T07:26:03+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Create-a-Repeating-Table-in-Power-Apps.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"How to Create a Repeating Table in PowerApps? [With Calculate Fields]","datePublished":"2025-01-24T07:26:02+00:00","dateModified":"2025-01-24T07:26:03+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/"},"wordCount":912,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Create-a-Repeating-Table-in-Power-Apps.png","keywords":["Create Repeating Table in Power Apps","Dynamic Data Entry in PowerApps","How to Create a Repeating Table in PowerApps","PowerApps","PowerApps Collection Example","PowerApps Gallery Control","PowerApps Repeating Table","PowerApps Repeating Table Tutorial Step-by-Step","Repeating Table with Dynamic Rows in PowerApps","Save Repeating Table Data in SharePoint","Saving PowerApps Repeating Table Data to SharePoint List","Using PowerApps to Calculate Fields in Repeating Rows"],"articleSection":["PowerApps"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/","url":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/","name":"How to Create a Repeating Table in PowerApps? [With Calculate Fields] - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Create-a-Repeating-Table-in-Power-Apps.png","datePublished":"2025-01-24T07:26:02+00:00","dateModified":"2025-01-24T07:26:03+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#primaryimage","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Create-a-Repeating-Table-in-Power-Apps.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Create-a-Repeating-Table-in-Power-Apps.png","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/how-to-create-a-repeating-table-in-powerapps-with-calculate-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Create a Repeating Table in PowerApps? [With Calculate Fields]"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=7335"}],"version-history":[{"count":1,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7335\/revisions"}],"predecessor-version":[{"id":7336,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7335\/revisions\/7336"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media\/7316"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=7335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=7335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=7335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}