So I have a really big form that I'm automating which I've split into four
- Form1
- Form1_1
- Form1_2
- Form1_3
I used Patch to try and update the records but instead it creates a new one:
Errors('Supplier Evaluations',Patch('Supplier Evaluations', Defaults('Supplier Evaluations'), Form1.Updates, Form1_1.Updates, Form1_2.Updates, Form1_3.Updates))
I tried replacing the defaults with LookUp but I can't seem to make it to work. (ABN is like the unique identifier).
Set(lookupRecord, LookUp('Supplier Evaluations',ABN = DataCardValue3.Text));
If(
IsBlank(lookupRecord),
Patch('Supplier Evaluations', Defaults('Supplier Evaluations'), Form1.Updates, Form1_1.Updates, Form1_2.Updates, Form1_3.Updates)
);
Patch('Supplier Evaluations', lookupRecord, Form1.Updates, Form1_1.Updates, Form1_2.Updates, Form1_3.Updates)

Report
All responses (
Answers (