You’re offline. This is a read only version of the page.
Hello community,
I want to ask if it makes sense to use power automate flow to merge 2 Sharepoint lists,
assuming that the data size is 6000 and 20,000 rows
for example...
Can anyone advise me on where the limits are? because what I read and look the process of 100 rows for 30 seconds is no way from the performance view 😞
Is it possible to do it in a reasonable time ? Or do I need to look at other solutions... python, java.. etc
Thank you in advance
In addition to suggestions so far, you could also look at some SharePoint migration tools such as ShareGate. For ShareGate there is a cost for the license, but if you're looking to do a lot of this sort of thing then might be worth a look.
Hello @Sundeep_Malik ,
Thanks for the suggestion,
I have seen it in some topics like this and this will be my first attempt. According to the execution/performance, I will decide ... Because the examples that I saw was usually in small data.
Thanks !!
Hey @ctpmthh
You can try using send an http request to sharepoint.
This will send the rows from one list to another list really quickly. I have never used it myself so can't tell you the first hand experience.
Giving you a link to it.
https://www.youtube.com/watch?v=y5W5_IsBMUc
https://pnp.github.io/blog/post/how-to-use-send-an-http-request-to-sharepoint-in-power-automate/
Another easier method is there, but its not fast like the above method. The method is to use concurrency. With the help of concurrency, you can transfer data, 50 rows at a single time. On the right side of the action, you will see three dots. You can click on them and open settings and open the option of concurrency. Though this is method is not the best.
Plus, if you dont have a license you can only deal with 5000 items at a time, though there are workarounds but definitely they will affect performance.
If these two methods dont work for you, then I will suggest to use other solutions like python or java.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
