Unanswered

Save as Draft button with multiple forms

(1) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Muzammil_069506 292 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Halleduncan 40 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Halleduncan 40 on at

Like (1)

Report

Update: The following error comes with the above formula

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Halleduncan 40 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Halleduncan 40 on at

Like (1)

Report

Hello,

I am still getting an error:
Thanks.

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Halleduncan 40 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

Hi @Halleduncan please try restricting your patch in different approach may however that is how you patch a choice column in sharepoint in power apps choice column name:{Value:""})

Was this reply helpful? Yes No