Help stop the Save button from closing my form

[AdriaanOlivier]

Good day all,

I am sure this is an amateur hour question but that is what I am. I am busy with a pet project to streamline some reporting functions.

(Essentially I want to stop our people from saving technical support session info in OneNote or random Word documents that is not centralized).

In my pursuit I have created a list, it captures the basic data for a support session but then all the complex notes and screenshots will be captured in a word document. The possibilities of is just too endless to be able to create a single form to capture all possible scenarios so a word doc works. I have created the flow that will create the Word doc according to a template when a new list record is created. The Word doc is just a copy of a template and it saves it to a library and you can open it in Sharepoint or Teams etc while you have the Sharepoint list open in another screen.

Okay, deep breath... Now for my question, to create the Word doc, the out of form Save button has to be clicked. This closed the open form. I don't want it to close, I want to be able to continue working on that form without having to open it again?

In Powerapps I tried to change the Syntax of the OnSuccess formula in the SharePointForm1 properties to various things and combinations, (the default being ResetForm(SharePointForm1); RequestHide() ). If I remove the RequestHide() it works but the form defaults to the first item in the list.

I have spent a whole day searching for solutions and I can't find anything definitive. I would imagine this has been asked in the past but I can't find an answer.

Please help.

[jbrit2020]

Put NewForm(SharePointForm1) instead of ResetForm on the OnSuccess property

[AdriaanOlivier]

jbrit2020, thanks but no dice. When I press the save button, it does not close the form which it what I want, but it resets to a blank form which is what I guess the intention of the NewForm(SharePointForm1) command is.

After playing with it bit more I have the following in my arguments:

I am not sure if leaving the OnSuccess field blank is a good idea but changing the highlighted part of the argument in the item box from "First" to "Last" seems to work as I want.

If anybody can tell me if this will become an issue later on as the list grows it will be great.

Thanks

[v-bofeng-msft · Accepted solution]

Hi @AdriaanOlivier :

   Do you want to submit a custom form without closing it?

   I have tried many methods, as long as the SubmitForm() function is used, the RequestHide function will be triggered to close the form. This seems to be a built-in function and we cannot change it.

   To avoid this situation, I suggest you use Patch() instead of SubmitForm.For example:

1\Set the SharePointIntegration's OnSave Property to

If(
  IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
  Patch(ListA,Defaults(ListA),SharePointForm1.Updates),
  Patch(ListA,SharePointIntegration.Selected,SharePointForm1.Updates)
);/*ListA is my list*/
ResetForm(SharePointForm1)

The Result

We can find that:

• The form will not be closed immediately after clicking save
• The data in the list has actually been modified, but it will not be displayed immediately. You can hit "F5" to refresh the page to display the latest data

Best Regards,

Bof

[KScarb]

It can cause an issue in the following scenario:

1. User A saves a new item to the list and continues working in the item. Powerapps saves the item and resets the form with the Last item in the list which is the item User A just saved. (All good so far)
2. User B saves a new item to the list while User A is still working in their item. Powerapps saves the item and resets the form with the Last item in the list which is the item User B just saved. (Still good here)
3. User A saves new changes to their item. Powerapps saves the changes and resets the form with the Last item in the list which is the item User B saved. (User A is now editing User B's item)