Forum Discussion
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....
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.
Have you tried using g the column validation list settings rather than column settings?
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.
- What kind of form are you using? Have you altered in power apps?
- I am using a standard SharePoint form. No alterations in Power Apps.