Failing to insert new rows in a Sharepoint list

(0) Share

Report

Posted on by PierreParmentie

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 !

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-micsh-msft on at

Like (1)

Report

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.

Regards

Was this reply helpful? Yes No
PierreParmentie 13 on at

Like (0)

Report

Hey,

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.

Was this reply helpful? Yes No
Hima556 3 on at

Like (0)

Report

I found the solution thanks to v-micsh-msft

This is an old post but the error still exist in 2023, however, if you have this error (network error when using patch function: the requested operation is invalid) with power app, which is Error Number 8, Follow this steps:

1. PowerApp: Make sure that all required column is filled in during patch, don't miss any single one if you not sure go to sharepoint list > list setting > columns.
2. SharePoint list: Make sure that all the values is matching with the column content type, start with the columns that include dates <the most source of errors>.
3.SharePoint list: Make sure that all the calculation columns is valid (check it one by one).

Remember don't make all the steps one time try one by one then check if work, use simple code to check like Patch(Database, Defaults(Database), {Title:"Testing"} )

Also check what v-micsh-msft post here earlier .

Screenshot 2023-1...

Was this reply helpful? Yes No