In this tutorial, we will show how to create a repeating table.
Repeating table means it is just like a duplicate for the same table.
Process:
- First create a SharePoint list and add columns based on your requirements
So, i have added below columns
i have taken colors column as the lookup. so, i have created another list for that and connected it.
Now, Create a New Canvas App
Add both SharePoint lists to the Canvas App Data and Create a collection also.
Next,
Add two new screens and create a navigation button in the first screen two second screen.
Screen2;
- Take a gallery and add the dropdown for lookup data and take text editor for remaining columns.
Next,
Select Gallery Control and set its items property to the collection name.
Items = colorcollection
where,
colorcollection = collection name
Next,
select columns add set its items to the SharePoint list columns.
where,
Dropdown = Choices[@colorpicks].colors)
Texteditor1= Thisitem.curve
Texteditor2= Thisitem.Lamp
Now, select the screen and apply below formula on its OnVisible property as;
ClearCollect(colorcollection,{Color:{ID:””,Value:””},Lamp: “”, Curve: “”});
Next, select (+) and add below formula on its OnSelect
Collect(colorcollection,{Color:{Id: “”,Value:””},Lamp: “”, Curve: “”});
Next, select the button and add the below formula on its OnSelect.
ForAll(Gallery2.AllItems,Patch(ColorPicks, Defaults(ColorPicks),{Title:”0″, Colors:ComboBox1.Selected, Curve:TextInput8.Text, Lamp:TextInput9.Text}))
Save and Publish the app. Reopen the app again. Click on the + icon to add a new row. Enter all the field values and click on the Save button as shown below.
Next, go to the specific SharePoint list and refresh it. You can see the new items have been created with the separation of “|”.
