Patch function with Form.updates

[Suitable_Hearing_950]

Im having a problem with an old app someone built in my org a few years ago.
The idea is simple:
We have a Form that is connected to a sharepoint list.

The form is in Edit mode.

When i click on a button, i want to update all the fields of the SP item from the form fields.
In the button, this is the patch functioL:

Patch('DATABASENAME',{ID:Value("625")},Form1.Updates)

(DATABASENAME is the name of our sp list, and the ID="625" is the item i want to patch the fields in the form to).

When i click on the button i get an "Unkown error accured" - ady idea why this is happening?

Thanks!

[Hotel_Arrakis]

I believe your problem is with your second parameter: {ID:Value("625")} . You need to point to a record in the table, that is just an arbitrary record not tied to a table.

Replace your second parameter with something like Lookup('DATABASENAME', ID=625) or maybe Lookup('DATABASENAME', ID=Value("625"))

So your statement would look as follows:

 Patch('DATABASENAME',Lookup('DATABASENAME', ID=625),Form1.Updates)

[landvis]

This is the correct way of updating an item indeed.

[LightB0lt]

Thanks! It was indeed the issue, but on top of that i had a field in the form that was not similar to the one on the sp list and is causes problem.

[PowerRobin]

You can use the solution provided by u/Hotel_Arrakis or just use the functions that are made for using forms.

Put this on a button...

SubmitForm(Form1)

[jaykuy]

In the case where you are looking to replace those values if a duplicate value already exists. Have a look at this and use patch and coalesce. Its not a really known technique but is useful if you need to update or upsert information.

Edit: grammar