Unanswered

How to stay on the same form even after submitting the form in SharePoint List.

Like (0) Share

Report

Posted on 19 Aug 2022 09:53:04 by Community Power Pla...

Hi All,

I've a PowerApps form and a customized submit button, so I'm not using OOO submit button so after filling details in the form when I click on submit so it should save the data in the SharePoint List without closing the form.
As by default SubmitForm() closes the form, so need to stop that from happening.

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on 19 Aug 2022 at 10:01:41

Like (0)

Report

Re: How to stay on the same form even after submitting the form in SharePoint List.

Hi,
To resolve this issue you will have to click on your SharePointForm1 control and go to OnSuccess property
Remove RequestHide() from the formula that is written over there
i think it should work
if you want to add any other code like Navigate(ScreeName) you can do that here

Was this reply helpful? Yes No
Community Power Pla... on 22 Aug 2022 at 05:18:18

Like (0)

Report

Re: How to stay on the same form even after submitting the form in SharePoint List.

Thanks @NandiniBhagya20 for your reply, I tried this and it's working though after submitting I wanted to display values which I filled, so it shows some random values from other items not the current values which I filled, where am I going wrong?

Was this reply helpful? Yes No
vish3027 434 on 22 Aug 2022 at 05:56:15

Like (0)

Report

Re: How to stay on the same form even after submitting the form in SharePoint List.

@Anonymous use form.lastsubmit to get last submitted record. You need update items property of form with lastsubmit also you might need to change form mode from New to Edit

If you have any other code Items property of form then you need to work on that so you can set form.Last submit

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on 22 Aug 2022 at 08:48:40

Like (0)

Report

Re: How to stay on the same form even after submitting the form in SharePoint List.

Hi,
You can make below changes -
On Item property of sharepointform1 you can add - If(varMode="New", LookUp(SPListName, ID = SharePointForm1.ID), <code that was there before in item property copy and paste it here>)
On select property of Submit button -
If(SharePointForm1.Mode=FormMode.New, Set(varMode,"New"), Set(varMode, "Else")); SubmitForm(SharePointForm1)
On Success property of SharePointForm1 you can remove ResetForm(Self) formula
I think by making above changes it should work

Was this reply helpful? Yes No