Missing something simple: Setting Item Value

[Vic3200]

Hi all, 

   I am struggling a bit here.  I am working on a corrective actions database app and I store corrective actions tasks in a separate list. When I edit these tasks, I open them up into a new screen and have a gallery there with all the fields.  I want to have a button "Mark Task Completed" button that will change the value of the "Completed" field and set the completion date (if one was not supplied).  Seem pretty straight forward - except for the concussion I have from beating my head against the wall trying to make this work.  Here is the "code" I gave for the "OnSelect" for the button, which is in the gallery (In scope). 

ThisItem.Completed = true; 
If( IsBlank( ThisItem.'Actual Date' ), ThisItem.'Actual Date' = Now() ); 
SubmitForm( EmerContainmentForm );
Back()

What insanely simple thing am I missing here?  Thanks...

[WarrenBelz]

Hi @Vic3200 ,

You cannot set a control value like that unfortunately - I suggest submit as normal and on the OnSuccess of the Form and assuming you are using SharePoint (you did not state)

If(
   IsBlank(Self.LastSubmit.'Actual Date'), 
   Patch(
      ListName,
      {ID: Self.LastSubmit.ID}
      {'Actual Date': Now()}
   )
) 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz]

Hi @Vic3200 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Vic3200]

No, unfortunately that didn't help but your assistance is appreciated.  Let me explain this from a different angle. I am creating an corrective action tracking app that used the 8D model - basically there are 8 steps to the process.  I created an app that is tab based and works well but I want the view to open directly to the step that we are currently working on so I created a field in the database called "stage" that contains an integer (1-8) for the step we are on.  I want to be able to have a "save and close" button, which does not change this "stage" value and also have an "advance to... (the next step)" button that would advance the "stage" value.  These two buttons submit the form to the database but only one changes the stage value.  If I add a patch to the "OnSuccess" call, there is no way for me to know if it's due to a "save and close" click or "advance to..." click.  I do not understand why I can't just call "CurrentCAR.Stage = 3" to set it directly - it would make things so much easier. I feel like I am missing something fundamental here. This is essential the same problem as I described above but in a more direct form.  What am I missing?

Screenshot of my app.

[WarrenBelz]

Hi @Vic3200 ,

The issue is what I described earlier - you cannot directly "call" and change a value. Have a look at the code I supplied OnSuccess of the form. You can Patch the new value in the field in there.