Today I would like to introduce you to a solution I built to copy and paste SharePoint lists. This solution was borne out of an element of frustration as I was in an environment where I couldn't use Powershell and was setting up multiple dev, test, production SharePoint sites manually. With this app you can now copy and paste lists from one site to another with ease and no requirement for elevated permissions.
It works through handing the site URL and names of the lists off to power automate, this then uses SharePoint REST API to get an executable site script for each list. Saves them into a variable which can then be used by a second flow to paste the lists into the destination site.
If you would like to contact me about the solution, please do so Power Nerd Insights.
