Others

Fix Missing SharePoint Validation Messages in Power Apps Forms

Phi Hung Vo Sep 30, 2026 868 views

Question details

Users encounter generic Patch errors instead of specific SharePoint validation messages when submitting data.

Fixing Missing SharePoint Validation Messages in Power Apps Forms

Product: Power Apps / SharePoint
Device & OS: not provided
Scenario: Submitting a customized Power Apps form connected to a SharePoint list that contains required fields, date validation, and calculated columns.
Observed behavior: The form throws generic Patch function errors and fails to display the detailed validation messages originally configured in the SharePoint list.

Before you start

Verify your SharePoint list settings to identify which specific columns have strict validation rules or are set as required.

Solution 1Recommended

Identify Data Violations and Consult the Power Apps Community

Since customized Power Apps bypass native SharePoint validation UI, you must handle Patch function errors manually or seek expert syntax guidance.

When you customize a SharePoint form using Power Apps, the native SharePoint validation interface is replaced. If the submitted data does not satisfy the SharePoint list validation rules, the Power Apps Patch function simply fails and returns a generic error.

To properly extract and display these messages, custom error handling formulas must be written.

Review SharePoint List Validation

Open your SharePoint list settings and check the 'Validation settings', as well as individual column configurations, to note all required fields and date-picker constraints.

Analyze the Patch Function

In your Power Apps studio, inspect the button or control triggering the Patch function. Ensure it is not attempting to write data to calculated columns (like total-days), which are read-only and will cause submission failures.

Engage the Power Apps Community

Because extracting specific SharePoint messages requires complex formula logic (often using the Errors() function), post your specific form setup and date-picker behavior in the Microsoft Power Apps Community for specialist assistance.

Identify Data Violations and Consult the Power Apps Community

Custom Error Handling Requirement: By default, Power Apps does not automatically map SharePoint backend validation text to frontend form labels without explicit custom formulas.

Free Microsoft Office alternative

Simplify Your Data Management with WPS Office

While complex SharePoint and Power Apps integrations require heavy customization and formula troubleshooting, WPS Office provides a streamlined, lightweight alternative for everyday spreadsheet and data validation tasks. Enjoy high compatibility with Microsoft Office formats without the complicated IT setup.

1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the setup file and follow the quick installation wizard to set up the software.
3. Manage Your Data: Open WPS Spreadsheet to easily set up data validation, drop-down lists, and required fields without needing external app integrations.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless data migration.Built-in spreadsheet data validation rules that are intuitive and require no complex coding.Free, lightweight, and incredibly fast to install on Windows, Mac, and mobile devices.Familiar user interface ensuring zero learning curve for users switching from Microsoft Office.

Frequently Asked Questions

Why does Power Apps show a generic error instead of my SharePoint validation message?

When using a customized Power Apps form, the native SharePoint user interface is bypassed. If a submission violates SharePoint's backend list rules, the Power Apps Patch function simply throws a generic data error unless you explicitly code the app to extract and display the SharePoint message.

Can I use the Errors() function in Power Apps to get the SharePoint message?

Yes, you can often use the Errors(DataSource) function to retrieve more specific data source errors. However, this requires adding custom formula logic to your submit button or the form's OnFailure property to route the text to an error label.

How do I handle calculated column errors in Power Apps?

Calculated columns are read-only and their values are generated by SharePoint after a record is saved. Ensure your Power Apps form does not try to Patch or update these columns directly, as attempting to write to them will cause a generic submission error.

Office Quick Solutions