Patch modified list items in a collection as new items to SharePoint list

(0) Share

Report

Posted on by rameshmukka

1,110

I have a collection whose schema is directly linked with my SharePoint list.

ClearCollect(
 colMPPDock,
 ShowColumns(
 'MPP Dock Dev',
 "Bay",
 "ForkTruckType",
 "MaterialType",
 "ID",
 "TruckStatus",
 "Author"
 )
);

The collection is connected to gallery and after all the updates on the gallery am successfully able to save to list using

Patch(
 'MPP Dock Dev',
 colMPPDock
);

Now the problem is when I get those items again in my gallery and modify them again, I would like to submit them as new items not as modified items. When ID column doesn't have a value in my collection, it is submitting as new item and when it has some value it is modifying existing item. I tried UpdateIf to update the ID to blank and also tried DropColumns on ID. Both didn't work. How can I submit modified items in collection as new items to SharePoint list. Hope my explanation is clear, otherwise happy to clarify.

Thanks and Regards,

Ramesh Mukka

Categories:

Connecting to Data

Using Apps Using Formulas

I have the same question (0)

All responses (3)

Answers (0)

StretchFredrik 3,308 Super User 2025 Season 2 on at

Like (0)

Report

Re: Patch modified list items in a collection as new items to SharePoint list

Hello @RameshMukka

Have you tried using "Collect" instead of patch? That might work in the case where it updates a row when you want to submit a new one

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Patch modified list items in a collection as new items to SharePoint list

@RameshMukka

Collect('MPP Dock Dev',colMPPDock);

Will add the items to the list

Was this reply helpful? Yes No
rameshmukka 1,110 on at

Like (0)

Report

Re: Patch modified list items in a collection as new items to SharePoint list

@StretchFredrik @Drrickryp

I get this below error when I used Collect('MPP Dock Dev',colMPPDock).
I have the ID value in my collection whose values came from SharePoint list directly.

Was this reply helpful? Yes No