Repeating table creates additional blank row on every edit

[cyberco01]

Hi All,

I have a repeating table in my Powerapps form linked to SharePoint.

Every time the form is edited a new blank row gets added in repeated in the repeating table.

Please help.

[WarrenBelz]

Hi @cyberco01 ,

It might be good to share some code here - what is your OnSave code in SharePointIntegration?

[cyberco01]

OnSave code in SharePointIntegration:

Set(
AllPurchasesString,
Concat(
Gallery1.AllItems,
Concatenate(
txtSrNo.Text,
"; ", ComboBox3.Selected.PERSONNELNUMBER,
"; ",
txtEmpName.Text,
"; ",
txtPosition.Text,
";",
txtRate.Text,
";",
txtHours.Text,
";",
txtTotal.Text,
" | "
)
)
);
Patch(
BonusRequests, If(SharePointForm1.Mode = FormMode.New, Defaults(BonusRequests),{ID:SharePointIntegration.SelectedListItemID}),
//Defaults(BonusRequests),
{
Title: DataCardValue1.Text,
ProjNo: ComboBox1.Selected.PROJECTID,
MonthName:DataCardValue3.Selected,
PMApprover:DataCardValue8.Selected,
ClevelApprover:DataCardValue2.Selected,
OMApprover: DataCardValue11.Selected,
PMApproval:DataCardValue7.Selected,
CLevelApproval: DataCardValue4.Selected,
OMApproval: DataCardValue12.Selected,
PMReason: DataCardValue9.Text,
CLevelReason: DataCardValue10.Text,
OMReason: DataCardValue13.Text,
RepeatingSection: AllPurchasesString
}
);
Notify(
"Record Submitted Succesfully!",
NotificationType.Success
);
Refresh(BonusRequests);

[WarrenBelz]

Hi @cyberco01 ,

The issue probably lies here

Patch(
   BonusRequests, 
   If(
      SharePointForm1.Mode = FormMode.New, 
      Defaults(BonusRequests),
      {ID:SharePointIntegration.SelectedListItemID}),

as the Defaults() seem to be triggering. To test, take out the conditional code

Patch(
   BonusRequests,
   {ID:SharePointIntegration.SelectedListItemID}),
   { . . . .

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[cyberco01]

Hi @WarrenBelz,

I tried as suggested above.

After doing that, I am unable to see the new list item created even after multiple manual refreshes.

Please help.

[WarrenBelz]

Hi @cyberco01 ,

That was not the point of the exercise - it was a test to see if the edit function worked and did not create new records (which I assume your test proved) - please confirm this before we go further.

[cyberco01]

It did not create a new line but it gave rise to another issue.

Like on the edit mode, my repeating table values are not seen after this.

[WarrenBelz]

@cyberco01 ,

Did it edit the current record? I am trying to eliminate the rest of your code - it appears that the Defaults() code is triggering when it should not and this will prove it. Conditional formulas on the built-in Sharepoint integration functions (OnSave, OnEdit etc) can be unreliable at times as there is nothing wrong with the logic of your code.

[cyberco01]

@WarrenBelz, I put trim on the OnView and OnEdit codes, and now, only one blank row appears. Earlier, for every edit, a new blank row used to appear. Now the repetition of blank rows has stopped for every edit. However, one blank row still appears. I needed to avoid the occurrence of that one blank row too.

Please help.

[WarrenBelz]

@cyberco01 ,

Does this only appear once or after every edit - also where did you use Trim?