Power Platform Community Forum Thread Details

I am trying to update the status of an Order record using:-

Patch(
        '[dbo].[OrderJob]',
        LookUp(
            '[dbo].[OrderJob]',
            OrderJobId = SelectedJob.OrderJobId
        ),
        {
            JobStatusId: ddStatus.Selected.JobStatusId,
            LastUpdatedBy: User().FullName,
            LastUpdated: Now(),
            Comments: txtNotes.Text
        }
)

nothing happens but when I go back into edit mode for the code, the above code looks like it is erroring and I have this error message:

An error occurred on the server. Server Response: [dbo].[OrderJob] failed: BadGateway.

The OrderJob table has a Primary key which is OrderJobId.

I am at a total loss, have looked on Google but can find nothing that helps.

Categories:

General Questions