Duplicate line from SharePoint List when button is pressed

(0) Share

Report

Posted on by SergiuTPLS

Hi,

Can you please provide some guidelines on how to copy the selected line from a Sharepoint list to a new line ?

So, I'm in a Form, edit form in Power app, of a line from a Sharepoint list. If a button is pressed in this form, I need this line to be copied as a new line ( with all the info from it) in the list.

Is there an easy way or simple way ?

Big thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @SergiuTPLS

This option works best on your scenario since you already in Edit Form
1. Create a new button on the edit form called "Save as New" or "Duplicate"
Patch('SPList', Defaults('List'), {Columns in the form});

Other Options also possible based on fields
2. Get specific item from SP to Collection
ClearCollect(ColSPItem, Lookup(SPList, ID= 10));
Update the collection ID = blank()
Patch(SPList, ColSPItem);

3. Call the Power Automate from powerapps to create duplicate

4. Have Power automate to create duplicate when some condition is met

Was this reply helpful? Yes No
SergiuTPLS 83 on at

Like (0)

Report

Incredible, that is so simple and so effective! i was planning to make a Flow !🤐
Thanks Stalin !

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@SergiuTPLS

If you are planning to provide a separate button to be the "duplicate button", then you will need to make sure your Form is using a variable on the Item property.

So, assuming you have a variable on the Item property of, let's say, glbCurrentRecord, then in the Duplicate button OnSelect, set the Formula to: Set(glbCurrentRecord, Patch(glbCurrentRecord, {ID: Blank()}))

Then when you submit the form, it will duplicate the record.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@SergiuTPLS

Sorry, I thought you were working with a record in a form.

Was this reply helpful? Yes No