Patch rows to SharePoint list

[Sri03]

Hi all,

I have a form and gallery in Powerapps which saves value to SharePoint list. When values are selected in form I am using a collection to collect the values and add rows into the gallery and i am using Patch to save to SharePoint. To save my code is :

Patch (

Consumption,

Defaults(consumption),

{

name: glrname.text,

Comp: glrcomp.text

}):

For e.g. when I am trying to save two rows now with values ( id:1, name: support, comp: CS, id:2, name: test, comp:da). These two are saved in two rows in SharePoint. When I come the next time to save another 2 different values with id :3 and Id:4. It must save only the next newly selected two values along with Id:1 and Id:2. 

• But now for me it is saving as 1,2(which is already present).1,2,3,4 (creating duplicate entries for ID:1,2). It must save only 3 and 4 only since 1,2 us already present.

The second requirement is When for this comp we have two values (CS,DR) for the name support.

(Id:1, name: support, comp:CS). When the user is trying to save for the second time for the  same name support. If CS is already there it must save only DR value and if both is already there it must notify value already exists.

Is there any way to do this? I tried so many possibilities but still it is saving duplicate values.

Any help/suggestion on this.

Thanks in advance.

[RogierE]

I guess the problem with your solution is the use of Defaults, which tells the Patch that it needs to create new records. In stead, when you Patch the whole collection without Defaults, the Patch function can figure out which records in the collection it needs to add and which are already present in the SharePoint list. 

Please like the reply and/or accept it as the solution if the answer is what you were looking for.

[Sri03]

@RogierE 

I tried without defaults but still it saves as the same with duplicates.

[RogierE]

How did you fill your Collection?

if you Patch the same Collection as you pulled from the list, it should work effortlessly. 

and if not, have you tried using the Form control? This saves you the trouble of creating and patching collections

[Sri03]

@RogierE 

On save I have given as with the collection name with For All.

For All( collection, 

Patch (

Consumption,

Defaults(consumption),

{

name: glrname.text,

Comp: glrcomp.text

})):

I have a requirement to display the data selected from form in gallery and then save to SharePoint. 

I have given a code to add rows in gallery in specific format with sequence and count rows.So I need patch function.

[RogierE]

So the problem I guess is the combination of the ForAll and the Defaults. 

What you're actually telling the App is to go through the collection and create a new record in the list for every record in the collection. 

What I was proposing is that you would not Patch your data record per record but the Collection as a whole. I built a little app to mimic your request,

and got it working with these formula's in the OnSelect of your buttons:

• in the GET button:  ClearCollect(colCollection,'Source')
• in the Add button: Patch(colCollection,Defaults(colCollection),{Title:4})
• and in the Save button: Patch('Source',ShowColumns(colCollection,"Title","ID"))

The last one is essential, I'm Patching without the ForAll, to let the algorithm check which record to update or to add. I need the ShowColumns statement to prevent from trying to overwrite some read-only columns in the SharePoint list by the way. 

So in short: add stuff to your collection locally and Patch to the Source as a whole

Please like the reply and/or accept it as the solution if the answer is what you were looking for.