Hi
I have one PowerApp Form and two Sharepoint lists - I need the 'Employee Code' (also known as Clock Number), 'First Name' and 'Last Name' to populate both lists.
The syntax I'm using is on the submit button and reads ;
Patch(RTWEmpCode_SP, Defaults(RTWEmpCode_SP), {EmployeeCode: DataCardValue154.Text});
Patch(NewStarter_1, Defaults(NewStarter_1), {ClockNumber: DataCardValue154.Text});
SubmitForm(Form3)
This syntax populates the employee code as I expected, I then did the same patch for both first and last name not realising, at the time, that a patch populates a new record for each patch so it generated 3 records one for each patch. How do I get these three fields to populate into one record?
The primary list is from a new starter form and I want these three fields to populate a secondary list that just has the employees listed as this is used for other forms that I have created.
Many thanks
