Copy SharePoint list item to another list

(0) Share

Report

Posted on by romankorchak1

Hi All

I need to copy a SharePoint list item from one SP List to another (identical) SP list

So I am trying is

UpdateContext({Item:LookUp(TestList1,ID=2)});
Patch(TestList2, Defaults(TestList2), Item);

But getting error "Field 'Id' is required"
What, I think, might be happening, is created record (Item) got Id, which is created by system when adding new list item, and it cannot be changed. If thats a case - how do I remove Id value from Item record?

Thanks

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @romankorchak1

You could try dropping the ID with a call to the DropColumns function

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-table-shaping

UpdateContext({Item: DropColumns( Table(LookUp(TestList1,ID=2)), "ID" ) } ); Patch(TestList2, Defaults(TestList2), Item);
romankorchak1 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Getting "Invalid argument type (Table). Expecting a Record value instead" .
romankorchak1 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Also tried using "First(Item)" - then getting "{Attachments}:Field 'Id' is required" error
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@romankorchak1

This may be a stupid question but what do you need two identical lists for?
romankorchak1 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Keeping current and archived stuff separate.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@romankorchak1

I have a similar issue in my practice. I just added a single line of text and called the column Active. In my apps, I filter the same list on that column to separate out the Active patients from the Inactive ones.
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@romankorchak1

I think I see my mistake - can you try this?

UpdateContext({Item: First(DropColumns( Table(LookUp(TestList1,ID=2)), "ID" )) } ); Patch(TestList2, Defaults(TestList2), Item);
romankorchak1 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried it with "First()" - getting "{Attachments}:Field 'Id' is required" error