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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,298)