Save as Draft in Power Apps Form 

Thanks, Reza, always have take away after watching your amazing video : )

I never comment on these videos, but this one actually helped overcome the annoying Save and Submit dilemma and I wanted to thank you.

Another great use case! It is true that office workers seek out better ways of doing things and reduce the chances of work falling through the cracks. Saving as draft allows them to log entries with available data, even if incomplete and also serves as a reminder of pending activities too.

I love your content generally, but this is the first time that I was literally asked about this functionality yesterday and BOOM, Reza takes us to school. Thank you for just doing such great work.

Learning power from last 2 months from Reza.. Thanks for creating the channel..

what a great video ....I had exact requirements for a client for Save for draft but I know, how it is done with amazing your tips and techniques . I will use it for my next project Reza .....thank you so much for your high quality videos that is benefitting everyone ...🙌

Another great video Reza. I’m slowly getting through all your amazing videos. Many thanks.

Your all videos are very much useful and informative. Sometimes I am unable to see it on time whenever you post it, but I see it once as always...!! Thanks @Reza...!! 😊👍

Thank you, Raza! Amazing job as usual!!

What a fantastic technique Reza... 🙂🙂 Thanks a lot for sharing the knowledge.. !! 🙏🏻

HI Riza... thanks so much for yet another amazing video. I have one issue. When I save my form as draft it seems to work just fine. When I reopen the draft, make updates and try to save as draft again, all of my data disappears. Do you have any idea as to why this is happening?

Thanks for making this video Reza. My Engineering team would like me to create a complex form app where users will definitely benefit from being able to save their submission as a draft while they look up information for fields they might not know off the top of their head. Congratulations on surpassing 20,000 subscribers! Very well deserved.

Great video and an extremely useful function. I like the trick with setting the required property by variable. I typically set the submit button/icon to be disabled until all the needed fields are populated, but that formula can get pretty messy.

Thank you REZA this just gave me a promotion.

Thanks, Reza , it was helpful for me👍👍👍

Thank you for this Video Reza. Just a quick question. Is it possible to use this draft logic for multiple screen form control that uses a patch function on the end of the last screen?

This is a very general scenario we come across ! Thankyou for this informative video 😀 ! In the next video can you show us something about svg in powerapps !

I am getting an error for if condition if(locIsSubmit,{value:"Submitted"},{value:"Draft"}). Error - Expected Optionset value. I am using dataverse for teams. Could you please help.

Amazing use case... Thanks!

Help! The update formula doesnt work since im using dataverse choices instead of sharepoint

Hi Reza, how did you do the events screen? and navigate the draft/submit button to it? because in your coding for the buttons, you did not add the navigate function

I'm working on one scenario where users can fill out a form and save it as a draft. If a user fills out some data and saves it as a draft, then closes the app, the next time they open the application, the data they previously saved as a draft should be populated in the form automatically. Please help. .

For some reason, I can’t get it to work. I created the Save Draft and Submit buttons, and added the UpdateContext to each. My problem is when I try to use If(locIsSubmit,{Value: “Active”},{Value: “Inactive”}) function, it tells me I have an error. In my Choices column, I give the choices “Active” or “Inactive”. The error is “Expected OptionsSetValue value.” Not sure what to do in this case. I’m using a Dataverse table.

But using this method, the user is not shown which are the mandatory field on the screen unless he clicks on submit button. Any workaround for this?

How to use multiple screen ? Suppose i have done save as draft in 3 screen, when i open the record, i would like to navigate 3rd screen. Is any possibility?

Reza how are you handing Navigate after the form is submitted? You don't seem to have it set on the OnSelect property of either of the buttons. I have Navigate(screenSuccess) on the OnSelect property of the submit button. But this always navigates even if not all required fields are complete, and the user misses the required field errors

Hi Reza- Can you please show the formula for the Information Icon in the Gallery?. How do you get it to show the form with "part" information filled in if it was submitted as draft previously?

