Showing results for 
Search instead for 
Did you mean: 
New Member

save as draft and edit form

Hi everyone, I am trying to build a form that allows users to save, edit the draft and also submit once the form has been completed. This is my first time trying to use powerapps, and would really appreciate if someone can please help me out. 


I created a home screen to show the progress (see below). However, whenever I go back to edit the 'save as draft' form, a new form starts and carries some information from the last form.  If I keep using the save function, more records will be created as drafts. Also when I click 'start a new form' it also shows some information from the previous form record.


  • The code for 'save' is " UpdateContext({locIsSubmit:false}); SubmitForm(Form1); "
  • The code for submit is " UpdateContext({locIsSubmit:true});SubmitForm(Form1)"
  • I have a status row in my form, the update code for it is "If(locIsSubmit,{Value:"Submitted"},{Value:"Draft"})"
  • The code I used for 'start new form' is ResetForm(Form1);NewForm(Form1);Navigate(form,None)'.

Is there a better way to do this type of form on powerapps? Looking forward to having your help. 


Screen Shot 2021-10-01 at 1.25.58 pm.png

Super User
Super User

Hi @jaz_12 


I believe the issue here is the order of execution. When you click on Save or Submit It sets the variable and submits the form. Data card (Status row update) may not be updated before submit form operation happens.


No guarantee of the order of operation. To solve this, we have 2 options


Option 1: Submit the form and Set the status OnSuccess property of Form

  • On Save OnSelect --> UpdateContext({locIsSubmit:false}); SubmitForm(Form1);
  • Set OnSuccess Property of Form to
        LookUp(Datasource, ID = Form.LastSubmit.ID),
            Status : If(locIsSubmit,{Value:"Submitted"},{Value:"Draft"})

Option 2: Use Patch command for each button


For example, OnSelect of Save button to

        EditForm1.Mode = FormMode.New,
            ID = Gallery.Selected.ID
            Status : {Value:"Draft"},
//Other fields


The same goes for submit button

Status : {Value:"Submitted"},
Super User
Super User

Hi @jaz_12 


Please let us know if anything needs on your post. We can help with this.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.


Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,793)