Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[John Heck]

Hello, I am trying to Patch a single record in the Orders table in SQL.  There is an Orders gallery and the gallery consist of an OrderID, CustomerName, SalesRep, Picked, CompletedDate.  I would like to have a date picker field in the CompletedDate column and a check box for the PIcked column so that it is an edit in the gallery.  I cannot get my Patch command to work when I update either field.  Each column is independent of the other column and only one can be selected at a time and the CompletedDate can not be selected until the Picked column is completed.  The system keeps giving an error the Record cannot be found. 

Patch(‘[dbo].[Orders]’
         {OrderID: galOrders.Select},
         {CompletedDate: datepickerfield}
);

I can get it to work using a form to be displayed over the gallery and using the SubmitForm(frmComletedDate) or SubmitForm(frmPicked) then selecting the save button.  I was trying to get away from using the form.

Thank you in advance for your help.
Kind regards,
John

——————————
John Heck
——————————

[Warren Belz]

Hi ,
The syntax required for Patch would be

Patch(
   '[dbo].[Orders]',
   {OrderID: galOrders.Selected.OrderID},
   {CompletedDate: datepickerfield.SelectedDate}
)?

?

——————————
Warren Belz
Queensland Australia
——————————
——————————————-

[John Heck]

Hello Warren,

 

Thanks for the information.  That is exactly what I had tried.  It seems to be working now a day later, closed the app and then opened it the next day and it is working.

 

Thanks for the help and confirmation on this.

 

Kind regards,

John

John Heck – Senior Project Engineer

—————————————————————————————————–

Center for Computer Resources, LLC

Main: 248-284-7100 | Fax: 248-284-7101 | Direct: 248-284-7185

Support: servicedesk@ccr1.com or CLICK HERE

 

——————————————-