cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmistry
Post Prodigy
Post Prodigy

How to show validation message similar to SharePoint column validation

Hi,

 

I have a simple PowerApp build for a SharePoint new item form, below is how it looks in PowerApp.

 

Powerapp.PNG

 

Below is how sharepoint form looks.

Capture.PNG

I am using SP column validation for StartDate, end date and holiday worked date fields. Start Date and End date should be only saturday or sunday dates not weekday dates. Below are the validation formulas.

 

StartDate: =OR(AND(NOT(ISBLANK([Start Date])),WEEKDAY([Start Date],2)=6),WEEKDAY([Start Date],2)=7)

End Date: =OR(AND(NOT(ISBLANK([End Date])),WEEKDAY([End Date],2)=6),WEEKDAY([End Date],2)=7)

Holiday Worked  =OR([Holiday Worked]=DATEVALUE("9/3/2018"),[Holiday Worked]=DATEVALUE("10/8/2018"),[Holiday Worked] =DATEVALUE("11/22/2018"),[Holiday Worked]=DATEVALUE("11/23/2018"),[Holiday Worked]=DATEVALUE("12/24/2018"),[Holiday Worked]=DATEVALUE("12/25/2018"),[Holiday Worked]=DATEVALUE("12/26/2018"),[Holiday Worked]=DATEVALUE("7/4/2018"),[Holiday Worked]=DATEVALUE("5/28/2018"),[Holiday Worked]=DATEVALUE("2/19/2018"),[Holiday Worked]=DATEVALUE("1/15/2018"),[Holiday Worked]=DATEVALUE("1/1/2018"),[Holiday Worked]=DATEVALUE("1/1/2019"),[Holiday Worked]=DATEVALUE("1/21/2019"),[Holiday Worked]=DATEVALUE("2/18/2019"),[Holiday Worked]=DATEVALUE("5/27/2019"),[Holiday Worked]=DATEVALUE("7/4/2019"),[Holiday Worked]=DATEVALUE("9/2/2019"),[Holiday Worked]=DATEVALUE("10/14/2019"),[Holiday Worked]=DATEVALUE("11/28/2019"),[Holiday Worked]=DATEVALUE("11/29/2019"),[Holiday Worked]=DATEVALUE("12/24/2019"),[Holiday Worked]=DATEVALUE("12/25/2019"),[Holiday Worked]=DATEVALUE("12/26/2019"),[Holiday Worked]="")

 

You can see how SharePoint form shows validation message when incorrect date value is populated. So I would like to implement similar in PowerApps form, currently if I populate incorrect date values in PowerApp, it shows error message on submit click as 'SP column validation does not match etc' but instead I would like to show field specific validation in powerapp so if someone can help, i would appreciate.

 

Thanks in advance.

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,258)