Quick Search:

User Case: How to Copy List Items from One SharePoint List to Another list

 

I have two lists in SharePoint. My first list has a column of type Person or Group. I'm new to Power Automate, but I believe it's an array. I am trying to copy 1 record from the first list into a second list. During my Create Item step, I'm getting an error. I have tried changing the little toggle to detail and to the array setting. The detail setting puts me into a for each loop which I do not want. Being in a loop at that point will create the record in the new list as many times as there are people in the person or group array (column). The array setting generates the error above. What am I missing? Thanks!

- Question from StackExchange

Why Make Power Automate Copy SharePoint List Item to Another List

SharePoint Online
SharePoint Online

SharePoint List is a software tool on SharePoint that facilitates the organization, control and dissemination of information in an organized and structured manner. It works like a virtual version of a database or spreadsheet where information is systematically arranged in rows and columns.

There are several reasons why someone might want to make a Power Automate flow to copy SharePoint List to another site, for instance:

  • Data Duplication: There are times when it's necessary to duplicate data across lists, e.g., in an organization where multiple teams work on a project, each with their own SharePoint List. To centralize the information, it's crucial to merge it into a single master list, which can be automated with Power Automate.
  • Backup and Recovery: Creating a flow to copy items between SharePoint Lists can prevent data loss or corruption and serve as a backup mechanism. This automated process ensures data security and facilitates easy retrieval if necessary.
  • Workflow Optimization: Copying items between SharePoint Lists can optimize workflows and processes for organizations. It ensures that multiple teams responsible for completing specific tasks can access the necessary information to accomplish their duties.

In this post, we will illustrate how to copy list items to another list on SharePoint via Power Automate. If you want to know the details, read the following content carefully, please.

How to Make Power Automate Copy SharePoint List Item to Another List

The way to make Power Automate copy list item to another list on SharePoint is simple. We will take the IT’s Employee as the source list, and HR’s Employee in another list as the target.

IT’s Employee:

IT's Employee
IT's Employee

HR’s Employee:

HR's Employee
HR's Employee

Step 1: Go to your Power Point > Flows > New flow > Instant cloud flow.

Instant Cloud Flow
Instant Cloud Flow

Step 2: Enter the Flow name, hit the Manually trigger a flow, and press the Create icon.

Manually Trigger a Flow
Manually Trigger a Flow

Step 3: Then, press the New step tab in the next window. Enter get items to select the Get items button in the menu.

Get Items
Get Items

Step 4: Copy the IT’s Employee site and paste it to the Site Address. Then choose Employee as the List Name.

Get Items Info
Get Items Info

Step 5: Hit the Next step tab and enter create in the field. Then hit the Create item button in the menu.

Create Items
Create Items

Step 6: Fill in the field in the pop-up window. Paste the HR’s Employee site in Site Address and choose the List name as Employees. Then select the Title and Country info.

Create Items Info
Create Items Info

Step 7: Finally, you can hit the Test button on the right upper corner. Then choose Manually and start by hitting the Test tab. Later, Continue and Run flow when it asks you to do so in the next window.

Test Flow
Test Flow

This is how to make Power Automate copy list item to another list. Although it is a little troublesome, it can help you migrate one list to another list in SharePoint easily and quickly.

Bonus Tip: How to Copy SharePoint Documents to Another Account

You’ve learned how to copy items from one list to another list using Power Automate. But how about moving Documents on SharePoint? Even though you can choose to download files from one SharePoint account and then reupload then to another SharePoint account, it is time-consuming and cumbersome. In this situation, you can improve efficiency via a cloud transfer service – MultCloud.

MultCloud
MultCloud

MultCloud is a web-based cloud-to-cloud transfer service that allows you to migrate files and folders from one cloud to another directly without downloading and uploading. It currently supports over 30 popular and leading cloud storage services such as Google Drive, SharePoint, OneDrive, Dropbox, Dropbox Business, OneDrive for Business, Google Photos, iCloud Photos, etc.

So, you can use MultCloud to ease the process. It not only offers the industry-leading transferring speed, but also allows you to make automatic transfer tasks so that files can be moved between clouds at regular intervals.

Now, you can follow the steps below to learn how to transfer files from one SharePoint to another.

Step 1: Register an account on the official website of MultCloud.

Step 2: Head to Add Cloud. Then click on the icon of SharePoint to add your accounts respectively.

Add SharePoint
Add SharePoint

Step 3: Navigate to Cloud Transfer on the left sidebar. Then choose files in a document library of a SharePoint as the source and another as the destination.

Transfer SharePoint to SharePoint
Transfer SharePoint to SharePoint

In the End

That’s all about how to make Power Automate copy SharePoint list item to another list. Also, when you want to transfer files from SharePoint document library, you can utilize MultCloud to ease the process. Similarly, you can also move files from Dropbox to Google Drive seamlessly and effortlessly.

MultCloud Logo

Manage 30+ popular clouds in one platform.

Sign up Free

100% secure

New Release

Instagram Downloader

Effortlessly download and save Instagram posts, reels, stories, and highlights to manage your favorite content anytime.

Get Started for Free