{"id":1631,"date":"2021-11-27T14:18:31","date_gmt":"2021-11-27T14:18:31","guid":{"rendered":"https:\/\/365stack.in\/?p=1631"},"modified":"2023-06-25T09:43:48","modified_gmt":"2023-06-25T09:43:48","slug":"add-repeating-section-in-powerapps","status":"publish","type":"post","link":"https:\/\/365stack.in\/index.php\/2021\/11\/27\/add-repeating-section-in-powerapps\/","title":{"rendered":"Add repeating section in PowerApps"},"content":{"rendered":"\n

As we already discussed, Gallery is a multipurpose control in the canvas app. One of the use-cases of gallery is the repeating section, this scenario will be applicable between Parent-Child relationships in Lists or tables and if the form is converted from Nintex, InfoPath (OOTB repeating section control available there) to PowerApps then this post will be useful.<\/p>\n\n\n

\n
\"\"
Canvas App Repeating Section Implementation<\/figcaption><\/figure>\n<\/div>\n\n\n

With the help of other controls and formulas, repeating section can be implemented in Power Apps.<\/p>\n\n\n\n

Gallery needs collection or table (direct query from the table or list) as datasource. In this example, we used Dataverse as a table<\/p>\n\n\n\n

    \n
  1. Create a collection on Screen “OnVisible<\/strong>” to feed it to the gallery. We cannot use variables inside “ForAll” so “colTemp” is used as increment variable. It is used to display the S.No.<\/li>\n<\/ol>\n\n\n\n
    \/\/Increment Variable\nClearCollect(colTemp,{counter:0});\n\n\/\/Gallery Data\nClear(colGalleryData);\nCollect(\n    colGalleryData,\n    ForAll(Sort(\n        Filter(\n            365Stack_ReviewData,\n            ReviewID = currentItem.ID\n        ),'Created On',Ascending),\n        {\n            stage: Stage,\n            action: Action,\n            user: User,\n            date: ReviewedDate,\n            no:Patch(colTemp,First(colTemp),{counter:Sum(First(colTemp).counter,1)}).counter,\n            ID:ID\n\n        };\n\n    )\n\n);<\/code><\/pre>\n\n\n\n
    2. Add gallery control in the screen and map the created collection in the “Items” property. Click the edit icon and add controls inside the gallery. Each control should be mapped “ThisItem” with collection properties. For Eg: the label control is mapped with ID property from the collection. To set gallery height dynamically use the following formula.<\/p>\n\n\n\n
    \nItems<\/strong>: colGalleryData\n\/\/To adjust the gallery height dynamically\nHeight: Self.TemplateHeight * CountRows(Self.AllItems) + 60<\/code><\/pre>\n\n\n\n