Unanswered

Alternate to mapping columns exclusively while creating SP List items

(0) Share

Report

Posted on by pnathany26

I need to copy data from one SharePoint list to another with exact same columns but my list has around 200 columns to be copied. It is not good idea to map 200 columns individually. How could I create/copy items in other list with data/column values falling in right place?

@ShaneYoung

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

CU29071406-1 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Shane,

did you ever figure out a way to do this without mapping every field?

Was this reply helpful? Yes No
WillPage 2,307 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Consider using the Send an HTTP Request to SharePoint action to get the list items from the source list and create the list items in the destination list. https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest

As the source and destination schema are the same you should be able to take the relevant part of the response body from a GET call on the source list and use it directly in a POST call on the destination list. You may need to put a Compose between with a few nested removeProperty functions to get rid of any read-only fields but there's no manual mapping of fields unless you changed the internal column names on the new list

Was this reply helpful? Yes No