How to make a copy of a 'list' in sharepoint

(0) Share

Report

Posted on by kjk4563

134

I am using Sharepoint as a DB when developing Power Apps, and I would like to copy it to create a list for testing.

If you can copy it, please let me know how.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

@kjk4563 - Settings > Site Contents > New > From existing list

Note the above will create a copy of the table schema. If you also need to copy the data and the data is at a high volume, I would recommend using Microsoft Access. If you need something more robust and sustainable, you could also leverage Power Automate.

For lower data volumes (e.g. a few hundred rows), it is possible to copy and paste data from one list onto another list. Note this should done 50-100 max rows a time, otherwise you will throttle the server.

Was this reply helpful? Yes No
kjk4563 134 on at

Like (0)

Report

@Amik Can you also tell me how to copy data?

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Bulk update SharePoint list

1. Download your source data from SharePoint into Excel

2. In your target SharePoint List, ensure any system generated columns such as the Created, Modified, ID columns are hidden.

3. Arrange the columns in your SharePoint list to match the column order in Excel

4. Change the SharePoint view to DataSheet/Grid view

5. Copy your Excel data

6. Select a single entire row in your SharePoint List

7. Enter CTRL V on your keyboard. Make sure you do this between 50 or max 100 rows at a time.

Notes

The above method does not require Excel, you can simply copy from one list to another list using the same process. However, I find it is easier to manage copying the data from Excel.

You may receive error notifications that some rows cannot be pasted. This is usually because your data source/spreadsheet has multiple line breaks in a cell. You can apply the Excel clean and trim functions on all of your columns prior to pasting the data into SharePoint.

Microsoft Access:

You can copy several columns (including complex columns like People columns) in Access from one SharePoint List, and paste them into other columns in a different SharePoint list without any errors/issues.

Note I have not tested the above with Choice columns.

Was this reply helpful? Yes No
kjk4563 134 on at

Like (0)

Report

@Amik
If I use the choice column, is the data not entered correctly?

If the maximum number of items that can be entered at once is 100, does it have to be repeated dozens of times to enter thousands of pieces of data?

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@kjk4563 - copying over Choice fields via the SharePoint method will not return errors. Doing this via Access I have not personally tested.

Yes to question 2.

Was this reply helpful? Yes No
kjk4563 134 on at

Like (0)

Report

@Amik
Is there any other way than this? It takes too long.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@kjk4563 - I have already provided you with three solutions. I am not clear on what else you're looking for.

Was this reply helpful? Yes No
kjk4563 134 on at

Like (0)

Report

@Amik
I just tested the method above, and it takes 3 minutes to input 100 pieces of data.
Is there any way to shorten this time?

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@kjk4563 - yes, using Access or Power Automate.

I already made clear in my first response to you that bulk updating SharePoint manually is ideal for lower data volumes.

Was this reply helpful? Yes No