Forum Discussion
PandoraGirl
Jun 05, 2024Copper Contributor
Create error message when Currency Field exceeds maximum
I have a SharePoint form that I want to set the maximum allowed value and have an error message appear before the form is saved telling the requester that the field exceeds the maximum allowed value....
PandoraGirl
Jun 05, 2024Copper Contributor
Josh,
Thank you for your help. I have used the column validation but I am not getting an error message in the form and they can still save the form unless I add the column maximum allowed value. Then they cannot save the form but they still don't get any kind of message telling them why the form won't save.
Thank you for your help. I have used the column validation but I am not getting an error message in the form and they can still save the form unless I add the column maximum allowed value. Then they cannot save the form but they still don't get any kind of message telling them why the form won't save.
Josh_Wickes
Jun 05, 2024Brass Contributor
Have you tried using g the column validation list settings rather than column settings?
- PandoraGirlJun 05, 2024Copper Contributor
I did try that and still couldn’t get an error message in the form. I can get it if I edit in grid view, but that is not how people enter their data.
- Josh_WickesJun 05, 2024Brass ContributorWhat kind of form are you using? Have you altered in power apps?
- PandoraGirlJun 06, 2024Copper ContributorI am using a standard SharePoint form. No alterations in Power Apps.