Update record

[testaccPA]

Hi,

I have to update multiple records and therefore cannot come with a single form.

My idea would be an update ()

Update (answers; First (filter (answers; ID = Value (LabelAWbarbeiten_1_ID.Text)));
{Answer: TextInput_Anonse1_1.Text; Question_ID: Value ('TextInput_letzeFrageID + 1'.Text);
correct: Toggle_Anonse1.Value}) ;;

then he tells me with a error;  "ID is a mandatory field"

ok, so i added ID, but now the error "ID is generated automatically by the server" - is that a bad joke?

There is a Share Point online list in the background.

I've been google for hours ...

Do you have an idea ?

[CarlosFigueira · Accepted solution]

You probably need to use the Patch function in this scenario:

Patch(
  answers;
  LookUp(answers; ID = Value (LabelAWbarbeiten_1_ID.Text));
  {
    Answer: TextInput_Anonse1_1.Text;
    Question_ID: Value ('TextInput_letzeFrageID + 1'.Text);
    correct: Toggle_Anonse1.Value
  })

The Update function is used to replace an entire record in the data source, but what you want is to change a few fields of the record, so Patch is more appropriate here.

Hope this helps!

[testaccPA]

thanks!