Update a SharePoint Choice column from Power Apps Form based on Submit and Save as draft Button

[gmanto]

Hello, i wanna update a status column (Choice Column) on my sharepoint list, Basically, when the user select the 'Submit Button' the Status Column needs to change to 'Submitted' and if the user Select the 'Save as draft Button' needs to change as 'Draft' status, can someone helps me?

[FLMike · Accepted solution]

Hello,

Here is an Example.

SharePoint list with a new field called 'Service Status', Choice Column, Choices are Draft and Submitted. They are all blank. I will now update the record with with Draft or Submitted, based on the button I click.

Button 1: Submitted / OnSelect Event

Patch(TestList, LookUp(TestList, SerialNumber = "A123456"), 
    { 
        'Service Status': { Value: "Submitted"}
    }
)

Button 2: Draft / OnSelect Event

Patch(TestList, LookUp(TestList, SerialNumber = "A123456"), 
    { 
        'Service Status': { Value: "Draft"}
    }
)

I clicked Submitted and now you can see SharePoint is Updated.

PLEASE Note it may take up to 10 seconds or so before you see it change when you are refreshing to validate it did change.

Please select Resolved, if this helped you.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[gmanto]

Hello, thanks for the answer, actually the only problem is, if i use the LookUp function, its only change a register if i already have this register on my sharepoint list, for example: when u use (Serial Number = A123456) its only change the status of that particularly match, what i need is when the user click on the "Draft" or "Submit" Button, first, if the register not exist on the Sharepoint he create this register with the 'Status: Draft or Submit' and if the register already exists he update the Status. 

[FLMike]

hello.

In both cases you asked to know how to change the status not how to create a new record by searching if one already exists so this is a new requirement I’ll have to look at it when I get back to my desk.

You’re going to have to first search the list and if it’s not there yes then we can do what you want 
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey