Microsoft Flow - Copy List Items with attachment to another list | MS Flow Copy List attachment

Поділитися
Вставка
  • Опубліковано 24 січ 2025

КОМЕНТАРІ • 63

  • @stevenmeggeson8163
    @stevenmeggeson8163 4 роки тому

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

  • @alexmolina304
    @alexmolina304 2 роки тому

    Outstanding - much appreciated! Clear and concise explanation... you are to be commended, my friend!

    • @alexmolina304
      @alexmolina304 2 роки тому

      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!

  • @omtschand3432
    @omtschand3432 3 роки тому +1

    3:39 should it not be Get Item ID ?

  • @joaofarinha551
    @joaofarinha551 Рік тому

    Perfect. Thanks so much for the clear explanation!

  • @laszlogyor6628
    @laszlogyor6628 Рік тому

    It is a awesome video, it is very useful for me. Thank you.👋👍

  • @devikaanil5763
    @devikaanil5763 4 роки тому +1

    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 ?

  • @JR-ov7wr
    @JR-ov7wr 3 роки тому +1

    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

  • @aminaali6616
    @aminaali6616 2 місяці тому

    tyvm sir, you help me lots.

  • @MichaelRoss-d1f
    @MichaelRoss-d1f 3 дні тому

    if i have a flow setup that already copies list items, and correlates them based on SourceID eq 'identifier', how do you incorporate a flow that also copies over attachments?

  • @VH-yg8rx
    @VH-yg8rx 3 роки тому

    Saved me so much work!

  • @tinmaung9043
    @tinmaung9043 4 роки тому

    Very good flow and running. But missed seeing the attachment. May need troubleshooting again. Thank You indeed.

  • @tinmaung9043
    @tinmaung9043 4 роки тому

    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)

  • @benbenevento8333
    @benbenevento8333 3 роки тому

    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

    • @LernenTech
      @LernenTech  3 роки тому

      Great idea!

    • @benbenevento8333
      @benbenevento8333 3 роки тому

      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

  • @riteshkavankar
    @riteshkavankar 5 місяців тому

    What is we didnt map values will that take automatically

  • @guillermomaldonado3538
    @guillermomaldonado3538 4 роки тому

    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?

    • @guillermomaldonado3538
      @guillermomaldonado3538 4 роки тому

      The reason, I dont want all my list items to copy only certain items

    • @LernenTech
      @LernenTech  4 роки тому

      @@guillermomaldonado3538 yes you can do that in the Get items Filter section apply your condition and you are good to go

    • @LernenTech
      @LernenTech  4 роки тому

      @@guillermomaldonado3538 check the latest video you can apply filter array ua-cam.com/video/KYsMNoc7aPY/v-deo.html

    • @none-qq9lg
      @none-qq9lg 4 роки тому

      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

  • @ibzkoty
    @ibzkoty Рік тому

    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?

  • @lynngill7190
    @lynngill7190 3 роки тому

    Works perfect, love your videos....but what if I have more than one attachment?

    • @lynngill7190
      @lynngill7190 3 роки тому

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

  • @Jeevatx
    @Jeevatx 2 роки тому

    Again if we ran the flow it will get duplicates ?

  • @realpolitik2314
    @realpolitik2314 3 роки тому

    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.

  • @none-qq9lg
    @none-qq9lg 5 років тому

    Hi great video, subscribed, is this the same procedure for an automated flow?

    • @LernenTech
      @LernenTech  5 років тому +1

      procedure is same but you have to choose either item or items depend on your requirement

  • @andyhick7363
    @andyhick7363 2 роки тому

    If every list item does not have an attachment will it still work or will it skip the items without attachments?

  • @MaverickR1
    @MaverickR1 3 роки тому

    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?

    • @lornahamilton7420
      @lornahamilton7420 Рік тому

      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 :)

  • @brettwatty101
    @brettwatty101 5 років тому

    Great tutorial. Thanks

  • @RajivRajvat
    @RajivRajvat Рік тому

    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?

  • @brittnyb90
    @brittnyb90 2 роки тому

    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

  • @profitmuhammad7575
    @profitmuhammad7575 Рік тому

    what to do if flow keeps timing out????????????????

  • @suryazn4575
    @suryazn4575 Рік тому

    Hello Brother, Will this copy the version details also? actually I need copy the version history of attachments also, aanyone please suggest any ideas

  • @shabihulhasnain1164
    @shabihulhasnain1164 Рік тому

    Great job.

  • @guilleni
    @guilleni 2 роки тому

    how can I find the first video?

  • @shakilarosli8757
    @shakilarosli8757 5 років тому +1

    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

    • @LernenTech
      @LernenTech  5 років тому +2

      i created fresh copy not updated the current one for that i will write a flow soon

    • @LernenTech
      @LernenTech  4 роки тому +1

      check the latest video on update item, i hope this will help you - ua-cam.com/video/KYsMNoc7aPY/v-deo.html

  • @mohanpalla1
    @mohanpalla1 4 роки тому

    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
      @LernenTech  4 роки тому

      not performed that yet, will look drop a note on lernentech@gmail.com

  • @amiryunus1
    @amiryunus1 4 роки тому

    Thanks for the video. One of the columns is attachment. How can I add it in my list?

    • @LernenTech
      @LernenTech  4 роки тому

      Come again what exactly you want

    • @amiryunus1
      @amiryunus1 4 роки тому

      @@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. :)

    • @LernenTech
      @LernenTech  4 роки тому +1

      @@amiryunus1 this is SharePoint Default attachment column which i have just enabled by editing my current view.

  • @tejc8942
    @tejc8942 5 років тому

    thank you for the video.
    Each time I refresh Sharepoint, it is duplicating each item. Do you know why?

    • @LernenTech
      @LernenTech  5 років тому

      check your trigger point

  • @priyankasrivastava5056
    @priyankasrivastava5056 4 роки тому

    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

    • @LernenTech
      @LernenTech  4 роки тому +1

      Sure will do that.

    • @priyankasrivastava5056
      @priyankasrivastava5056 3 роки тому

      @@LernenTech Hi Again, Can you please help on the above request to archive with version History ?

  • @somesz83
    @somesz83 2 роки тому

    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... :)

    • @dorothyoregan3594
      @dorothyoregan3594 2 роки тому

      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.

  • @Itsprincessa01
    @Itsprincessa01 2 роки тому

    This only copies 100 rows, when i run multiple times, it keep repeating same thing instead of copying the other rows

    • @HinaGeo
      @HinaGeo 2 роки тому

      Hi, Can you please guide how you fix it to copy all items? I too having the same issue. Thanks

    • @dorothyoregan3594
      @dorothyoregan3594 2 роки тому

      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