One follow-up on this.... I am seeing sporadic failures with getting attachment content. Error is "File Not Found." Any way we can add a skip feature? If so, any tips? Many thanks! Otherwise this has been a tremendous help!
SharePoint Default attachment column which you have just enabled by editing my current view. And Let me try it too. Thanks for your explanation (I did see this idea from reading other's comment and apply to use it)
Hi, thank you so much, this is a great video. Just one question, when I run this flow only a handful of list items get copied to the archive list. I have more than 3500 list items to be copied and seems like I will have to keep running the flow over and over gain. Is there a way to copy all list items on a single run? Thanks
Hi, Thank you for the video. It helped me a lot. I have a doubt, You have given ID(Id of list item the file is attached to ) of create item in get attachment content, But should it be the ID of Get item ?
Love your work! Can you do a video on how to copy just an attachment from one list to a master list. The attachments in the master list will grow over time as the one customer gets monthly invoices. Thankx again for sharing your knowledge
Thanks for your reply. My other issue is trying to append a document, PDF, from a document library to a master list. In the document library i have created a LOOKUP column from my master list and use the clients name as a reference. I now need to create a flow that attaches that document back to the clients entry in the master list. Cant seem to find any information about this. Your help would be much appreciated. Cheers
My problem is that i dont want to copy all attachments only the one i added. If i add another attachment to my item on my list, it will copy all the attachments.
Hello, sir. In the current circumstance, when the copy list by power automation means that the items with attachments are created in the archive 2018 List. I get the error message "We can't open this- something went wrong" when I try to open the attachment file. How do I deal with this error?
Excellent tutorial thanks, flow works well but I have an issue when the source list contains more than 1 attachment, say I have 4 different images attached with different filenames, it will add 4 files with the correct file names to the archive list, but the file content is all the same single image. Any way I can adjust for multiple attachments?
Hello, I am creating the item but it is not showing all the columns on the list? I want to transfer the created and modified columns. Any suggestions? Thank you
Hi, I tried you way but i chose automaed, the trigger is when item is created and modified. but the data seems to be duplicate. Let's say first the data is A and B, but when I submitted C, the items in the list now are A,B,A,B,C. Do you have any idea to solve it? Thanks
Hi your flow was so helpful thank you very much. One doubt that I have is, there is a way this flow work, but adding a condition as i.e only copy list items that have value of "Ready" in a specific field?
If there are multiple attachments in one list item and you set the create item in the for each loop, would that create 2 list items, 1 for each attachment?
I figured out the multi attachment, I'd had my delete in the each loop, so after it went through once I was deleting the item and hence only getting one of the attachments!! Still trying to figure out an automated trigger for archival ...but I'm getting there!!!
Great video. I missed to see this earlier to save my effort. I have a question. I could copy the item and attachments using Flow but how do i copy the version history using flow. Any inputs on this, great help as my requirement time sensitive. Please do share your contact to share my group who are in need of support on Sharepoint. Looking forward to hear from you asap.
@@LernenTech In the Archive 2018 list, the fourth column is "attachments". How can this be added? My question is not about the flow. I just wanted to know how to add this column. :)
Hi! It's working great but sadly for me it only copied the first 100 items from my list and I still have 4000 to go. Where can I set it up to copy all the items not just the first 100? EDIT: Forget it, I've found your other video... :)
On your Get Items, click into Settings. Turn pagination on and set the threshold value. The threshold value needs to reflect the number of items your list may grow to. ie. something greater than 4000.
On your Get Items, click into Settings. Turn pagination on and set the threshold value. The threshold value needs to reflect the number of items your list may grow to
Perfect! The change I made for my case was to trigger the flow when an item is created! Thank you for the detailed steps and spot-on explanation!!!
Glad it helped!
Perfect. Thanks so much for the clear explanation!
Outstanding - much appreciated! Clear and concise explanation... you are to be commended, my friend!
One follow-up on this.... I am seeing sporadic failures with getting attachment content. Error is "File Not Found." Any way we can add a skip feature? If so, any tips? Many thanks! Otherwise this has been a tremendous help!
SharePoint Default attachment column which you have just enabled by editing my current view. And Let me try it too.
Thanks for your explanation (I did see this idea from reading other's comment and apply to use it)
Enjoy
3:39 should it not be Get Item ID ?
Hi, thank you so much, this is a great video. Just one question, when I run this flow only a handful of list items get copied to the archive list. I have more than 3500 list items to be copied and seems like I will have to keep running the flow over and over gain. Is there a way to copy all list items on a single run? Thanks
Very good flow and running. But missed seeing the attachment. May need troubleshooting again. Thank You indeed.
You're welcome!
Saved me so much work!
Hi, Thank you for the video. It helped me a lot. I have a doubt, You have given ID(Id of list item the file is attached to ) of create item in get attachment content, But should it be the ID of Get item ?
Love your work! Can you do a video on how to copy just an attachment from one list to a master list. The attachments in the master list will grow over time as the one customer gets monthly invoices. Thankx again for sharing your knowledge
Great idea!
Thanks for your reply. My other issue is trying to append a document, PDF, from a document library to a master list. In the document library i have created a LOOKUP column from my master list and use the clients name as a reference. I now need to create a flow that attaches that document back to the clients entry in the master list. Cant seem to find any information about this. Your help would be much appreciated. Cheers
My problem is that i dont want to copy all attachments only the one i added. If i add another attachment to my item on my list, it will copy all the attachments.
It is a awesome video, it is very useful for me. Thank you.👋👍
Hello, sir. In the current circumstance, when the copy list by power automation means that the items with attachments are created in the archive 2018 List. I get the error message "We can't open this- something went wrong" when I try to open the attachment file. How do I deal with this error?
What is we didnt map values will that take automatically
Excellent tutorial thanks, flow works well but I have an issue when the source list contains more than 1 attachment, say I have 4 different images attached with different filenames, it will add 4 files with the correct file names to the archive list, but the file content is all the same single image. Any way I can adjust for multiple attachments?
If every list item does not have an attachment will it still work or will it skip the items without attachments?
Hello, I am creating the item but it is not showing all the columns on the list? I want to transfer the created and modified columns. Any suggestions? Thank you
Hi, I tried you way but i chose automaed, the trigger is when item is created and modified. but the data seems to be duplicate. Let's say first the data is A and B, but when I submitted C, the items in the list now are A,B,A,B,C. Do you have any idea to solve it?
Thanks
i created fresh copy not updated the current one for that i will write a flow soon
check the latest video on update item, i hope this will help you - th-cam.com/video/KYsMNoc7aPY/w-d-xo.html
Again if we ran the flow it will get duplicates ?
Hi your flow was so helpful thank you very much. One doubt that I have is, there is a way this flow work, but adding a condition as i.e only copy list items that have value of "Ready" in a specific field?
The reason, I dont want all my list items to copy only certain items
@@guillermomaldonado3538 yes you can do that in the Get items Filter section apply your condition and you are good to go
@@guillermomaldonado3538 check the latest video you can apply filter array th-cam.com/video/KYsMNoc7aPY/w-d-xo.html
I've added a control condition if a column has yes so equal to yes but when running the flow it returns as false, could you video an example please
tyvm sir, you help me lots.
Hello Brother, Will this copy the version details also? actually I need copy the version history of attachments also, aanyone please suggest any ideas
no it won't
If there are multiple attachments in one list item and you set the create item in the for each loop, would that create 2 list items, 1 for each attachment?
I have just used this method with a list item containing 2 attachments, both copied over into one list item in my archive list. Great video :)
Hi great video, subscribed, is this the same procedure for an automated flow?
procedure is same but you have to choose either item or items depend on your requirement
Works perfect, love your videos....but what if I have more than one attachment?
I figured out the multi attachment, I'd had my delete in the each loop, so after it went through once I was deleting the item and hence only getting one of the attachments!! Still trying to figure out an automated trigger for archival ...but I'm getting there!!!
Great tutorial. Thanks
Welcome
Great video. I missed to see this earlier to save my effort. I have a question. I could copy the item and attachments using Flow but how do i copy the version history using flow. Any inputs on this, great help as my requirement time sensitive. Please do share your contact to share my group who are in need of support on Sharepoint. Looking forward to hear from you asap.
not performed that yet, will look drop a note on lernentech@gmail.com
Thanks for the video. One of the columns is attachment. How can I add it in my list?
Come again what exactly you want
@@LernenTech In the Archive 2018 list, the fourth column is "attachments". How can this be added? My question is not about the flow. I just wanted to know how to add this column. :)
@@amiryunus1 this is SharePoint Default attachment column which i have just enabled by editing my current view.
how can I find the first video?
Great job.
what to do if flow keeps timing out????????????????
thank you for the video.
Each time I refresh Sharepoint, it is duplicating each item. Do you know why?
check your trigger point
Hi! It's working great but sadly for me it only copied the first 100 items from my list and I still have 4000 to go. Where can I set it up to copy all the items not just the first 100? EDIT: Forget it, I've found your other video... :)
On your Get Items, click into Settings. Turn pagination on and set the threshold value. The threshold value needs to reflect the number of items your list may grow to. ie. something greater than 4000.
Hi , Can you please create a video on how to archive list records with their version history as well in sharepoint list using MS Flow. Please
Sure will do that.
@@LernenTech Hi Again, Can you please help on the above request to archive with version History ?
This only copies 100 rows, when i run multiple times, it keep repeating same thing instead of copying the other rows
Hi, Can you please guide how you fix it to copy all items? I too having the same issue. Thanks
On your Get Items, click into Settings. Turn pagination on and set the threshold value. The threshold value needs to reflect the number of items your list may grow to