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 ?
Solved! Go to 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!
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!
thanks!
User | Count |
---|---|
211 | |
94 | |
84 | |
50 | |
38 |
User | Count |
---|---|
270 | |
104 | |
102 | |
59 | |
59 |