Good afternoon,
I hope you are all doing well. I am having an issue with a custom form I built connected to a SharePoint List.
The Problem: From the SharePoint (SP) List, when you click the "New" button it opens the PowerApps form, like it is supposed to. Once I add the information into the form and click the "SAVE" button, nothing happens. When I test the New Entry Form (FormNew) in PowerApps in the workspace the form saves the data to the SP List, like it is supposed, but if I try testing the FormNew in the preview area the FormNew does not load correctly. I get a message saying "getting the information", but the fields never load into the FormNew.
Solutions I have Tried: I have been scouring the Internet for potential fixes to this problem and have not found one that has worked, so far. In one document I found, they suggested completely removing the existing FormNew and completely start from scratch, which I have done, but I still have the same problem. I have tried building a brand new app and connecting to the SP List to see if that resolves the problem, which I did not. I have even deleted the entire SP List and rebuilt the forms completely and I still have the same issue. Everything works perfectly on the FormEdit. What is puzzling is that everything was working perfectly with the PowerApps forms built from the SP List originally, but once one of my end-users tried saving a "New Entry", it would not save.
I am reaching out, because I am running out of possible ideas how to fix the problem with the New Form "SAVE" button and am hoping that someone on this community could assist me. I would appreciate any assistance you could provide me with this.
Hello,
I am adding this as a possible solution for others that are searching for a same/similar issue.
I had an issue where the save button was not working, it would just reappear and do nothing. The problem was that someone changed a column to "Enforce Unique Values" and we had a field that had defaulted to "in progress" so it would not let any new items get added since there was already a item on the list with that same value. Had to click through each field and verify that they were not set to enforce unique values.
Hi @JosephRJohnson4 ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @JosephRJohnson4 ,
That code will simply submit the form - a new form by default does not contain any information (it is waiting for new input). As I mentioned, itis better to simply have one form and OnNew put NewForm(FormEdit)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Good morning, sir
Thank you for responding to my question. I hope you are doing well. I have attached (2) screenshots of the PowerApps form I am having a problem with. The first picture is the Submit Button Code used to add the new data to the SP List. The other picture shows the DefaultMode you had asked about. Each form attached to the SP List has its own Screen and Form with the following names: 1) ScreenNew/FormNew, and 2) ScreenEdit/FormEdit. I hope this additional information helps.
Hi @JosephRJohnson4 ,
It is probably better to use one form for new, edit and view and just change the FormMode, however what is the DefaultMode of the form and what code do you use to enter and save it?
WarrenBelz
146,587
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional