{"id":1688,"date":"2022-12-07T10:28:30","date_gmt":"2022-12-07T10:28:30","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1688"},"modified":"2024-04-26T12:04:13","modified_gmt":"2024-04-26T12:04:13","slug":"repeating-control-in-powerapps","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/repeating-control-in-powerapps\/","title":{"rendered":"Repeating Control in PowerApps"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/repeating-control-in-powerapps\/#Create_SharePoint_List\" title=\"Create SharePoint List\">Create SharePoint List<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/repeating-control-in-powerapps\/#Create_PowerApp\" title=\"Create PowerApp\">Create PowerApp<\/a><\/li><\/ul><\/nav><\/div>\n<p>Repeating controls functionality in PowerApps can be achieved using Gallery Control of PowerApps.<\/p>\n<p>Repeating control functionality can be useful in many scenarios. For instance, you can add multiple products in a data source, and you can add multiple clients\u2019 details in the Data Source.<\/p>\n<p>In this article using the repeating control feature we will save data for multiple employees in a SharePoint List.<\/p>\n<p>In this example we will only use the text input control. But we can use any control inside the gallery for repeating control functionality.<\/p>\n<p>Now let\u2019s start building the solution for Repeating Control in PowerApps.<\/p>\n<div style=\"background-color: white; box-shadow: 0 0 10px whitesmoke; padding: 20px; width: 800px;\">\n<h4 style=\"color: black;\">Additional Read<\/h4>\n<p><a style=\"color: black; text-decoration: none;\" href=\"#\">How to Update Properties of Multiple Controls Inside PowerApps Form Control<\/a><\/p>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Create_SharePoint_List\"><\/span>Create SharePoint List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<table style=\"border-collapse: collapse; width: 100%; margin-top: 20px;\">\n<thead>\n<tr style=\"background-color: #f2f2f2;\">\n<th style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\"><strong>Column Name<\/strong><\/th>\n<th style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\"><strong>Column Field<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Employee ID<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Number<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Employee Name<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Single line of text<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Employee Designation<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Single line of text<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">City<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: center; padding: 8px;\">Single line of text<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1694 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture1.webp\" alt=\"img-01\" width=\"756\" height=\"343\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture1.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture1-300x136.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Create_PowerApp\"><\/span>Create PowerApp<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Step 1:\u00a0<\/strong>Create new canvas app.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1695 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture2.webp\" alt=\"img-02\" width=\"756\" height=\"470\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture2.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture2-300x187.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p><strong>Step 2:\u00a0<\/strong>Add Label controls for the heading purposes in the screen that looks like as below and add \u201c+\u201d icon in the first column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1696 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3.webp\" alt=\"img-03\" width=\"756\" height=\"344\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3-300x137.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p><strong>Step 3:\u00a0<\/strong>After adding \u201c+\u201d icon set its \u201c<em>OnSelect<\/em>\u201d property as below:<\/p>\n<pre style=\"background-color: #f5f2f0;\" lang=\"php\"> \r\nCollect(\r\n    DetailCollection,\r\n    {\r\n        Emp_ID: Text(Last(DetailCollection).Emp_ID + 1),\r\n        Emp_Name: \"\",\r\n        Emp_Des: \"\",\r\n        Emp_City: \"\"\r\n    }\r\n)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1697 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture4.webp\" alt=\"img-04\" width=\"756\" height=\"343\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture4.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture4-300x136.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p><strong>Step 4:\u00a0<\/strong>Now add the Blank Vertical gallery control and add text input controls for each field (which are created in \u201cEmployee Detail\u201d SharePoint list).<\/p>\n<p style=\"text-align: center;\">Select the gallery control and set its\u00a0<em>\u201cItems\u201d\u00a0<\/em>property to the collection name:<\/p>\n<pre style=\"background-color: #f5f2f0;\" lang=\"php\">\r\nDetailCollection\r\n\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1698 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture5.webp\" alt=\"img-05\" width=\"756\" height=\"343\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture5.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture5-300x136.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p><strong>Step 5:\u00a0<\/strong>Add Cancel icon in gallery to remove each row from gallery control.<\/p>\n<p style=\"text-align: center;\">For that, set property on\u00a0<em>\u201cOnSelect\u201d\u00a0<\/em>property to:<\/p>\n<pre style=\"background-color: #f5f2f0;\" lang=\"php\"> \r\nRemoveIf(\r\n    DetailCollection,\r\n    Emp_ID = ThisItem.Emp_ID\r\n)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1700 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture6.webp\" alt=\"img-06\" width=\"756\" height=\"344\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture6.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture6-300x137.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p><strong>Step 6:\u00a0<\/strong>Now we will save the rows in the SharePoint list.<\/p>\n<p style=\"text-align: center;\">\u00a0Insert button and set formula on\u00a0<em>\u201cOnSelect\u201d\u00a0<\/em>property.<\/p>\n<pre style=\"background-color: #f5f2f0;\" lang=\"php\">\r\nForAll(Gallery1.AllItems,Patch(\r\n    'Employee Detail',\r\n    Defaults('Employee Detail'),\r\n    {\r\n        'Employee ID': TextInput_ID.Text,\r\n        'Employee Name': TextInput_Name.Text,\r\n        'Employee Designation': TextInput_Des.Text,\r\n         City: TextInput_City.Text\r\n    }\r\n));\r\n<\/pre>\n<p>Here we will patch all rows into SharePoint list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1702 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture7.webp\" alt=\"img-07\" width=\"756\" height=\"343\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture7.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture7-300x136.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p><strong>Step 6:\u00a0<\/strong>Now test the solution for new entries.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1704 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture8.webp\" alt=\"img-08\" width=\"756\" height=\"427\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture8.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture8-300x169.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p>After click on \u201c<em>Save<\/em>\u201d button then go to the SharePoint list. You can see the new items have been created in list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1705 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture9.webp\" alt=\"img-09\" width=\"756\" height=\"203\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture9.webp 756w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture9-300x81.webp 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/p>\n<p>In conclusion, leveraging the repeating control functionality within PowerApps offers a powerful solution for handling repetitive data entry tasks efficiently.<\/p>\n<p>By utilizing Gallery Control, we\u2019ve demonstrated how to streamline the process of managing multiple entries, such as employee details, within a SharePoint list.<\/p>\n<p>Reality Tech Provides\u00a0<strong><a href=\"https:\/\/reality-tech.com\/solutions\/power-platform\/\" target=\"_blank\" rel=\"noopener\" aria-label=\"Microsoft PowerApps Solutions - open in a new tab\" data-uw-rm-ext-link=\"\">Microsoft PowerApps Solutions<\/a><\/strong>, through which organizations can enhance productivity and optimize data management workflows.<\/p>\n<p>Whether it is managing products, client details, or employee information, PowerApps provides a versatile platform for building robust applications tailored to specific business needs.<\/p>\n<p>Explore the myriad possibilities offered by PowerApps to revolutionize your data management strategies and propel your organization toward greater efficiency and success.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Repeating controls functionality in PowerApps can be achieved using Gallery Control of PowerApps. Repeating control functionality can be useful in many scenarios. For instance, you can add multiple products in a data source, and you can add multiple clients\u2019 details in the Data Source. In this article using the repeating control feature we will save [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":1689,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1688","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-apps"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1688"}],"version-history":[{"count":1,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1688\/revisions"}],"predecessor-version":[{"id":1708,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1688\/revisions\/1708"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1689"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}