Multiple rows created when trying to add or delete rows

(0) Share

Report

Posted on by cyberco01

480

Hi Team,

I have a Sharepoint List linked to Powerapps. I have a repeating table in it.

When I add a new list item along with the rows in it. 2 list items are created in the SharePoint List.

When I remove the rows, additional row is created with the deleted one.

Please help. I am truely in need of guidance. Please do respond.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cyberco01

Can you post your currant formula so we can amended

Was this reply helpful? Yes No
cyberco01 480 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ramole
OnSave:
-------
Set(
AllPurchasesString,
Concat(
Gallery1.AllItems,
Concatenate(
txtSrNo.Text,
"; ", ComboBox3.Selected.PERSONNELNUMBER,
//txtEmpNo.Text,
"; ", //ComboBox3.Selected.NAME,
txtEmpName.Text,
"; ",
txtPosition.Text,
" | "
)
)
);
Patch(
BonusRequests,
Defaults(BonusRequests),
{
//Title: Text(Today()),
//RepeatingSection: AllPurchasesString
Title: DataCardValue1.Text,
ProjNo: ComboBox1.Selected.PROJECTID,
MonthName:DataCardValue3.Selected,
RepeatingSection: AllPurchasesString
}
);
Notify(
"Record Submitted Succesfully!",
NotificationType.Success
);
Refresh(BonusRequests);
RequestHide()

OnEidt:
-------
Refresh(BonusRequests);
EditForm(SharePointForm1);
Set (RepSecCOllString, LookUp( BonusRequests, ID=SharePointIntegration.SelectedListItemID, RepeatingSection));Clear (InvoiceCollection);
Set (EditRepSecStr,LookUp( BonusRequests, ID=SharePointIntegration.SelectedListItemID , RepeatingSection));Set(EditRepSecStr,Left(EditRepSecStr,Len(EditRepSecStr) - 1));
ForAll (
Split (
EditRepSecStr,
"|"
),
Collect (
InvoiceCollection,
{
lblSrNo: Text (Last (FirstN(Split(Result,";").Result,1).Result).Result),
txtEmpNo: Text (Last (FirstN(Split(Result,";").Result,2).Result).Result),
txtEmpName: Text (Last (FirstN(Split(Result,";").Result,3).Result).Result),
txtPosition: Text (Last (FirstN(Split(Result,";").Result,4).Result).Result)
}
)
)

OnView:
-------
Refresh(BonusRequests);
ViewForm(SharePointForm1);
Set (RepSecCOllString, LookUp( BonusRequests, ID=SharePointIntegration.SelectedListItemID, RepeatingSection));Clear (InvoiceCollection);
Set (EditRepSecStr,LookUp( BonusRequests, ID=SharePointIntegration.SelectedListItemID , RepeatingSection));Set(EditRepSecStr,Left(EditRepSecStr,Len(EditRepSecStr) - 1));
ForAll (
Split (
EditRepSecStr,
"|"
),
Collect (
InvoiceCollection,
{
lblSrNo: Text (Last (FirstN(Split(Result,";").Result,1).Result).Result),
txtEmpNo: Text (Last (FirstN(Split(Result,";").Result,2).Result).Result),
txtEmpName: Text (Last (FirstN(Split(Result,";").Result,3).Result).Result),
txtPosition: Text (Last (FirstN(Split(Result,";").Result,4).Result).Result)
}
)
)

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cyberco01

Is late for me here, will check it tomorrow but at moment try this

ForAll( AllPurchasesString, Patch( BonusRequests, Defaults(BonusRequests), { //Title: Text(Today()), //RepeatingSection: AllPurchasesString Title: DataCardValue1.Text, ProjNo: ComboBox1.Selected.PROJECTID, MonthName:DataCardValue3.Selected, RepeatingSection: AllPurchasesString } ); Notify( "Record Submitted Succesfully!", NotificationType.Success ); Refresh(BonusRequests); RequestHide()

Was this reply helpful? Yes No
cyberco01 480 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ramole This did not work.
Now while saving, 2 list items are not created. However, while deleting a row from the repeating table. additional list item is created.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cyberco01

As it shows not the formula i provied you is working correctly not adding Multiple so now you will need to modify the other

Was this reply helpful? Yes No
cyberco01 480 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ramole how to correct the code so that while deleting rows in the repeating rows of an existing list, new list is not created.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@cyberco01

Outside button and will delete any item(s) selected from gallery checkbox
Remove( Splist, colSelected ); Notify( "Records Deleted Successfully", NotificationType.Success ); Clear(colSelected); Reset(checkbox)
Add a check box inside the gallery -
OnCheck of check box add this
Collect(colSelected,ThisItem)

OnUncheck

Remove(colSelected,ThisItem)

You can even make the delete button disappear if nothing is selected by adding this code on Visible

Visible of the delete button outside
CountRows(colSelected)>0

Was this reply helpful? Yes No
cyberco01 480 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ramole ,
My form looks like below. Therefore, where should I add the Outside button code.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@cyberco01

Anywhere even on the top and test it

Was this reply helpful? Yes No
cyberco01 480 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ramole I am getting an error in the Remove part,

Was this reply helpful? Yes No