Solved: Network error when using patch

Network error when using patch

Hello - this is driving me completely insane and I'm hoping you can help!

I am developing a comparatively simple canvas app using Dataverse as the source. Tables are:
Orders - simple header information

Order Lines - a many-to-one relationship to Orders, plus a part number and a line number

Picked Items - a many-to-one relationship to Order Lines, plus a serial number of the picked item

It generally runs as expected, but when trying to patch in the picked item I get "Network error when using patch: jvt_name is required". Two things to note: a) it's not required, and b) I am providing a value for it. Below I've included the spec of the column and the full formula that's throwing the error:

If(
 //Already scanned?
 Not(
 CountRows(
 Filter(
 'Picked Items',
 Order.Order = _orderGUID,
 'Order Line'.'Order Line' = liveOrderLine.'Order Line',
 Serial = Self.Text
 )
 ) = 0
 ),
 //Notify user
 Notify(
 "You have already scanned this serial number",
 NotificationType.Warning
 ),
 If(
 //Order line exists?
 CountRows(
 Filter(
 'Order Lines',
 Order.Order = _orderGUID,
 'Part Number' = txtPartNumber.Text
 )
 ) = 0,
 //Create order line
 Notify("Creating an order line");
 UpdateContext(
 {
 newLineNumber: CountRows(
 Filter(
 'Order Lines',
 Order.Order = _orderGUID
 )
 ) + 1,
 polyOrder: LookUp(
 Orders,
 Order = _orderGUID
 )
 }
 );
//////THIS IS THE BIT THAT'S FAILING//////
 Set(
 liveOrderLine,
 Patch(
 'Order Lines',
 Defaults('Order Lines'),
 {
 Order: polyOrder,
 'Part Number': txtPartNumber.Text,
 'Line Number': newLineNumber,
 Quantity: 0,
 Name: txtOrderNumber.Text & newLineNumber
 }
 )
 ),
 //Retrieve order line
 Notify("Recycling an order line");
 Set(
 liveOrderLine,
 LookUp(
 'Order Lines',
 And(
 Order.Order = _orderGUID,
 'Part Number' = txtPartNumber.Text
 )
 )
 )
 ),
 //Add the picked item
 UpdateContext({newQty: liveOrderLine.Quantity + 1});
 Patch(
 'Picked Items',
 Defaults('Picked Items'),
 {
 Order: liveOrderLine.Order,
 'Order Line': liveOrderLine,
 'Part Number': txtPartNumber.Text,
 Serial: Self.Text
 }
 );
 
);
//Reset the serial number box
Reset(Self);

Lastly - the smart highlighting is ignoring the part where I actually supply the value:

Honestly, I don't know what's going on. Any and all help will be very much appreciated!

Nick

Categories:

Microsoft Dataverse

Set( liveOrderLine, Patch( 'Order Lines', Defaults('Order Lines'), { Order: LookUp('Orders', ID = PolyOrder.Order), 'Part Number': txtPartNumber.Text, 'Line Number': newLineNumber, Quantity: 0, Name: txtOrderNumber.Text & newLineNumber } ) )

Quick Links

Subscribe to this forum!