SharePoint Online - PowerApps - Integrated List - Set Column on Submission

[Tinygod]

Hello,

I would like guidance on how to best control the Status of an Item within a SharePoint List via PowerApps.

I have created a List and the List has the Default Title Column, along with a single line text titled Status.  I would like to configure the form via PowerApps so that when an Item is submitted the Status Column is set to Submitted just prior to actually submitting to the List. I am doing this so that I can control an Automate based upon the Status Field as this is what I did with InfoPath and Designer prior to my movement to Office 365.

What I need is a better understanding over how to go about doing this.  As I understand it, this would best be done with a statement within SharePointIntegration > OnSave  but am not sure what exactly to write.  Any guidance/assistance would be much appreciated.

Thank you,

[WarrenBelz]

Hi@Tinygod ,

There are a number of ways you could do this (you could also do it with a Patch), the easiest might be to put a Status card on the form (you can hide it if you want) and set the Default to 

If(vSubmit,"Submitted",Parent.Default)

Before the SubmitForm put (replace with your name). The submit icon would need to be in a card on the form somewhere.

UpdateContext({vSubmit:true});
Reset(YourSubmitControlName)

On the OnVisible of the screen

UpdateContext({vSubmit:false})

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.

[Tinygod]

Thank you for the advice.  I have a few questions:

1) Does any of this change if I did not build the app via PowerApps but rather built the List and modified it with PowerApps?

2) Does this have to be accomplished by adding a button and having it submit upon select?

Sorry, still very new to PowreApps, only been using it for a few days and I spent years and years using InfoPath so I have a lot to forget and learn.

[WarrenBelz · Accepted solution]

OK @Tinygod ,

No difference whether integrated or standalone App.

You could put it directly before the SubmitForm command on the save button - the refresh should work and update the field before it is submitted. A button would certainly work.

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.

[Tinygod]

Thank you, I will take what look further into what you taught me and look to apply it in the future.