Patch Issue

(0) Share

Report

Posted on by mmattar

353

Hello all,

I have a Patch function that updates/Inserts into a SQL table, sometimes when i trigger the patch it goes through with no issues but nothing update in my table, i will click it again and then it updates. Is there an extra check i can do for the patch to make sure it works the first time ?

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

show your formula
mmattar 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Its just a normal patch function,

Patch(
'[dbo].table_name',
{
column1: Value,
column2: Value,
column3: Value,
column4: Value,
column5: Value,
column6: Value,
column7: Value,
column8: Value,,
column9: Value,
column10: Value,
column11: Value,
column12: Value,
column13: Value,
column14: Value,
column15 :Value,
column16: Value,
column17: Value
}
);
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Patch( Customers, Defaults( Customer ), { Name: “Contoso” } )
For adding new record. You left the defaults
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@mmattar

Here's my idea. I can't think of a way to make it less effort but the code should work.

// patch the record and store the result in a varaible Set(myPatchedRecord, Patch('[dbo].table_name', LookUp('[dbo].table_name', ID = some_number), { column1: Value, column2: Value, column3: Value } ) ) // check if the patched record matches input values Set(wasPatchSuccessful, myPatchedRecord.column1 = Value And myPatchedRecord.column2 = Value And myPatchedRecord.column3 = Value ) // display notifcation if patch was not successful If(wasPatchSuccessful, Notify("Patch did not update all values in SharePoint", NotificationType.Error) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."