SubmitForm on NewForm from SharePoint Customize Forms Not Working

%3CLINGO-SUB%20id%3D%22lingo-sub-1582730%22%20slang%3D%22en-US%22%3ESubmitForm%20on%20NewForm%20from%20SharePoint%20Customize%20Forms%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582730%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20used%20the%20Customize%20Forms%20from%20a%20SharePoint%20list%20to%20create%20PowerApps%20NewForm%2C%20ViewForm%20and%20EditForm.%26nbsp%3B%20I've%20added%20a%20%22SAVE%22%20button%20on%20both%20the%20NewForm%20and%20EditForm%20to%20make%20it%20easier%20for%20users%20to%20save%20(they%20could%20use%20the%20%22Save%20All%22%20from%20SharePoint%2C%20but%20it's%20not%20as%20easy%20to%20see.%26nbsp%3B%20I've%20done%20this%20same%20setup%20on%20another%20SharePoint%20list%2C%20and%20that%20list%20is%20working%20great%2C%20but%20this%20new%20list%20%22Customer%20Requested%20Documents%20and%20Surveys%22%20is%20not%20saving%20ONLY%20on%20the%20NewForm.%26nbsp%3B%20Neither%20%22SAVE%22%20button%20OR%20the%20SharePoint%20%22Save%22%20is%20working%20-%20clicking%20the%20%22SAVE%22%20buttons%20I've%20added%20acts%20like%20it%20is%20saving%2C%20but%20no%20new%20items%20are%20being%20added%20to%20the%20SharePoint%20list.%26nbsp%3B%20Clicking%20the%20SharePoint%20%22Save%22%20doesn't%20do%20anything.%26nbsp%3B%20Again%2C%20the%20%22SAVE%22%20buttons%20work%20on%20the%20EditForm%20just%20fine%2C%20and%20those%20buttons%20are%20configured%20the%20same%20way%20on%20the%20NewForm%20but%20it%20doesn't%20work%20on%20that%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20config%20screenshots%20attached%20-%20there%20is%20nothing%20I%20can%20see%20that%20would%20cause%20this%20to%20not%20work.%26nbsp%3B%20It's%20pretty%20straight%20forward%2C%20but%20I'm%20stumped.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1582730%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1583471%22%20slang%3D%22en-US%22%3ERe%3A%20SubmitForm%20on%20NewForm%20from%20SharePoint%20Customize%20Forms%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583471%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20gut%20feeling%20here%20thinks%20you%20have%20some%20kind%20of%20error%20happening.%20Have%20you%20customized%20and%20defaults%20on%20form%20fields%20or%20update%20properties%20on%20any%20cards%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3EUsually%20if%20edit%20is%20working%20and%20new%20isn%E2%80%99t.%20It%E2%80%99s%20because%20you%20might%20be%20referencing%20a%20ThisItem.ID%20and%20on%20a%20new%20form%20you%20don%E2%80%99t%20have%20that%20ID%20yet%20because%20the%20Item%20doesn%E2%80%99t%20exist%20in%20SP%20and%20doesn%E2%80%99t%20have%20an%20ID%20till%20it%E2%80%99s%20submitted.%20You%20have%20to%20work%20around%20it%20differently%20if%20that%20is%20the%20case%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585198%22%20slang%3D%22en-US%22%3ERe%3A%20SubmitForm%20on%20NewForm%20from%20SharePoint%20Customize%20Forms%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B-%20this%20sounded%20possible%2C%20but%20in%20checking%20all%20of%20the%20datacards%20added%20to%20the%20NewForm%2C%20none%20have%20%22ThisItem.ID%22%20-%20each%20reference%20%22ThisItem%22%20and%20their%20respective%20fields.%26nbsp%3B%20The%20DueDate%20datacard%20was%20customized%20so%20that%20the%20default%20date%20is%20Today()%2B14%20-%20see%20attached%20screenshots%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585243%22%20slang%3D%22en-US%22%3ERe%3A%20SubmitForm%20on%20NewForm%20from%20SharePoint%20Customize%20Forms%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585243%22%20slang%3D%22en-US%22%3EGo%20to%20the%20form%20itself%2C%20and%20onsuccess%2Fonfailed%20put%20in%20a%20set(varSubmit%2C%22Success%22)%20and%20%22Failed%22%20for%20each%2C%20could%20even%20set(varSubmit%2C%22Not%20submitted%22)%20on%20app%20load%2C%20then%20stick%20a%20label%20on%20your%20screen%20after%20hitting%20save%20and%20for%20the%20text%20put%20in%20varSubmit.%20See%20what%20is%20happening%20there.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585705%22%20slang%3D%22en-US%22%3ERe%3A%20SubmitForm%20on%20NewForm%20from%20SharePoint%20Customize%20Forms%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585705%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B-%20I%20feel%20really%20silly%2C%20but%20I%20found%20the%20problem%3A%20there%20was%20simply%20a%20required%20field%20that%20was%20on%20the%20view%20and%20edit%20forms%20that%20was%20NOT%20on%20the%20new%20form.%26nbsp%3B%20(facepalm)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20to%20waste%20your%20time%20on%20this%20one%2C%20but%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585706%22%20slang%3D%22en-US%22%3ERe%3A%20SubmitForm%20on%20NewForm%20from%20SharePoint%20Customize%20Forms%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585706%22%20slang%3D%22en-US%22%3EI%20was%20gonna%20ask%20that%20last%20reply%20but%20figured%20you%20had%20checked%20that%20%3B).%20Glad%20to%20hear%20you%20got%20it.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I've used the Customize Forms from a SharePoint list to create PowerApps NewForm, ViewForm and EditForm.  I've added a "SAVE" button on both the NewForm and EditForm to make it easier for users to save (they could use the "Save All" from SharePoint, but it's not as easy to see.  I've done this same setup on another SharePoint list, and that list is working great, but this new list "Customer Requested Documents and Surveys" is not saving ONLY on the NewForm.  Neither "SAVE" button OR the SharePoint "Save" is working - clicking the "SAVE" buttons I've added acts like it is saving, but no new items are being added to the SharePoint list.  Clicking the SharePoint "Save" doesn't do anything.  Again, the "SAVE" buttons work on the EditForm just fine, and those buttons are configured the same way on the NewForm but it doesn't work on that form.

 

See config screenshots attached - there is nothing I can see that would cause this to not work.  It's pretty straight forward, but I'm stumped.

5 Replies
Highlighted

My gut feeling here thinks you have some kind of error happening. Have you customized and defaults on form fields or update properties on any cards?

Usually if edit is working and new isn’t. It’s because you might be referencing a ThisItem.ID and on a new form you don’t have that ID yet because the Item doesn’t exist in SP and doesn’t have an ID till it’s submitted. You have to work around it differently if that is the case here?

Highlighted

@Chris Webb - this sounded possible, but in checking all of the datacards added to the NewForm, none have "ThisItem.ID" - each reference "ThisItem" and their respective fields.  The DueDate datacard was customized so that the default date is Today()+14 - see attached screenshots

Highlighted
Go to the form itself, and onsuccess/onfailed put in a set(varSubmit,"Success") and "Failed" for each, could even set(varSubmit,"Not submitted") on app load, then stick a label on your screen after hitting save and for the text put in varSubmit. See what is happening there.
Highlighted

@Chris Webb - I feel really silly, but I found the problem: there was simply a required field that was on the view and edit forms that was NOT on the new form.  (facepalm)

 

Sorry to waste your time on this one, but thank you!

Highlighted
I was gonna ask that last reply but figured you had checked that ;). Glad to hear you got it.