Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Failing to insert new rows in a Sharepoint list

Hi !  

I have a Sharepoint list with a fair amount of fields.

None of them are required excecpt a Title and a Date which are respectively set with a text input and a classic date picker. Both of these controls have been added automatically by connecting my list as a datasource.  

BUT, when I'l trying to SubmitForm(myFormThatWontWork!) I get the very annoying "An entry is required or has an invalid value" and sometimes a beautiful : "An error occured when trying to create a controller of type 'Sharepointlistdatatable'" or something very similar.  

I tried refreshing the datasource but had no effect.  


Has anyone experienced the same ?  Any thoughts about how to resolve this issue ?

Thanks !

Community Support
Community Support

Hi @PierreParmentie,


Do you mean when creating App automatically from SharePoint List, the create new record won't work?

Please check to see if any of the fields (Specially for the Title field) under your SharePoint list are configured with "Require that this column contains information" attribute, if one of them is set to none, the submitform would give the following error:

"An entry is required or has an invalid value. Please correct and try again."

Under the SharePoint List, try to create a new item, make a note about the columns that are marked with a asterisk, then check your Editform and make sure the columns marked with the asterisk are listed.





Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Thanks for the answer. 

The issue was that I added a field to the form but set it to visible : false which gave me the error.

I still get the  "An error occured when trying to create a controller of type 'Sharepointlistdatatable'" though.

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (61,398)