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

[@ivancuervo777]

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

[@ShanesCows]

Glad it helped.

[@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.

[@ShanesCows]

Thanks for sharing Bob!

[@chigwidiri]

@@ShanesCows Is it possible to copy a record with attachments?

[@jray1429]

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

[@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!

[@mariecastine134]

Literally took me about 1.5 hours to implement on my current form! This is wonderful and is going to save us a lot of time with our forms. Thank you!!

[@ShanesCows]

Glad it helped!

[@asifh8152]

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

[@ShanesCows]

Awesome!!!

[@miltinhocamo3754]

Hi Shane... thanks for your videos. I need help with time and timestamp manage. My source is from Excel on onedrive. My location is UTC-5. When my users submit a new register it register "date - 5:00" (e.g., 11-16-2020 -5:00) but not the real timestamp (e.g., 11-16-2020 10:15 am). On the other hand, an App show information from Excel on ondrive, too. When it's a time cell shows the day before (e.g. On Excel: 11-13-2020 - On App: 11-12-2020). I've tried all I know and researched but this it has been a really nightmare. Thanks in advance.

[@ShanesCows]

With Excel as a datasource I recommend storing the date as text. Then you don’t get all of the UTC chaos.

[@miltinhocamo3754]

@@ShanesCows Ok. Thanks a lot.

[@sininv1]

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

[@ShanesCows]

Sorry, not sure what you are asking.

[@debbilawson9619]

Great video, as always! Now for a follow-up question: How can I find the GUID (in Dataverse) of the duplicate that I created?

[@ShanesCows]

TableName.TableName is the ID or Primary key. That will have the GUID. If you used Patch to create it you can Set(varRecord, Patch(...your logic)). This will store the whole record you just createdin the variable. So varRecord.TableName will be the GUID.

[@debbilawson9619]

@@ShanesCows Setting the variable was exactly what I needed! Thank you for your response!

[@Bozo19660]

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!!

[@Spurr82]

Hey, thought for content, I see you working with SP lists (and other DS's) a lot, and using Patch to fill, edit data, is the enough for a topic on when to use the insert an use form control and te submit form vs standard inputs with Patch, is there a fore and against, size of list working with (number of columns), flexibility etc? Great content again, thanks

[@ShanesCows]

I will add to my list of QTT videos doing a Form vs. Patch video. Fun idea.

[@Spurr82]

@@ShanesCows look forward to it 👍

[@joan322]

Hi Shane Nice video! Is it possible to the the selected records attachements copied into the new record? I have tried a lot of things, but it seems like it is not saving eventhough I have a collection, with the picture in it, added it to the attachements items, however it does not save with the attachement in it.

[@ShanesCows]

I think you have to use Flow to get and save attachments. :( Attachments are difficult to work with sadly.

[@chigwidiri]

@@ShanesCows Have you got a video on copying an item with attachments?

[@danielgil9651]

Sorry Shane is there any video where you explain how to make that screen that pop up while the background is darker? thanks

[@ShanesCows]

It is the same way I do the spinner in this video. kzbin.info/www/bejne/i4jcZnyVgtp8nbc I am sure I have covered it before in part of other videos like this one kzbin.info/www/bejne/rny7gaCBZZV3eaM but it doesn't have a dedicated video. I will add it to the QTT list. Great suggestion! 🐶

[@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

[@ShanesCows]

Oh.. that was something i used to handle the default behavior of the search box from the first video. Not important part of copying, it is part of the visual magic only

[@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

[@georgiescicluna8405]

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

[@mvos1980]

Thanks Shane. We will listen to your good advice.

[@ShanesCows]

Awesome. 😎

[@ahmadyamout1115]

You are amazing man thank you . But dear regarding copying the item from a list and paste it to another one is there a way to do so without using power flow?

[@ShanesCows]

You do it with patch I guess. I feel like I show some good options in this video.

[@ahmadyamout1115]

@@ShanesCows thank you

[@mohamednasr5444]

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

[@cristiancampo4755]

Hi Shane, thank you for the video. I tried using the same functionality however it doesnt copy the attachment, what can you advice for that?. Thank you in advance

[@ShanesCows]

I have never figured out how to Patch attachments. You would have to use a flow I am guessing

[@cristiancampo4755]

@@ShanesCows thank you for the quick reply, do you have a video showing how to edit certain fields of the record and when submitting it it copy the rest that hasnt being updated, including the attachment (similar to patch(...,form.updates)?

[@ShanesCows]

@@cristiancampo4755 I don’t. 😑 This video is as close as I have been that I can think of.

[@ehabatme5324]

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 🙏

[@ShanesCows]

Great suggestion!

[@clairevoyance26]

hi shane, i have a form that i need to "Save As", ive tried Patch function but it doesnt work for Attachments. Any advice or tips to patch an attachment to the new form?

[@ShanesCows]

Best I can offer is this video where I talk about how to handle attachments. Basically flow becomes involved. kzbin.info/www/bejne/gWiXhnmPnNd-eJY

[@rayromych5534]

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

[@riturajsingh169]

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 ?

[@sreyayendluri4744]

Hi Shane, Quick question can you also copy attachments if they are part of the original record with CDS backend?

[@ShanesCows]

I haven't tried but I would guess the answer is yes. They are just a table you need to grab.

[@bobcrowley6000]

Do you have an video or resource for why you prefer Patch over forms?

[@ShanesCows]

I don't... I talk about it randomly. I will add it to the list of videos, that would be a solid QTT. Thanks for the idea. The quick answer is control. Forms are great if you want them the way they are but as soon as you start needing to make them look or behave certain ways I find controls + patch less work.

[@fathimasamrinp2743]

Can we copy from another source(Clipboard) and PAste this in power apps?

[@ShanesCows]

You could paste into a text input field. But nothing else fancy

[@danielgil9651]

Hi Shane, sorry it is possible to copy the attachments of the record too? I tried the way you do in the video but it doesn't work, thanks in advance

[@ShanesCows]

I have never had luck patching attachments 😑

[@klaudia8323]

Any ideas how to copy gallery items which contain the attachment? Patch and collection dont work. Using flow to do that seems like much work to do. Any ideas for workaround? 🙏🏼

[@ShanesCows]

I don’t have a better answer 🤨

[@klaudia8323]

@@ShanesCows oh :( thank you for response!

[@pavelbenev3607]

Another great video Shane! You rock /. 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?

[@ShanesCows]

You might be in a case that needs refresh. 😀 It is okay to use when you prove you need it, like you did. 😀

[@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

[@tonysabarez3790]

I just signed up but I can't seem to find the download for the app source above. I really would like to. Is there a link that can point to where it is?

[@ShanesCows]

Hi Tony - Https://training.powerapps911.com and sign up for the curated library. You can download this and many other apps I have built. 🐶

[@tonysabarez3790]

@@ShanesCows I did sign up last night but I couldn't find this = "Power Apps Copy Item - Copy a record, make multiple copies, and edit + design tips". I will look again. Maybe it was just already too late or too early for the next day :-). Thank you!

[@enzisatine4918]

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?

[@ShanesCows]

Sorry for the delay. I am not sure. I guess there is a limit, I have never hit it but sounds like you may have. 😐

[@shwetanayak979]

Hi Shane , I am new to powerapps and learning from your videos. I have a requirement I want to create a pivot table in the powerapps using a SharePoint list. I cannot use excel or poeer BI. Do you think it is possible to create a pivot table similar to one we create in excel.

[@ShanesCows]

Yikes, I don't know...

[@qiangzhao7975]

Thanks, Shane, this is what I am looking for, I have a question here, I have a choice column called "status", the options are "copied event" "In process" and "Closed", if I copy a "closed" item, I want the status column of the copied item is "copied event", how should I do. thanks,

[@qiangzhao7975]

used below to get it resolved thanks, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

[@jasonholland83]

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.

[@julianomateus2935]

Hello, I'm from Brazil, I'm not able to use the patch function to copy, because the editor does not recognize the word varRecord.

[@ShanesCows]

varRecord is a variable you have to create first. I also cover VarRecord in this video which might help kzbin.info/www/bejne/bGqUoYWvh62KeLc

[@julianomateus2935]

@@ShanesCows tks!!!!!

[@RexKanum]

Is it possible to use a power app to display and edit a Teams wiki?

[@ShanesCows]

I don't know... that is a great question I am not sure about.

[@rob5800can]

Thanks for this video. Very helpful.

[@ShanesCows]

You're welcome!

[@ashokpershad]

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

[@ShanesCows]

It is handy for sure. 😎

[@rajkiran9465]

Hi Shane, I am new to power apps, my requirement is to copy parent and child records,using this video I can able to copy parent record but don't know how to copy child record.could you please help me out how to do.

[@ShanesCows]

I did A video for that also Power Apps Copy, Edit, and Save Parent Child Data - Expense Report Example kzbin.info/www/bejne/oWisoIFsZbSVn6c 😎

[@gerfer6261]

After successful Refresh time came to headquarters again. My scenario = want create SharePoint items from selected start date to selected end date for an employee. I want to create a new record for each selected date range, only the date is different else same. I tried using DateDiff( startDate.selecteddate, endDate.selecteddate)>0, patch(...(Default (. ) But only end up creating 2 records regardless to date range selected. If you got a minute it will be greatly appreciated ☺️

[@ShanesCows]

Yikes, I am sure it is possible but I don't know how off the top of my head.

[@tommycnbj]

great tutorial.

[@ShanesCows]

Thank you! Cheers!

[@TheToni2123]

thx again.

[@ShanesCows]

Always welcome

[@peanut-d-cat]

Meow.thank you.

[@ShanesCows]

Any time 😼!

[@gerfer6261]

😊 thanks. I going to take demon out from my app👹 Refresh

[@ShanesCows]

I approve! 😁