cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

unable to update a column using submit butt

hello Everyone,

 

I am trying to update a column on "submit" button on the onselect property. Not sure if I am using the right code or not. Can someone please comment on this. Here "ManagerStatus" is the choice column

 

SubmitForm(Form5_1),
Managerstatus:
{
Value:"Reviewed"
};
Navigate(ManagerLandingscreen,ScreenTransition.None)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: unable to update a column using submit butt

Hi @rajkumar88 ,

Could you please share a bit more about your scenario?

Do you want to update the Managerstatus column in your SP list?

Further, does the Form5_1 connect to the SP list which contains the Managersstatus column?

 

Based on the formula you provided, I think there is something wrong with it. Please modify your formula as below (set the OnSelect property of the "Submit" button to following😞

SubmitForm(Form5_1);
Patch(                              /* <-- Use Patch function to update the Managerstatus column value */
         'YourSPList',
         Form5_1.LastSubmit,
        {
           Managerstatus: {
Value: "Reviewed"
} } );
Navigate(ManagerLandingscreen,ScreenTransition.None)

Please consider take a try with above solution, then check if the issue is solved.

 

More details about the Patch function, please check the following article:

Patch function

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: unable to update a column using submit butt

Hi @rajkumar88 ,

Could you please share a bit more about your scenario?

Do you want to update the Managerstatus column in your SP list?

Further, does the Form5_1 connect to the SP list which contains the Managersstatus column?

 

Based on the formula you provided, I think there is something wrong with it. Please modify your formula as below (set the OnSelect property of the "Submit" button to following😞

SubmitForm(Form5_1);
Patch(                              /* <-- Use Patch function to update the Managerstatus column value */
         'YourSPList',
         Form5_1.LastSubmit,
        {
           Managerstatus: {
Value: "Reviewed"
} } );
Navigate(ManagerLandingscreen,ScreenTransition.None)

Please consider take a try with above solution, then check if the issue is solved.

 

More details about the Patch function, please check the following article:

Patch function

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

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

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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,060)