Answered

Help with patch

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. I am trying to use patch to update our SPList. The code below will simply add a record, not update an existing one. I have a dropdown that populates the text input fields, than when I updated the text field I want to update the record.

The formula I am using is

"Patch(
PMTGameDefects,
Defaults(PMTGameDefects),
{Title: ddDefectMaintGameName.Selected.Title,
Defect1: tiDefectMaint1.Text}
)"

It will not update a record, but it adds a new one. In the past when I have used Patch, the text fields are inside of a gallery, but this time they are not, they are just textinput fields except the one dropdown.

Thank you in advance!

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

zmorek 3,272 on at

Like
a
(1)

Report
Copy link

Link copied!

Defaults() is causing it to patch a new row. Instead of Defaults(PMTGameDefecets), you need to tell it what record to update. Something like LookUp(PMTGameDefects, ID = SomethingHere).

Was this reply helpful? Yes No
Ashwin7104 671 on at

Like
a
(1)

Report
Copy link

Link copied!

hey @ckserra33 ,

Below link can help you,

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-update-a-record-with-Patch/td-p/503503

Was this reply helpful? Yes No
ckserra33 421 on at

Like
a
(1)

Report
Copy link

Link copied!

@Ashwin7104 @zmorek Thank you both very much! This is what I finished with that works correctly.

Patch(
PMTGameDefects,
LookUp(PMTGameDefects,Title = ddDefectMaintGameName.Selected.Title),
{
Defect1: tiDefectMaint1.Text}
)

Thank you!!

Was this reply helpful? Yes No