Power Apps Copy Item - Copy a record, make multiple copies, and edit + design tips

In this video, you will learn how to copy an item in Power Apps plus we show off some fancy animations along the way. Learn to copy an item, make multiple copies, and even edit the record before making the copy.

[ivancuervo]

I see this being useful when someone wants to create same/frequent/common requests without filling out whole forms again! Thks Shane!!

[jray]

This is Utterly Amazing 😂
No, really this is great. I was just looking for something similar to this. You’ve made my day.
Thank You!!!

Now, just to make it open the copy automatically when it’s a record that has more field

[mvos]

Thanks Shane. We will listen to your good advice.

[NKBobcat]

Excellent! I wish I could patch more but I use forms a lot because my app owners require lots of fields. Many apps have more than 100 fields in a single data source. Patch would take me all day. When I copy a record, I have the copy icon set a variable called Set(varCopy, true). I also Set(varRecord.ThisItem) (Learned from you!). I then navigate to the New form. I then set the Default value with If(IsBlankorError(varCopy), Parent.Default, varRecord.fieldname). It's still a lot of work, but it works for forms.

[asifh]

I can see another utilization of it in new form, where you want to add multiple copy of same data. Great stuff.

[MarieCastine]

Thank you so much! This just saved me so much work of having to figure out the copy option. Will be implementing in my form tonight! Lol!

[mohamednasr]

Amazing man thanks a lot, what about if I have attachment field needs also to be edited

[ashokpershad]

New Feature I never used before, hope some day i will refer back to this video... :)

[georgiescicluna]

Hi. Great video just what l was after. In that sequence how can l add a day to the date column for the new records as they are created. Thanks in advance

[Bozo]

Great videos Shane! A question please, I'm trying to replicate your 'Just copy' button patch function using a variable like you did in this video. Could you give an example of patching a choice value please through the variable? Thanks a lot!!

[riturajsingh]

Hi Shane, this is an excellent tutorial. Helped me a lot. Just one question, let's say I want to bulk copy data that is sorted monthly and the only field that changes is the date. So let's say month of May had 10 records and i want to bulk copy those records into June by just changing the month field. Is that something you have a tutorial on or can help me with ?

[ehabatme]

Thank you for your ongoing added values on PowerApps. I would appreciate an Audit Checklist app with a dashboard for operation to see audits for all departments. Also how to have a defined questions & categories based on department.

Have a smooth move 🙏

[gabseqdu]

Hi Shane, thank you for your amazing videos. I'm having trouble with the Copy multiple items part. I have a sequence of several items on the list based on filters, when I do Copy all the first item gets copied multiple times... if my list count of items is 2 same item is copied 2 times, or 15 or 8 etc. It feels like the forall is not moving through my gallery item list. Any help would be appreciated

[rayromych]

Thanks for another great video!
Got one question though - is there any way to copy item from one SharePoint list to another SharePoint list with identical columns without typing all fields/values to be copied?
I tried Patch(List2, Defaults(List2), LookUp(List1, ID=3) ) ; but it complains that some fields are added automatically (Created, CreatedBy etc) rather than passed.
Thanks

[marcosmanto]

Many thanks Shane I learn a lot from your channel. Just one question what varOnStart do at the end of copying code? Again thanks Shane

[pavelbenev]

Another great video Shane! You rock \n/. I have an attachment control which I am using to attach all kind of files to a SP document library. Each attachment/s should be assigned to a specific ticket request. After that I have a gallery to display the names of all attachments for this ticket so users can review them in the future. The gallery is not refreshing with the new attachments without the refresh statement. Is there another way to do it because you said never use refresh?

[jasonholland]

Where did you get the VarRecord from? I have a form that links 3 forms to each other to combined as one form under a var call vartype. How would It work for me in that since.

[ndzalavukosi]

Im new to power apps, am looking to move a record from one sp list to another when a button is clicked on power apps, i.e list of active users is displayed and when the revoke button is selected the record should be deleted from active users and the record moved to deactivated users sp list

[enzisatine]

Hi Shane!
Your videos are AMAZING so thank you so much for taking the time to make them :)
One quick question - is there a limit on how many fields you can 'patch' to create a copy? I have a large SharePoint list (over 60 fields) and i need to be able to copy an item multiple times, but it looks like when i applied your formula it doesn't quite work. Like it worked at the beginning and then I went back to the application and it stopped working. Any thoughts?

[sininv]

Hi Shane, this is great.. Any chance of showing to u create those created more than one . thx