cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Assurity
Frequent Visitor

Problem with Patch in OnSuccess of SP Custom Form

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 ?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Assurity
Frequent Visitor

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);

View solution in original post

1 REPLY 1
Assurity
Frequent Visitor

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);

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,059)