cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

On Select update field

What is the "On Select" statement to update a field (example below) from a blank value to an "Y" value when you select a Submit Form?

 

SubmitForm.JPG

5 REPLIES 5
Highlighted
Helper I
Helper I

Re: On Select update field

@bmarcowka You can set a variable OnSelect of the icon and make the default value of TextInput is equal to that variable. You need to set the variable before submit form operation. So you code look something like below.

Set(textvalue,"Y");SubmitForm(Form1);Back()

Remember to TextInput Default is equal to textvalue.

 

Highlighted
Helper I
Helper I

Re: On Select update field

Correct me if I am wrong but shouldn't it read?

 

Set(MANUPDATE,"Y");SubmitForm(Form1);Back()

 

With MANUPDATE the field I am looking to update.

 

Thank You

Highlighted
Helper I
Helper I

Re: On Select update field

Here you are assigning MANUPDATE variable is equal to "Y". And make the deault value of the TextInput is eqaul to MANUPDATE. So when we click the button the default value will become "Y". Another way is you can use PATCH function to update the item in SharePoint list or any other datat source.

Highlighted
Helper I
Helper I

Re: On Select update field

The process is writing to the table as expected however it is writing a value of "N" not "Y".  

 

Any idea why?

Highlighted
Helper I
Helper I

Re: On Select update field

Are you passing "N" value at any step of your code or application? If yes at which place; during variable creation?

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 (9,160)