Answered

Patching 3 fields to one record in a second sharepoint list from a Power App Form

(0) Share

Report

Posted on by russelln1

202

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

VeGETzX 367 on at

Like (1)

Report

Try

Patch(RTWEmpCode_SP, Defaults(RTWEmpCode_SP), {EmployeeCode: DataCardValue154.Text, 'First Name': DataCardValueX.Text, 'Last Name': DataCardValueY.Text});
Patch(NewStarter_1, Defaults(NewStarter_1), {ClockNumber: DataCardValue154.Text, 'First Name': DataCardValueX.Text, 'Last Name': DataCardValueY.Text});
SubmitForm(Form3)

You may need to replace DataCardValueX and DataCardValueY to match with your text input name for each field.

Was this reply helpful? Yes No
russelln1 202 on at

Like (0)

Report

@VeGETzX Exactly what I needed! thank you

Was this reply helpful? Yes No