web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to duplicate a rec...
Power Apps
Unanswered

How to duplicate a record in a form ?

(1) ShareShare
ReportReport
Posted on by 13

 Hello,

 

Can someone help me ? I am new in PowerApps.

 

I have a power apps with datasource an sharepoint list.

"SubmitForm" can allow me to save changes to an existing record.

"NewForm" can allow me to add another new record (by default, all fields are blank).

... but how can I duplicate an existing record (add another similar records) ??? My need is to duplicate an existing record, then make change to specifics fields only.

 

 

Sorry, I am on this issue since several days, please help me !!

 

Best regards,

Hy-Boui

Categories:
I have the same question (0)
  • dinusc Profile Picture
    Microsoft Employee on at

    There should be a way to duplicate the last record but I would not recommend going that path as it may cause issues (for example if an unigue identifier is duplicated).Assuming that you would prefer to have some data pre-populated in the new form, the best way would be to define some default values for your form controls. 

  • Verified answer
    hyboui Profile Picture
    13 on at

    Hello,

     

    I have tried and it works !!

    I change the default value by the needed field (from the record selected).

    Many thanks for your helpfull and quick reply !!

    Best regards !

     

    Hy-Boui

  • amralomari Profile Picture
    169 on at

    OK but how? what to type in the default value box??

  • Community Power Platform Member Profile Picture
    on at

    looking forward as well for the answer.
    Want to duplicate a register so I can edit the second one

  • Anastasiia Sakhnenko GM Profile Picture
    12 on at

    It would be greate to find widened answer for this question.

    My issue is - that I have 2 cells : Title and Title 2. I want duplicate text, which was entered in cell Title to the cell Title 2.

    Thank you

  • Community Power Platform Member Profile Picture
    on at

    Hello,

     

    I have same issue. Could you please elaborate, how you resolved this?

     

    Thanks,

    S

  • Schwerzmann Profile Picture
    40 on at

    Hi community

    As this post contains frustrating little solution, I might give a hint by adding the link to a post that helped me with a similar concern: Solved: Copy existing item and submit as new item on Share... - Power Platform Community (microsoft.com)

    Happy copying

  • Dsa2 Profile Picture
    101 on at

    Frustrating solution. You should be more specific 

  • Eric_Speicher Profile Picture
    31 on at

    FYI, the actual solution is to use Patch instead of SubmitForm.  Unfortunately, not very elegant.

  • DS1060 Profile Picture
    77 on at

     

    Thanks to Schwerzmann for his link but this were not answering my needs.

    So I post my solution:

    Scenario: I want to duplicate the form but not instantly publish it, just a fresh form with the same values.

    The "Item" property of my form is a variable (varForm) which contains the record to show.

    Form1.Item=varForm

    On the duplicate button I set the variable varDupe to true, remove the ID from the varForm and start a new form.

    BtnDuplicate.OnSelect=Set(varDupe,true);
    NewForm(Form1);
    Patch(varForm, {ID: Blank()})

    Then, on each DataCard of the form, I set the Default as conditionnal, if varDupe then put the info to duplicate, else put the usual default value.

    Title_DataCard1.Default=If(varDupe,varForm.Title,ThisItem.Title)

    Now every fields is filled with the previous form values.

    On submit form I remove the "true" from the variable varDupe.

    BtnSubmit.OnSuccess=Set(varDupe,false);Set(varForm,Self.LastSubmit);Notify("Success",NotificationType.Success)

     Hope my explanation is clear enough.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard