Hi,
I am trying to use the Patch command to update the current record in the SharePointForm.OnSuccess action. If I do something like this :
Patch(Expenses, SharePointForm1.LastSubmit,{ FullName:CurrentUser, VAT:"TEST1", Nominal: "TEST2" }); ResetForm(SharePointForm1); RequestHide()
It works fine. However If I update the VAT, and Nominal fields to get values from a list box, such as :
Patch(Expenses, SharePointForm1.LastSubmit,{ FullName:CurrentUser, VAT:ListBoxNominal.Selected.Vatcode, Nominal: ListBoxNominal.Selected.Code }); ResetForm(SharePointForm1); RequestHide()
This does not work and the VAT and Nominal fields are not updated. If I go back and edit the record and save it again, the values are then updated!?
I have also done a test and changed the OnSuccess to just output the results of the ListBoxNominal and it is outputting the expected value :
Notify("Result = " & ListBoxNominal.Selected.Code,NotificationType.Information);
Can someone help me to get the Patch statement working using the results from the selected item in the list box ?
Solved! Go to Solution.
Well after searching some more on these forums I found my answer :
If I add the following line before the Patch command the update then works :
Refresh(Expenses);
Well after searching some more on these forums I found my answer :
If I add the following line before the Patch command the update then works :
Refresh(Expenses);