Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

@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 at

Like (0)

Report
Copy link

Link copied!

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