Solved: Patch new record and update existing record Whenever user submit a form (this form will store the record in another list, not in this list), PowerApps will check whether the form is submitted under which category and update "1" in this list (above picture)
Change The Values In A Record (Patch) - Matthew Devaney Change the value in a cell code Output collection: mySolution33b (update multiple values for ID 1003) Solution code: Change multiple values in a row code mySolution33b, LookUp(mySolution33b,ID=1003), {Name: "Surface Laptop", Quantity: 33}
Tracking Status Changes in PowerApp and SharePoint List There are two ways - one is already there in that SharePoint maintains a Version history and you can also get it in Power Apps with a bit of complexity involved as per this article