Create Repeating Section In PowerApps Edit Form - Step By Step - Part Two

Dhruvin Shah

7y31.2k5100Article

PowerApps Power PlatformCreate Repeating Section in PowerApps Edit FormRepeating SectionRepeating Section in PowerApps

5 Comments

Join the conversation! Your thoughts help the community grow.

SPS Dev4y ago
Same Question as the Guest User, Needing to know on the edit form if the columns need to be in SharePoint list.
Guest User4y ago
I'm new to all of this trying to understand the SharePoint list side, is the data that is saved from the repeating table is it stored in its own column? can this be done on the edit form? As I will have a beginning entry but the entry area can be edited 18 times before the item is closed out. how is this reflected in the SharePoint list .. do I setup 18 additional columns to hold the data?
Joe Volk4y ago
Hi - what does RepeatedSection reference in this line of code? I am not having luck figuring that piece out. UpdateContext({EditStringVal: SelectedItem.RepeatedSection});
Daniel5y ago
Hi, I see that you are doing this as an app, is it possible to get this to work in the customize form option inside SharePoint? This is what I am after but I don't want a standalone app.
Kamalesh Figova5y ago
Delete row is not working in edit form, when new row is added, deleting all the existing rows, only first added row become empty even there is a data.

Overview

In this article, we will create the Repeating Section with PowerApps forms in Edit Form.

I divided the creation of Repeating section into two parts. If you didn’t visit the first part of this article, please visit my first article.

So, now let’s get started!

In Part 1 of the article, we have created the concatenated string to store the value of the repeating section. Here, we need to retrieve those values in the Edit mode of the form.

The basic concept we are going to use here is,

We will create the Edit Form.
We will navigate to Edit Form using PowerApps Gallery Grid.
On Select of the Gallery, we will get the context of the selected item.
Once we get the selected item, we will store concatenated value into one variable.
On Screen ‘s Visible event we will parse the string and show the values in the Repeating Section.

Download Code

I added the code to download for your practice on GITHUB.

Let’s get started!

Step 1

Below is the Home Page of the app.

Write the below code on the “OnSelect” event of the gallery.

Navigate(EditPage,ScreenTransition.None,{SelectedItem:Gallery1.Selected})

Create Repeating Section In PowerApps Edit Form

Step 2

Let’s create an Edit Page.
Create a New screen and add Edit Form. Hide the repeating section.
Add the following code in below events of the form.

Data Source

Select WO.

Item

Add “SelectedItem” which we have passed as a variable in step 1.2

Add the following code snippet in the OnVisible event of the edit form.

UpdateContext({EditStringVal: SelectedItem.RepeatedSection});
Clear(EditCols);
Set(
Editstr,
SelectedItem.RepeatedSection
);
Set(
Editstr,
Left(
Editstr,
Len(Editstr) - 1
)
);
ForAll(
Split(
Editstr,
"|"
),
Collect(
EditCols,
{
CItemSerialNumber: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
1
).Result
).Result
),
Clevel: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
2
).Result
).Result
),
Ctc: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
3
).Result
).Result
),
Cdescription: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
4
).Result
).Result
)
}
)
)

Now let’s add the Gallery control with labels, buttons, and dropdowns.

In Items > Add “EditCols” collection which we have created in the above section.

Now, let’s add the code snippet for the following sections.

New button Code

Collect(
EditCols,
{
CItemSerialNumber: Text(Last(EditCols).CItemSerialNumber + 1),
Clevel: "",
Ctc: "",
Cdescription: ""
}
)

Close Button Code

RemoveIf(EditCols,CItemSerialNumber = ThisItem.CItemSerialNumber)

Save button Code

UpdateContext(
{
EditStringVal: Concat(
RepeattingTable_3.AllItems,
Concatenate(
'sr.no_edit'.Text,
";",
drpedit.SelectedText.Value,
";",
technicalcontent_edit.Text,
";",
description_edit.Text,
";",
"|"
)
)
}
);
SubmitForm(Form3);

Now, let’s add the following variable as a default value for the Repeating section data card which we hide in the second step of this section.

Now, let’s test the functionality!

Testing

Navigate from the Grid.
Add a New Row.
Click on Save button.
The row has been saved.

Conclusion

This is how we can retrieve values of the repeating section in the PowerApps Edit Form. I hope you love this article. Stay connected with me for more amazing articles!

Happy PowerApping!!