Answered

Copy large number of items from SharePoint List to SharePoint List

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I am trying to build a flow to get item from items from one SharePoint List ( latitude and longitude) and add it to a separate SharePoint List. It works, but there are over 200 items so it'll take over 3 hours to complete. Both list have a column ID that will compare if it matches then paste the latitude and longitude there, so it'll loop each item 200 times - so 200x200 will take forever. Is there anyway to avoid this?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (2)

Report

@Anonymous

Here is one solution to your issue - see screen shots below.

Rather than looping through each item in the destination list for each value in the source list, I use a Get Items inside of each loop with an OData filter. The filter allows me to return just a single item - the item with an OLDID that matches the source rows ID.

Also, remember that Get Items returns 100 items by default - you'll need to set that up to a number of 200 or higher - see screen shot.

Also, if this is a one time thing that you won't need to repeat, you might consider using MS Access - you could link to both tables, and create an update query and update the destination list in just a few minutes.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ScottShearer
Thanks for the reply. Will your solution still loop through and compare every value? Currently it is going through and checking ID 1 (200 times, will return 1st item true and next 199 false), then check ID 2 (return 1st false, next 1 true, next 198 false), and so on...Check ID 200( return first 199 false, last item true) I plan to run this more than once.

Thank you!

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Anonymous

My solution will loop through each item in the source list and update every matching item in the destination list (there should only be 1 matching item).

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thanks! that was exactly what I was looking for @ScottShearer

Was this reply helpful? Yes No