Copy one item in Gallery as a new record - errors

(0) Share

Report

Posted on by bbsin

1,994

hi I trying to copy selected items in a gallery one row into a new records with new ID.. it's not working?

What did I miss? Thank you

Records are in Gallery picking up from SP list, I want to patch existing records - the same data as a new row of record with new ID one time only not to duplicate or auto copy again..

and save back to SP list as a new row record.. do I need to reset also somewhere???

both not working..

Select(Parent); Patch(List,LookUp(List,ID=ThisItem.ID)
{ Cat:{Value: CatG1.Text},
Type: {Value: TypeG1.Text},
C: {Value: CG1.Text},
IO: {Value: IOG1.Text},
Com: {Value: ComG1.Text},
Cod: {Value: CodG1.Text},
J: JG1.Text,
no: noG1.Text,
Date: DateG1.SelectedDate,
Amt: Value(AmtG1.Text)})

why the patch not working??? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

SaiKrishnaGudluru 499 on at

Like
a
(0)

Report
Copy link

Link copied!

to copy existing data from the Gallery, you can simply use Gallery1.Selected to read the entire record and perform required actions on it.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @krishnags

I want to copy record inside the gallery by row, user can select and duplicate the data they want to duplicate and it will appears as same item but with a new ID - one copy

not the entire gallery. thx

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @bbsin ,
I have answered this question in below thread.
Solved: question - is there any way to patch a row of reco... - Page 2 - Power Platform Community (microsoft.com)
I will also post my code here so that other users who have similar question can directly found the solution when search this kind of issue.
Set(varRecord,LookUp(List,ID=Gallery.Selected.ID)); Patch(List,Defaults(List), { Choice1:{Value:varRecord.Choice1.Value}, Number1:Value(varRecord.Number1), date1:varRecord.date1, Text1:varRecord.Text1, ... })
Best regards,
Allen

Was this reply helpful? Yes No