Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Copy List items from one SP list to another SP list

(0) ShareShare
ReportReport
Posted on 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
    kfulton 30 on at
    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
    diegoandre10 517 on at
    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
    Mira Ghaly 11,409 on at
    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
    diegoandre10 517 on at
    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
    kfulton 30 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard