Unable to see fail error while submitting A SharePoint list form customized power apps

Question

Hi Everyone

I have a SharePoint Online list (Modern Experience) under that list I have some columns. Among all, there are 3 columns two are "date and time" type column and one is "calculated" column.

So one column name is "start date" another column name is "end date" and 3rd column name is "total number of days" .

This list is for the leave request application, so if I will go on leave from 3rd June to 5th of June and if there is no weekend (Saturday-Sunday)in between that than the "total number of days" would be 3 which means I will start my leave on 3rd and my leave will end on 5th then I will be in office on 6th, so to achieve this I have made some validation.

Column Validations are :
Start Date formula is =[Start Date]>=TODAY() (this means user will not be able to select any past date) 

End Date formula is =[End Date]>=TODAY()(this means user will not be able to select any past date) ****Total number of days =IF(OR(ISBLANK(Start Date ),ISBLANK([End Date ])),"",IF([End Date ]=Start Date ,1,[End Date ]-Start Date +1-(INT(([End Date ]-Start Date +1+MOD(WEEKDAY(Start Date )-1,7)+1)/7)*2)-IF(OR(WEEKDAY(Start Date )=7,WEEKDAY(Start Date )=1),1,0)-IF(OR(WEEKDAY([End Date ])=7,WEEKDAY([End Date ])=1),1,0))).

I have done a list validation also :=[End Date]>=Start Date. (this means and it will always be greater than start date)

As we know that I have put these many validations And all these fields are mandatory so whenever user is trying to submit the form without filling the value or without filling the appropriate value it is showing the error message over the former screen only (PFA). [Working]

Similarly when I have customized the same form into the PowerApps it is not displaying the error message properly it is showing something related to patch functioning (PFA). [Not Working]

Error for not selecting mandatory fields in SPO List Default form: PFA

Error for not selecting proper value in validated columns (List validation): PFA

https://learn-attachment.microsoft.com/api/attachments/df67e84e-eb5c-4083-916e-88556f5ab92a?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/b6d0aa06-ce27-4c82-bf66-3d9edc39b56f?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

and now I have customized the same form in power apps and published the same it is saving the data in the same list but while occurring any error it is not displaying the proper error message,
it is showing error one : "Network error when using Patch function: The requested operation is invalid."
and error two : "The requested operation is invalid. Server Response: Leave Rqst App For Flow failed: List data validation failed. clientRequestId: b********65*****80 serviceRequestId: ba**888885c********80".

So I'm seeking help from any one of you to please tell me how to replace these errors messages And to display the exact error message which I am displaying on SharePoint form.

One more thing I want to understand that is it possible to remove OK button from date selection calendar page (PFA) .

And another question is, if I will select 9 June as a start date so can we have an option to grey out the end date section for all the dates before 9 June. So user have to select the end date which is equal to or greater than 9 June.

Please help me out with this.

Answer 1

Dear respected Admin Rishu,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I’m sorry you’re having a problem and for the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description, it seems like you're facing a issues with your custom PowerApps form. The error messages you're seeing are likely if the data doesn't pass the list's validation rules, the patch function fails and you get an error message.

Since you are using PowerApps form and to handle the validation and error messages properly in PowerApps, to avoid any incorrect information from our side, we’ll suggest you post in Power App Community for expert assistance. This is a specific channel related with Power App.

The reason I ask you to post a new thread is that in Answers forum, we have limited resources and very little knowledge about Power App and in Power App Community, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad