@WarrenBelz , Thanks for the response sir.
For delete, I follow the following process.
- Open the list item
- Click on Edit Item
- Remove the rows using the small "x" icon
- Click the default Save button on the top.
Code on the "on select" of the small x icon:
*******************************************
RemoveIf(
InvoiceCollection,
lblSrNo = ThisItem.lblSrNo
)
Code on the onSave of SharePoint Integration:
***************************************************
Set(
AllPurchasesString,
Concat(
Gallery1.AllItems,
Concatenate(
txtSrNo.Text,
"; ", ComboBox3.Selected.PERSONNELNUMBER,
"; ",
txtEmpName.Text,
"; ",
txtPosition.Text,
";",
txtRate.Text,
";",
txtHours.Text,
";",
txtTotal.Text,
" | "
)
)
);
Patch(
BonusRequests,
Defaults(BonusRequests),
{
Title: DataCardValue1.Text,
ProjNo: ComboBox1.Selected.PROJECTID,
MonthName:DataCardValue3.Selected,
RepeatingSection: AllPurchasesString
}
);
Notify(
"Record Submitted Succesfully!",
NotificationType.Success
);
Refresh(BonusRequests);
RequestHide()
Code on the OnEdit of the SharePoint Integration:
*****************************************************
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),
txtRate: Text (Last (FirstN(Split(Result,";").Result,5).Result).Result),
txtHours: Text (Last (FirstN(Split(Result,";").Result,6).Result).Result),
txtTotal: Text (Last (FirstN(Split(Result,";").Result,7).Result).Result)
}
)
)
