Answered

Set field value on form submit

(0) Share

Report

Posted on by StaceyGriffeth

I have a Sharepoint list with all of our employees. In Power Apps, you can select an employee from the list to initiate their Offboarding. When the name is selected (form: NewOffboarding_1) and the form submitted, I have the following assigned to the submit buttons OnSelect:

Set(varNewOffboardingName, OffboardingNameSelectBox.Selected.Title);

SubmitForm(NewOffboarding_1);

ResetForm(NewOffboarding_1);

Reset(OffboardingNameSelectBox);

Set(varOffboardingVisible, false)

I want to also have the SP field "OffboardingStarted" (Yes/No field) updated to "Yes" for the individual selected. How would I do that? Would it be in the button's OnSelect property? Or in the forms OnSuccess?

Categories:

General Questions

All responses (10)

Answers (1)

StaceyGriffeth 76 on at

Like (0)

Report

Re: Set field value on form submit

Hi @BCBuizer I think I had other issues in my code. I rebuilt the form from scratch and all is working fine now. Thanks for your help!
BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Set field value on form submit

Hi @StaceyGriffeth ,

Are you asking because a new record gets created instead of the expected existing one? The DefaultMode property of NewOffboarding_1 may play a role there, unless of course you are manually setting the FormMode anywhere in your app.
StaceyGriffeth 76 on at

Like (0)

Report

Re: Set field value on form submit

@BCBuizer Of course!

Is there a setting that would be causing it to create a new record, rather than updating the select (existing) record?
BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Set field value on form submit

Hi @StaceyGriffeth ,

Can you please also share a screenshot, including the tree view, of the DataCard, especially the Update property? I'm starting to run out of ideas as to why this is not working as expected, so I hope that may yield some clues.
StaceyGriffeth 76 on at

Like (0)

Report

Re: Set field value on form submit

@BCBuizer yes, I confirmed the field is Yes/No type
On further investigation, it's correctly setting this field value in the SP list, however it is not setting it for the selected name, it is creating an entirely new record and setting the value on it.
BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Set field value on form submit

Hi @StaceyGriffeth ,

The Default property doesn't play a role here, so we can leave that out of the equation.

Are you sure the column type is Yes/No and not Choice with "Yes" and "No" as possible options?
StaceyGriffeth 76 on at

Like (0)

Report

Re: Set field value on form submit

Hi @BCBuizer ok, I understand now. I added that data card to the form, set it's Visible property to false, and set the Update property to true. However, when I submitted the form, it did not update the "OffboardingStarted" field value to be "Yes". I'm wondering if the data card's Default value should be changed? It is currently "ThisItem.OffboardingStarted".
BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Set field value on form submit

Hi @StaceyGriffeth ,

Indeed, I forgot to mention to make the DataCard invisible after by setting its' Visible property to false. Like this the field gets updated upon form submission.
StaceyGriffeth 76 on at

Like (0)

Report

Re: Set field value on form submit

Hi @BCBuizer sorry, I'm not following. The form is literally just the selected employee name. But when that name is submitted, I want the other field OffboardingStarted to be set to Yes. OffboardingStarted shouldn't actually be visible anywhere to the user.
Verified answer

BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Set field value on form submit

Hi @StaceyGriffeth ,

In case the OffboardingStarted should always be set to "Yes", you can just add the field to the form, remove all controls from the DataCard and then set the DataCard.Update property to true.