Unanswered

Patch Network Error. Possibly just syntax?

(0) Share

Report

Posted on by kariseightytwo

374

Hello, I posted this earlier and marked it as resolved, however it's actually not working, "Network error", Field "KeyColumn" is required.

ForAll(
 GalleryNewSchedule.AllItems,
 Patch(
 MyTable,
 If(
 IsBlank(
 LookUp(
 MyTable,
 KeyColumn = NameIndexTextBox
 )
 ),
 Defaults(MyTable),
 {
 KeyColumn: NameIndexTextBox,
 Area: Area,
 ScheduleDate: DateValue(ScheduleDate),
 Name: Name,
 Job: Job,
 DateTimeRecordAdded: Now(),
 Shift: Shift,
 JobAbbr: JobAbbr,
 CreatedByUser: User().Email 
 }
 )
 )
)
;

Oddly, it will update a record if the name I have selected is already in the SQL table, but when I choose a name that isn't in there yet it does not work.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kariseightytwo ,

I am not an SQL user, but try this structure (which would work in SharePoint)

Patch( MyTable, ForAll( Filter( GalleryNewSchedule.AllItems, IsBlank( LookUp( MyTable, KeyColumn = NameIndexTextBox ).KeyColumn ) && !IsBlank(NameIndexTextBox) ) As aPatch, { KeyColumn: aPatch.NameIndexTextBox, Area: aPatch.Area, ScheduleDate: DateValue(aPatch.ScheduleDate), Name: aPatch.Name, Job: aPatch.Job, DateTimeRecordAdded: Now(), Shift: aPatch.Shift, JobAbbr: aPatch.JobAbbr, CreatedByUser: User().Email } ) )

If an item is not in the gallery, remove the aPatch reference.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
kariseightytwo 374 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your response. Unfortunately I'm getting an error:
"Network error when using Patch function: The specified record was not found."
Seems as if it can't find the value in the keycolumn. Shouldn't be able to though because it's a new record at this point.. any thoughts?
kariseightytwo 374 on at

Like
a
(0)

Report
Copy link

Link copied!
Instead of patching directly from the gallery, I have the data in a collection, which I'd like to use.
Can you make this look up the record first and update, or create new if needed?:

ForAll(forCastdates,Patch(MyTable, Defaults(MyTable), { KeyColumn: NameIndexTextBox, Area: Area, ScheduleDate: DateValue(ScheduleDate), Name: Name, Job: Job, DateTimeRecordAdded: Now(), Shift: Shift, JobAbbr: JobAbbr, CreatedByUser: User().Email }));
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @kariseightytwo ,
As I noted, I am not an SQL user (in Power Apps - used a lot in Access some time ago), but what you have posted should work (albeit a bit slower as you are "looping" patches). Normally an Insert command in SQL does not need the Key Column, so I am a bit puzzled why it does not work. This post may be useful.
kariseightytwo 374 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, I certainly appreciate your help! Thank you for the link, too. I'll take a look.