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....
Hi PandoraGirl
You should be able to use column validation. Go to the lists settings open the column, towards the bottom there will be an option for column validation, add this formula =[Amount] <= 100 (change amount to your column name) and add the error message in the text box below
Now if your users enter a value higher than 100 the error message will appear
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?