Unanswered

New Form is saved empty on first submission

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am creating a Power Apps form with New, Edit, View forms. When clicking Save on New Form the form is saved empty, no values are saved. When I create another new form, enter values and Save, the form is saved properly.

When I refresh the page and create a New Form, fill it in and Save - it is saved empty again.

I am using the formulas from the following article : https://powerapps.microsoft.com/en-us/blog/separate-custom-forms/ . They used to work before.

I found out that if I use only the first part of onSave formula If(SharePointFormMode="CreateForm", SubmitForm(CreateItemForm)) Save on New form works properly, but I need it to work on Edit form as well, so it's not a solution.

I created a new list in the site, as well as a new list in a completely different site with only two columns just to test Save on New form and the issue occurs every time. It's been a week since the issue occurs.

Please, advise.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Based on the blog that you mentioned, I have made a test on my side, and don't have the issue that you mentioned.

On your side, please take a try with the following workaround:

Set the OnNew property of the SharePointIntegration control to following:

Refresh('YourSPList'); /* <-- Add this formula */
Set(SharePointFormMode, "CreateForm");
NewForm(CreateItemForm);
Navigate(CreateScreen, ScreenTransition.None)

Set the OnEdit property of the SharePointIntegration control to following:

Refresh('YourSPList'); /* <-- Add this formula */
Set(SharePointFormMode, "EditForm");
EditForm(EditItemForm);
Navigate(EditScreen, ScreenTransition.None)

Set the OnView property of the SharePointIntegration control to following:

Refresh('YourSPList'); /* <-- Add this formula */
Set(SharePointFormMode, "ShowForm");
ViewForm(ShowItemForm);
Navigate(ShowScreen, ScreenTransition.None)

Modify the formula within the OnSave property of the SharePointIntegration control to following:

If( SharePointFormMode = "CreateForm", SubmitForm(CreateItemForm), SharePointFormMode = "EditForm", SubmitForm(EditItemForm) )

please take a try with above solution I provided, then check if the issue is solved.

If the issue still exists, please consider take a try to clear cache of your browser, and then remove the custom form from your SP list, and re-create a new custom form for it, then take a try with above solution I provided, check if the issue still exists.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for your answer. I tried the steps provided, unfortunatelly the issue remains.

I have tried different browsers - IE, Chrome, Private Window in IE, Incognito in Chrome; Even if I open the site,create a new form and try to save it from a different computer, the same issue appears.

I created a new list and columns in a completely different SP site, I created a new Power Apps form, duplicated the screens two times - to have View and Edit screen, added your formulas in SharePointIntegration - > Advanced tab - and I have the same issue.

Do you have any idea what can be causing the issue and if I am missing something?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

We are still experiencing the issue mentioned above. It occurs on several sites already. Please, advise.

Was this reply helpful? Yes No