web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Form with Sharepoint L...
Power Apps
Unanswered

Form with Sharepoint List data source form field validation problems

(0) ShareShare
ReportReport
Posted on by 124
I have built a Power Apps application with the form which has a Sharepoint list as a data source. According to this article:
 
" ..If the submission fails, the Error property contains a user-friendly error message from the data source, explaining the problem. The ErrorKind property is set appropriately, depending on the issue, and the OnFailure formula runs. .."
 
In the Sharepoint list there is a required column, in the PowerApp the corresponding field is not required. When that field is not completed there are no any errors thrown by PowerApp on the form submission.
 
onFailure:  Notify(Form1.Error, NotificationType.Error)
onSuccess: Notify("Success", Success)
 
In the Sharepoint list this record has been created but with the "Required info" in the item/field(column), which surprised me.  Sharepoint would never accept any empty required fields on the manual item creation attempt.
 
Is there any error handling procedure that addresses this issue?
 
 
 
 
 
Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Hi @lk777 

    On your edit form, is the required property of the card "true"?

  • lk777 Profile Picture
    124 on at

    It is set to False.

    I know that I can set it to true , this is my test of the error handling in PowerApps. I am new to this service.

     

    I have just tried a field validation with the phone field which has a column validation formula (in Sharepoint):

     

    =AND(LEN(Phone)=14,IF(ISERROR(FIND("(",Phone,1)),FALSE,(FIND("(",Phone)=1)),IF(ISERROR(FIND(")",Phone,5)),FALSE,(FIND(")",Phone,5)=5)),IF(ISERROR(FIND(" ",Phone,6)),FALSE,(FIND(" ",Phone,6)=6)),IF(ISERROR(FIND("-",Phone,10)),FALSE,(FIND("-",Phone,10)=10)),IF(ISERROR(1*CONCATENATE(MID(Phone,2,3),MID(Phone,7,3),MID(Phone,11,4))),FALSE,AND(1*CONCATENATE(MID(Phone,2,3),MID(Phone,7,3),MID(Phone,11,4))>1000000000,1*MID(Phone,2,3)<>911,1*MID(Phone,7,3)<>911,1*MID(Phone,7,3)<>555)))

     

    An error message has been thrown on the form submission (a wrong phone number formatting), like this "List data validation failed. clientRequestId: 0329e064-9dcc-4f4d-98ba-" It looks like this kind of validation works, though with no pointing to the field with the formatting issues.

     

    Probably that "required field" is not being processed by the data source (Sharepoint in my case).

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 914

#2
11manish Profile Picture

11manish 612

#3
Valantis Profile Picture

Valantis 604

Last 30 days Overall leaderboard