How to Update Patch Condition to Overwrite Existing Data

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My latest work or art...

I need this patch to update all of the existing fields in the SP list in this condition when the User press the update button. I've gotten it to write new with the default condition; but I can't seem to figure this overwrite language out.

Patch(MemberList, Lookup( MemberList), {Park:UpdateFormParkDropdown.SelectedText.Park, NPSReg:UpdateFormNPSRegFld.Text, DOIReg:Value(UpdateFormDOIRegFld.Text), Title:UpdateFormUnqIDFld.Text, SteNmNo:UpdateFormSteNmNoFld.Text, FrstNm:UpdateFormFirstNmFld.Text, LstNm:UpdateFormLastNmFld.Text, MI:UpdateFormMIFld.Text, FullNm:UpdateFormFullNmFld.Text, UsrNm:UpdateFormUserNameFld.Text, ECMem:UpdateFormEngCoMemFld.Text, ECPark:UpdateFormEngCoParkFld.Text, ActveECMem:UpdateFormActiveECMemberFld.Text, MemberEmail:UpdateFormMemberEmailFld.Text, ProgramHierarchy:UpdateFormProgramHierarchyFld.Text});

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Solved it!

Thanks!

Patch(MemberList,
LookUp( MemberList, UnqID = EditFormUniqueIDFld.Text),
{Park:UpdateFormParkDropdown.SelectedText.Park,.....
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Also consider the UpdateIf function:

UpdateIf(MemberList, UnqID = EditFormUniqueIDFld.Text, {Park:UpdateFormParkDropdown.SelectedText.Park,.....

This takes on more data transaction out of the process (i.e. the LookUp).