web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 9xkKsXsSrXm7Z0eIR8HaMq
Power Automate - General Discussion
Unanswered

Copy List items from one SP list to another SP list

Like (0) ShareShare
ReportReport
Posted on 24 Jul 2020 18:30:19 by 517

Hi all

 

I have a Sharepoint list (called Productivity tracker) with existing items that I would like to move to another one that is empty (named ASEAN).

 

My intention would be to have the secondary sharepoint list (ASEAN) updated on a daily basis whenever items are created or updated on the original sharepoint list (productivity tracker)

 

I created a flow like this:

 

SO1.JPG

 

SO2.png

 

I got this error:

 

sadasa.JPG

 

 

how can I get it right?

 

thanks 🙂

  • kfulton Profile Picture
    30 on 27 Jul 2020 at 14:56:06
    Re: Copy List items from one SP list to another SP list

    @diegoandre10 Not sure if this is what's causing the error, but you shouldn't need the 2nd and 3rd "apply to each" functions, since the whole condition is inside the initial "apply to each." That should at least bring your run time down. You can also go into the "apply to each" settings, turn on concurrency, and increase the degree of parallelism to significantly decrease runtime. Let me know if that helps or if you still get an error message after removing the inner "apply to each" functions.

    kfulton_0-1595861691263.png

     

  • diegoandre10 Profile Picture
    517 on 27 Jul 2020 at 14:14:36
    Re: Copy List items from one SP list to another SP list

    Hi @kfulton 

     

    I used the values but still didnt work. The error message is the above I shared in the last message.


    Here is the flow:

     

    as.JPG

     

    as1.JPG

     

    Is there any flow template I could follow whenever a new item is created or updated on the original SP List to have the secondary updated too?

     

    Thanks

  • Mira Ghaly Profile Picture
    11,409 Moderator on 25 Jul 2020 at 11:28:19
    Re: Copy List items from one SP list to another SP list

    @diegoandre10 

    The highlighted should be Value and not List of Items

    Mira_Ghaly_0-1595676439640.png

     

  • diegoandre10 Profile Picture
    517 on 25 Jul 2020 at 04:04:39
    Re: Copy List items from one SP list to another SP list

    Hi @kfulton 

     

    It ran for 2:30 hours and failed:

     

    sadssadas.JPG

     

     

    tryrtytry.JPG

     

    The error message says:

     

    {
      "status"404,
      "message""Could not find list item.\r\nclientRequestId: 9b4a2581-4d67-446b-b23e-f8df18b6b551\r\nserviceRequestId: 9b4a2581-4d67-446b-b23e-f8df18b6b551"
    }
     
    Any idea what could be wrong?
     
    I used the values you mentioned.
     
    Thanks!

     

  • kfulton Profile Picture
    30 on 24 Jul 2020 at 21:51:11
    Re: Copy List items from one SP list to another SP list

    Hi @diegoandre10,

     

    I believe when you're passing the "List of items" into the for each element, you're passing it the list object and not each value within it. The should be a "value" field in the dynamic content drop-down that will allow the for each loop to iterate through the actual item values in your list. 

    kfulton_0-1595627447648.png

    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete