Save as Draft button with multiple forms

[Halleduncan]

Hello,

I am trying to create a "Save as Draft" button for my app. I'm stuck with how to do this when my app consists of multiple forms. I will attach my current formula that seems to only work when in use for one form.

Any help would be greatly appreciated, thanks.

[Muzammil_069506]

Hi @Halleduncan , could you please provide more details? If multiple forms are connected to different data sources, then while submitting form1, on its successful submission, submit form2. On the success of form2, patch form3 iteratively, one after the other, in order to have a ‘Save as Draft’ option. I’m assuming that if these are different tables, you have established a relationship between them. In the main table/list, have a column for ‘Internal Status’. While patching, update the status as Saved as Draft. Based on this, you should be able to save as a draft and submit.

Please let me know if you need further assistance.  If the information provided is helpful to you, please give kudos or accept it as a solution.

[Halleduncan]

Hello,

My form all come from the same data source of a SharePoint list, the questions have just been split across different screens and forms. I have tried using the formula below using a patch function, but it doesn't seem to be working. I don't have an option for "Draft" in my status column in my SharePoint list so assume I should add one?

Thanks.

[Halleduncan]

Update: The following error comes with the above formula

[Muzammil_069506]

Hi @Halleduncan  yes add a choice column in your share point list with one of the option as save as draft  and rest status as per your need and then patch that column value as save as draft whenever save as draft button is clicked  

[Halleduncan]

Hello,

I have created a "Draft" button in my sharepoint list but I am still getting the same error as above. Is there something else that needs included with my patch function as well as 

{Status:"Draft"})

Thanks

[Muzammil_069506]

Hello @Halleduncan  it should be 

Patch(Datsource,condition,{Status" {Value: "Draft"}}) 

 If the information provided is helpful to you, please give kudos or accept it as a solution.

[Halleduncan]

Hello,

I am still getting an error:

Thanks.

[Muzammil_069506]

Hi @Halleduncan can you hover and tell what exactly the error you're getting and try refreshing DataSource cause

[Halleduncan]

Hello,

In Value I am getting this error:

And on the second part I am getting this error:

So I think its the same issue with both parts.

Thanks.