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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
185 | |
54 | |
42 | |
36 | |
33 |
User | Count |
---|---|
261 | |
78 | |
75 | |
71 | |
67 |