web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Copy Repeating Table Row

Power Apps

Unanswered

Copy Repeating Table Row

(0) Share

Report

Report

Posted on by Will30

I have an app with a repeating table. I would like to add a button option (besides Save) to copy that saved data to the next row.

Meaning that the user does not have to re-enter the same data again if only a few boxes change.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Will30 ,

Let's say you have a Gallery of items which has a Save button.
You want to have another button as 'Copy' which will create a new record based on the record u click copy.

The following will be your formula:
Patch( <datasource>, Defaults(<datasource>), { ColumnName: ControlName, //Add columns as per your datasource and controls in your gallery. } )
Replace datasource with your source. Either SP or Dataverse or anything...

Note: Respect the datatype of the columns you add. Text goes with text, Numeric, Lookup Data, Boolean, as per your column datatypes.

Hope this helps
Will30 on at

Like
a
(0)

Report
Copy link

Link copied!

I am new to this and when they go to copy, I want the original line to be saved to the collection. Here is the Save formula;

Patch(
RequestCollection,
ThisItem,
{
PerDiemDate: dtePerDiemDate.SelectedDate,
Location: txtLocation.Text,
PerDiemRate: Value(txtPerDiemRate.Text),
JobName: cmbJobName.Selected.JobName,
Notes: txtNotes.Text,
TravelDay: drpTravelDay.Selected.Value,
Reimbursement: Value(txtReimbursementCalculated.Text),
CompanyHousing: drpCompanyHousing.Selected.Value,
CompanyCar: drpCompanyCar.Selected.Value,
ShowSaveButtons: false
}
);
If(
EditPressed,
false,
Collect(
RequestCollection,
{
PerDiemDate: "",
Location: "",
PerDiemRate: 0,
JobName: "",
Notes: "",
TravelDay: "",
Reimbursement: 0,
CompanyHousing: "",
CompanyCar: "",
ShowSaveButtons: true
}
)
);
UpdateContext({EditPressed: false});
Set(
NeedsSubmit,
false
)
How would I go about this?

Join the conversation