I created a Multiple Screen Form Control in Power Apps then added the save as draft. After saving a draft on the first page, clicking the arrow to move to the next page leads to the subsequent page, and when I submit the form, it does so without prompting me to fill in the required fields. Is my Patch correct? Submit Button Code - UpdateContext({locIsSubmit:true}); If(locIsSubmit, Patch('Sh Self App',varSharePickData,ShForm1.Updates, ShForm2.Updates, ShForm3.Updates);

always able to learn new things , thank you

Amazing video, super informative. I always know what to do after watching your videos! I have a multi screen form (created after watching your video on it) & want to add the save button on each page. Do I need to patch the save buttons?

Hi, I am currently working on the same functionality but I am stuck at sending the drafted data back to the form once we click on the edit button. Could you please help with how to get drafted fields back on to the form. Thanks.

Hi Reza, amazing instructional video as always! Thank you so much for your educational content! I have a question pertaining to this video. A little context: I have a form which uses gallery checkbox control, and collections to list out the ticked/selected checkboxes (as per your other checkbox video). I was able to implement the save feature as discussed in this video for the other data cards/controls, however, when I edit a saved entry, the same checkboxes do not show as checked (naturally, since the collection is not linked to the record which is being edited). Could you please suggest a way in which if i edit the form for a "Draft" entry, it would show the same checkboxes as checked when I saved as draft. Thank you so much!

Hi..I have a question here... can we save the powerapp New form as a file in SharePoint? Like we save InfoPath form as file..

Thank Reza

Thanks for the information. How to Save the form in three different types? In my case, I need to save the form as: Draft, Review and Submit.

The choices doesnt work for me since im using dataverse instead of sharepoint

Is there any way we can let users only edit the draft? Not allowed to edit the completed one?

Thanks Reza, great video. On my app, the "Title" field is the only mandatory field required to be able to save as draft and then every field on the form is mandatory to be able to Submit the form. However, I would like to keep the display mode of the "Submit" button Disabled until the form is valid, is this possible? .Currently, the display mode of the submit button changes to Edit as soon as the Title field has been populated. (Formula used on Submit button is "If(SharePointForm1.Valid, DisplayMode.Edit, DisplayMode.Disabled)". Thanks!

I am currently creating a project planner app for my team, I want to know if there is a way to integrate office timeline from Powerpoint, with a canvas PowerApp. Initially the idea is to get the office timeline template on powerapps. Your input or suggestions would really be appreciated. Thank you.

Hi ,..Thanks For this Amazing Video Reza..Can I Know what is formula you have used to view drafts information ..I mean formula in "Information" icon

Thanks Reza, Great Video! Does this also work with patch-function? I save the Draft-data with the submit function-button in one sharepoint-list and send the completed data with a patch function-button to another sharepoint-list where a power automate approval- workflow starts when a new element is generated. Even if I put the UpdateContext({locIsSubmit:true}) to the patch-function it generates an entry even though the required field is empty. Is there a way this could work?

great video, quick check, what if we have more than 2 status such as approved, submitted, draft and cancelled?

Hi Reza - Thanks for this - Just what i am looking for. I am though, having issues with the solution. Hope you find this comment and help me out. You are an absolute legend in this space .. GOAT !. I am using the local variable in a PATCH formula. That is , i am trying to patch data to a SP list. For some reason i do not get the 'errors' "field required" at all once i use the Submit button... Would really appreciate a helpful comment.... 😬

Wow! Hi Reza can you help me with the Draft items and go back to the draft items to continue working on it? if you have a link on this please this would be a great help!

Hi Reza thanks for creating amazing video it really helps a lot. I have a scenario where the user will submit its claim. I am giving an option to the user before submitting the form user can save its claim as a draft and later on the user can submit the form. As soon as a user submits its form an approval email is to be triggered through power automate and approval will be sent to the authorized person. Depending upon the authorized person behavior action to be changed. Suppose if the authorized person rejects the claim then the status of "Submitted" to be changed to "Draft" and the user can do changes and again submit for approval. If the claim is approved user will get intimation. I tried using trigger When an item is created or modified (Sharepoint) and added one column as approval status and if the claim is approved then first it will update the list (approval status to Approved) then email to the user but my flow went into an infinite loop as I chose (When an item is created or modified) as a trigger.

Hi Reza! I really loved your video! always precise and easy to understand! I have a question what if I have 2 screens with 2 different SharePoint in which the 1st screen contains basic information while the 2nd screen contains detailed information. The scenario is that the user can create multiple request claims (on 2nd screen) but it will still be under one request in the first screen! How can I do this? Since currently if the same user has to submit a request multiple times they have to also create their basic info multiple times as well!

Hi, Is there any way to get file path by giving content from share point by using power automate . Content as a text from power virtual agent. Could you please help me on this if is possible.

In this button, how are you navigating to different screen

How do you make the title have that curve on the form screens?

Hi Reza, can you tell me how to create a "Save As Draft" button like this when an app has forms across multiple screens? I can't get it to work, creates two lines in the SharePoint List. Thanks for your amazing tutorials, really helpful!

How do I write the formula for a lookup type of column instead of a choices one?

Is the DefaultMode of the form : Edit or New

can you pls guid me how to migrate power app from one environment to another. And we will face any challenges?

Hi