Copy List items from one SP list to another SP list

(0) Share

Report

Posted on by diegoandre10

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:

I got this error:

how can I get it right?

thanks 🙂

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

kfulton 30 on at

Like (1)

Report
Copy link

Link copied!

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.
Hope this helps!

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @kfulton

It ran for 2:30 hours and failed:

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!

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@diegoandre10
The highlighted should be Value and not List of Items

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

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:

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

Was this reply helpful? Yes No
kfulton 30 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No