Answered

List data validation failed with no required fields

(0) Share

Report

Posted on by Power_Automater

351

I have set all of the fields in a SharePoint list to not required and then in my Power App I have created two screens with different fields from this list and manually set them as required inside the app. Because they are set as not required in the list I would assume you should be able to submit these from each screen. The first screen works fine, but the second gives the below validation error when submitting. The only difference between the fields on the first screen is that they have some validation settings set, so could these fields be causing this even though they are set as not required in the list?

Error: The requested operation is invalid. List data validation failed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

Hi @Power_Automater ,

SharePoint list column validation will cause this issue, no matter whether this column is required. If you do need validation settings for those columns, you will have to do validation in your App as well.

Please refer to below thread, which introduces one way to validate in Edit form of an App:

Solved: PowerApps form errors when SharePoint list has Col... - Power Platform Community (microsoft.com)

Best regards,

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report

Thank you for that. So if I remove the validation from my SP List and instead add it to the field in Power Apps and set this field to required in Power Apps only, when submitting the form on a screen that doesn't have this required validated field it won't prevent the submission anymore like it is doing now?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Power_Automater ,

You are correct. Actually, it is always more recommended that set settings from in the App if it's possible.

Best regards,

Was this reply helpful? Yes No