I have built a form that also has a SharePoint form Validation formula. This validation formula works fine when I:
all have no issues. The problem comes up when I created a site workflow and try to update a field. This will give me
The workflow could not update the item, possibly because one or more columns for the item require a different type of information
Here is my validation formula
=IF(AND(CM="Yes",[CM Status]="No CM"),FALSE,IF(AND([Date Completed]<>"",[Work Start Date]=""),FALSE,TRUE))
The validation just checks two parameters:
The Site Workflow is trying to updates something that is not even related to the formula, which is to update the item Due Date.
If I take the validation away, the workflow runs without any issues, put that validation formula back, it throws the message. It's also worth mentioning that with the validation formula in place, regardless of what field I try to update, it throws the same error message.
What am I missing?
Thanks in advance for the help.
Hi Marian, please see the screenshot of the update. Like I said, no matter what field I update, it's all the same. It works great when the validation is taken out, but as soon as I put it back in, it throws the error.
Hi Marian, sorry for the late reply,
to answer your question, yes to all. The tracking log's QueryNumber is set to unique value on the sharepoint list. The data types have been set correctly as far as I know.
apparently your validation evaluates to false and causes error.
if you are sure workflow correctly identifies item(s) to update, and makes update correctly, you should examine item(s) being updated.
if you're not able to identify which field causes validation to fail, I would suggest to apply validation step by step from simplest expression up to complex ones.
eg. first just: CM="Yes"
then: [CM Status]="No CM"
then: AND(CM="Yes",[CM Status]="No CM")