cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Frequent Visitor

Re: Problem with Patch in OnSuccess of SP Custom Form

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
Highlighted
Frequent Visitor

Re: Problem with Patch in OnSuccess of SP Custom Form

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,779)