I have a Sharepoint list that I have attempted to add list validation to. We are using the list version, not a form. 
To add a entry the user clicks new” and fills out the entries and submits.

I have a field “Whos Your Caller”. The choices for the field are Employee, Third Party, or Client. 

If Third Party or Client is selected, Then the field titled “Caller Name/Location/Contact” needs to be required. 

My research shows that the list validation formula should be 

=IF(OR([Who’s Your Caller?]=”Client”,[Who’s Your Caller?]=”Third Party”),IF(ISBLANK([Caller Name/Location/Contact]),FALSE,TRUE),TRUE)

When i test it, I select client and leave the Caller Name/Location field blank.  The list allows me to submit, with no error message. However after refreshing I get a error message stating “sync issues couldn’t upload new list item” (image of error below) . 

This only appears after submitting the list item and purposely not meeting the validation I set forth above. At that point the only option given is to delete the items or save it (which downloads a csv). IT still does not state what the error is (although I know) or allow correction of the entry. 

I would ideally like for the list to NOT allow to be submitted if the validation is not met. When they hit “Save” on the new list item, I want the error to pop up to advise that the field “Caller Name/Location/Contact” can not be left blank.

It appears I have the formula correct for the validation. But how do i get the error message to display on the list item entry itself?

I know how to accomplish this if I was using a form. I could use power apps to create an error message on the submit button. But since this is a list item not a form. Im not sure how to accomplish this. Any help would be appreciated. Thank you

​I have a Sharepoint list that I have attempted to add list validation to. We are using the list version, not a form. To add a entry the user clicks new” and fills out the entries and submits.  I have a field “Whos Your Caller”. The choices for the field are Employee, Third Party, or Client. If Third Party or Client is selected, Then the field titled “Caller Name/Location/Contact” needs to be required.  My research shows that the list validation formula should be  =IF(OR([Who’s Your Caller?]=”Client”,[Who’s Your Caller?]=”Third Party”),IF(ISBLANK([Caller Name/Location/Contact]),FALSE,TRUE),TRUE) When i test it, I select client and leave the Caller Name/Location field blank.  The list allows me to submit, with no error message. However after refreshing I get a error message stating “sync issues couldn’t upload new list item” (image of error below) .  This only appears after submitting the list item and purposely not meeting the validation I set forth above. At that point the only option given is to delete the items or save it (which downloads a csv). IT still does not state what the error is (although I know) or allow correction of the entry.  I would ideally like for the list to NOT allow to be submitted if the validation is not met. When they hit “Save” on the new list item, I want the error to pop up to advise that the field “Caller Name/Location/Contact” can not be left blank. It appears I have the formula correct for the validation. But how do i get the error message to display on the list item entry itself? I know how to accomplish this if I was using a form. I could use power apps to create an error message on the submit button. But since this is a list item not a form. Im not sure how to accomplish this. Any help would be appreciated. Thank you    Read More

​